208|PYTHON – TikTok Earnings

Challenges
, , ,
1

BYU Student Author: @Jason_Nguyen
Reviewers: @Keanu_Gauthier, @Michael_Barney, @Sterling_Lane, @Millie_K_B
Estimated Time to Solve: 20 Minutes

We provide the solution to this challenge using:

Need a program? Click here.

Overview
You have a friend, Alice, who is a rising TikTok influencer. She has been active on TikTok for a while and is curious about the trends in earnings and views from the videos she’s posted. Alice knows you have previously analyzed influencer data and wants to draw on your expertise. Your task is to help Alice analyze her TikTok earnings and video views and you decide to utilize Python to present your findings.

Instructions

  1. Put Alice’s TikTok data to a directory shared with your Python file

  2. Load the excel data in Python. Alice exported the data every few months, so she is worried there may be some duplicates.

  3. Alice would also like a new column that categorizes videos based on views.
    a. Low Views: Less than 10,000 views
    b. Medium Views: 10,000 to 30,000 views.
    c. High Views: More than 30,000 views.

  4. Display the table

  5. Create a line graph showing earnings overtime by quarter

  6. Create a bar chart in Python that displays the total number of views for each category (Low, Medium, High) in the newly created views category

  7. Review the graphs. What quarter of the year does Alice struggle in?

Data Files

Suggestions and Hints

  • Use the pandas to import the data tables

  • Use matplotlib to visualize the data

Solution

Challenge208_PYTHONSolution.ipynb

Solution Video: Challenge 208|PYTHON – Description