 It's LinkedIn learning author Monica Wahee with today's data science makeover. Watch while Monica Wahee demonstrates how to make a vector of unique values from one column in a data frame in R. Hi there. So I got the line items data set right here, my little fake data set, my little demonstration data set. And I already ran a call names command on it, so we can see the column names. If you don't know how to do that already, just go to the description in this video, I put a link there. So see how report ID is a second column, and also use SQL types probably guessed it's a foreign key. Okay, we are getting very sequely here already. So let's face it, maybe we want to know all of the unique report IDs in this column. I'm just saying. So Dorothy, we are not in SQL anymore. We are in R, but we can still do sequely things. First, we are going to load report ID into a vector. I made two alternative codes for you. See these two commands? They do the same thing. It's just that the top one refers to report ID by its field name in line items. And the bottom one refers to it using the number style. See this? Both ways, I'm going to load the whole column report ID into a vector called report ID underscore column. Am I going too fast for you? If you are kind of uncomfortable with loading things from a data frame into a vector, look in the description for another video where I talk more about that. I personally prefer the word way, not the number way. So I will ghost the number way and run only the word way. Okay, so the first thing we will want to look at is, oh yeah, what's in it? Let's just run this new vector. What do we see? Doops, doops. All right. First, how long is this puppy? All right, let's just run a length command on this vector. I always run a length command before messing with the vector. We want to make these values unique. We are basically deduping the vector. So we want to know how long it is before we do that. The length command is just the word length and then one argument in parentheses with the vector in it. There's probably other things you can do, but this is all I do with the length command. So we'll run it. Oh, see that in the console? 95. Now, here's what you've been waiting for, the unique command. See that? Like the length command, all you do is put unique, then the vector in parentheses. See there? I'm putting the result in another vector. That way I can go back to the old one if I have a question. Gonna run this now. Okay, let's look at the new vector. Yeah, looking good. No doops. How much weight do we lose? Let's look at the length of that puppy. Oh, yeah. Down from 95 to 30. Beautiful. So sleek. Another successful makeover. Thank you for watching this Data Science Makeover with LinkedIn Learning author, Monica Wahee. Remember to check out Monica's Data Science courses on LinkedIn Learning. Click on the link in the description.