High Level Description
In our data we want to assign each row into a specific category. There are only possible 7 categories.
Our program simply looks for specific keywords and searches through the title. If it finds the keyword then it assigns it that category,
else it move to next category keywords and so on. So, essentially we want to find out all the different keywords to assist the program.
Below are 2 tasks:
In attached spreadsheet there are 1000 rows. We simply want someone to go through all of them and do following:
a. Based on title, find out all the keywords that would put it in right category. Then add it to the keywords cell in Category spreadsheet.
(So basically, we want to add all possible keywords). They need to be separated by comma.
b. We want to also tell us the order in which we should lookup for categories. i.e. based on different keywords it
is possible that the keywords can classify it in multiple category. So, in that case we should know when searching what order we should look at.
Food & Dining dinner, lunch
Travel & Accomodation hotel, motel
Stay at Hotel in CBD with free dinner
So, as you can see it can would satistfy both categories. However, we want to put it into Travel & Accomodation. So, in terms of order
we want to first search for Trave & Accomodation keywords and then Food & Dining.
c. It would be good against each title, in next column if you could type the keyword and also what category. This is mainly
so I know that you have infact gone through 1000 rows.
alternatively, if you programmer you can quickly write a short program that would automatically do above and test that the keywords you have written are correct. I prefer the later as it is quicker and more reliable.
NOTE: I have included Description (Column B). That is only for reference for you to understand the data. Please pick keywords from
Title (Column C) only.
This should be really quick. We certainly don't expect 1000 keywords as it shouldn't take that many keywords.
Its a very simple task and should take no time and is no brainer. I might have gone a bit overboard with the explanation. In summary, you simply have to read a title (max 10 words) and extract keyword and right it in the category. Thats it.
Idea is to go through 1000 items, after 600-700 you should have to type in any new keyword.