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

Exercise

Rating is not everything

Your first exploration of the books_gothic dataset was successful. Now, your next task is to perform a more detailed analysis. You need to reshape your DataFrame again. This time, you don't want to use all of your variables.

To that aim, you will melt your DataFrame, taking several approaches using different columns as identifiers and value variables.

The same books_gothic dataset you used before is available for you. It contains data about the title, author, number_pages, rating, rating_count, and publisher of each book. Make sure to examine it in the console!

Instructions 1/3

undefined XP
  • 1

    Define a new DataFrame by melting the publisher column using the title and authors columns as identifier variables.

  • 2

    Melt the rating and rating_count columns of books_gothic DataFrame using the title column as an identifier variable.

  • 3

    Melt the rating and rating_count columns of book_gothic using the title and authors columns as identifier variables.