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

Exercise

Decrypting the code

You are doing a great job on the book project! Your boss encouraged you to do an analysis using books written by Dan Brown.

You explored the dataset books_brown and it needs reshaping. Again, you identified several columns to use as unique IDs and realized something different about the columns to group. Their name starts with a prefix, but this time, you identified a suffix and a separation element.

The books_brown dataset is available for you. It contains the title, author, and data about language_code, language_name, publisher_code, and publisher_name of each book. Make sure to examine it in the console!

Instructions 1/3

undefined XP
    1
    2
    3
  • Reshape books_brown from wide to long format, using the columns author and title as unique indexes. Name 'code' the new column created from the columns starting with language and publisher. Don't forget to examine the printed output.