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

Exercise

Elementary, dear Watson!

It's Friday, and you are about to finish working on your book project. For your last task, you will analyze data about Arthur Conan Doyle's books.

You realize your dataset, books_sh, needs reshaping. You notice there are columns that can be grouped using a prefix. You identify the columns to use as unique IDs. However, some of these columns contain strings. They need some manipulation before applying a wide to long transformation. You decide some of the strings need splitting to make the DataFrame cleaner.

The books_sh dataset is available for you. It contains the title, and data about version, number_pages, and number_ratings of each book.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Split the main_title column into two columns called title and subtitle. Use a colon as the delimiter.