Exercise

Explore users based on the golden ratio

The ratio of the number of followers to the number of friends a user has is called the golden ratio.

This ratio is a useful metric for marketers to strategize promotions.

In this exercise, you will calculate the golden ratio for the aggregated data frame counts_df that was created in the last step of the previous exercise.

The data frame counts_df and library dplyr have been pre-loaded for this exercise.

Instructions 1/2

undefined XP

1

2

Calculate the golden ratio and store it in a new column.
Sort the data frame in decreasing order of follower count.