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.
This exercise is part of the course
Data Manipulation in Julia
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Sort chocolates by cocoa column
____