1. Learn
    2. /
  2. Courses
    3. /
  3. Reshaping Data with pandas

Exercise

What's your rating, Harry?

You fix yourself a coffee and keep working on your book project. For your next task, you need to get an appropriate dataset containing ratings for all the Harry Potter books. You gathered data from Goodreads as well as from Amazon.

You realized that you need a long format, but the dataset hp_books is in a wide format. You want to melt the data, but first, you need to manipulate some of the string columns.

The full title is divided into two columns. The authors column contains info about the writer and the illustrator.

Ratings for the Harry Potter books are in the DataFrame hp_books. Make sure to examine it in the console!

Instructions 1/3

undefined XP
    1
    2
    3
  • Concatenate the title and subtitle columns into a column named full_title. Use the word 'and' separated by spaces as a separating element.