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

Exercise

Gothic times

You have a new project! Your boss has asked you to perform an analysis with a dataset of books. You have several tasks to complete. Your first task is to analyze Gothic fiction books.

The dataset books_gothic is in a wide format. Any analysis will require you to reshape the data into a long format. To that aim, you will melt your dataset. You will reshape the dataset using several variables as identifiers to decide which is the best format.

The books_gothic dataset is available for you. Make sure to examine it in the console!

Instructions 1/2

undefined XP
  • 1

    Define a gothic_melted DataFrame by melting the books_gothic DataFrame, using only the title as an identifier variable.

  • 2

    Melt the books_gothic DataFrame, now using the title, authors, and publisher columns as identifier variables.