1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Social Media Data in R

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.