Get startedGet started for free

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.

This exercise is part of the course

Analyzing Social Media Data in R

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Calculate and store the golden ratio
counts_df$ratio <- counts_df$___/counts_df$___

# Sort the data frame in decreasing order of follower count
counts_sort <- arrange(___, desc(___))

# View the first few rows
head(counts_sort)
Edit and Run Code