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!
Diese Übung ist Teil des Kurses
Reshaping Data with pandas
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
# Reshape using author and title as index, code as new name and getting the prefix language and publisher
the_code_long = pd.wide_to_long(____,
____=____,
____=____,
____=____)
# Print the_code_long
print(the_code_long)