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!
This exercise is part of the course
Reshaping Data with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Melt publisher column using title and authors as identifiers
publisher_melted = books_gothic.____(____=[____, ____],
value_vars=____)
# Print publisher_melted
print(publisher_melted)