Exercise

Chocolate location pivot

Your colleague wonders if some countries tend to make more dark or more milk chocolates. And what their median ratings are. Now that you are armed with the knowledge of pivot tables, you can help answer this question. Can you spot any trends?

There is a new column in the dataset, called cocoa_rounded. It contains the values of cocoa, rounded to the nearest decimal, and cast as a string to make better labels. You are going to use it in your calculation to reduce the number of columns in your pivot table. Feel free to investigate and experiment further though!

The chocolates dataset and the DataFrames and Statistics packages have been loaded for you.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Sort chocolates by cocoa column, mutating the original DataFrame.