Lump it Together
What's the average "influence score"?
(Hint: use .mean() )
81.82
What's the maximum number of posts any of the top 200 influencers has?
17500
How many rows and columns does the dataframe have?
200 rows, 10 columns
Whats the number of likes for all 200 the top Instagram influencers?
( Hint: use .sum() )
731,622,500,000
Who has the least number of posts?
badbunnypr
What is the data type (Dtype) of the total_likes columns?
float64
How many of the top 200 influencers have a 60 day engagement rate of over 1.5 ?
65
Which influencer from the United States has the lowest 60 days engagement rate?
emmawatson
total_likes
What's the average "influence score" for influencers in the USA?
84.21
How much higher is the highest 60 day engagement rate than the average?
(Hint: What's the highest engagement rate? What's the average engagement rate?)
24.5
Whats the average number of posts for the last 5 influencers?
(Hint: use .tail() )
2674
How many of the influencers with more than 100,000,000 followers and more than 2000 posts are from the USA?
(Hint: make copies of the dataframe that contains your target data)
14
What's the ratio of followers between the influencer from the United States with the most followers and the influencer from Brazil with the most followers?
(Hint: followers from USA divided by followers from Brazil)
around 2.07
How many times more followers do the first 5 influencers have compared to the last 5 influencers?
(Hint: Divide the head by the tail)
11.34