Adding a Category column to Excel data - using Excel techniques

A common problem in getting data clean and ready for analysis is adding a column that classifies the rows into a set of types (or groups, or categories). In this video we are assigning cities to sales regions based on their state. Three different techniques are shown and compared. The final technique is much quicker and less error prone than the obvious one.

[AhmedGarba-htup]

Thank you. This video made my life easier and was very useful in cleaning the data for my thesis.

[TheMisspattyb]

amazing tutorial. thank you for explaining so simply. saved me a ton of time!

[donjohnpalla]

this video saved my life ❤️ thank you so much for solving most of my problems with excel

[JdramaMedia_UGC]

thanks! very helpful! what about for 1 keyword only? let's say, tab#1 "Faulty Light L2" vs tab#2 "Faulty Light L3". Would selecting just the work "Light" be able to catergorize it in one Value?

[sniddee]

I liked your examples, but I need one step further. Let's say I don't want to assign each State a particular Region manually (there's 50 states; that's still a lot of work to assign each state a region, and let's say there were 100, 1000, states and I had to assign each of them to one of the 6 regions). How would you automate the assignment of a category to a long list of discrete cell values?

[asadkakuji]

How can we do this with machine learning, i need something more advamced than this, please let me know if you have any idea, thanks in advamce

[SandeepPatel]

If it's mobile number and the category is new and old what should i do

[SandeepPatel]

If it's mobile number what should i use

[andreaciambra]

you squint hard enough, it may sound like a young, still enthusiastic Ron Swanson is actually talking