Selecting patterns
Switzerland, Belgium, Ecuador, … these countries and many more are associated with the best chocolate. But does our dataset agree? Let's look at the columns containing information regarding reviews and location!
The DataFrames
package and the chocolates
dataset have been loaded for you.
This exercise is part of the course
Data Manipulation in Julia
Exercise instructions
- Select columns starting with the letter
r
and columns ending withlocation
and save the new DataFrame asreviews_locations
. - Sort
reviews_locations
in place using therating
column in descending order.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Select columns starting with r and columns ending with location
reviews_locations = ____(____, ____, ____)
# Sort reviews_locations using the rating column
____(____, ____, rev = true)
println(first(reviews_locations, 5))