Minute 05:00 — 06:00 see that there’s duplicated data in there so just running a quick dedupe or or removing of duplicates that is really important to make sure that you have gotten rid of those things so Changing Column Names that’s one of the first things that i do we’re going to go into a lot of these different columns and i’m going to kind of show you different techniques or things that i do when i look at actual data so i’m going to come right over here i’m going to insert and this is what i actually do i usually create a separate column especially when i’m working with this because i don’t want to change this one i don’t want to go in here and you know say equals upper equals proper et cetera there’s a lot of different ways that you can change names or not a lot but the main ones that you can change names and all of them are completely okay so for example i’m going to hit equal upper oops upper and i’m gonna go like this and close my parenthesis so i selected the cell i close my parenthesis i hit enter it is comple and i’m gonna hit in the