I have a dataset as follows

last_name  first_name  age   Description     Hobby
Smith       John       20    In high school  Music
Johnson     Robert     45  Software Developer Gardening
Williams    David      15     Junior school  Baseball
Davis       Michael    65     Traveler       Skydiving  
Miller      Molly      25     Scientist      Cycling 

Now I got a question from a assignment that Aggregate text data under “Description” and “Hobby”

I cannot understand what is the meaning of Aggregate text data?

If any one understand the question please share their view point. I want to know it theoretically how could any one aggregate text data depend upon description and Hobby column.

This is a coding assignment of python. But currently I don't bother about coding. I want to know the theoretical meaning of this question and want to solve it manually.

Thank you in advance


2 Answers 2


My assumption is that they want you to normalize the text data in those columns. In other words, you may create a collection of the text, and the two columns would refer back to that collection. Does that make sense?

  • $\begingroup$ I'm also trying to answer your question without giving too much away. ;) $\endgroup$ Apr 26, 2019 at 22:37

Create two lists,

descriptions = [ ],hobbies = [ ]

Iterate through the rows of data and append the description and hobby for each row to the appropriate lists.

Aggregated data is now stored in the descriptions and hobbies lists


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.