What are the top 5 destinations?
When analyzing data, it is often useful to know the key top/popular stats such as the most popular cities or the most famous restaurants etc. In this exercise, you will find the five most popular destinations (i.e., the five most popular end_station
s).
This exercise is part of the course
Data Manipulation with data.table in R
Exercise instructions
- Chain the following three
data.table
expressions:- Find the total number of trips to each
end_station
. - Arrange the total number of trips for each
end_station
in descending order. - Filter the top 5 rows.
- Find the total number of trips to each
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Top five most popular destinations
top_5 <- batrips[, ___, by = ___][___][___]
top_5