Question: Pandas Stats For this assignment, we are going to use this dataset and observe some stats about it This dataset is 18000 video game reviews

Pandas Stats For this assignment, we are going to use this dataset and observe some stats about it This dataset is 18000 video game reviews from IGN. Directions: - Load data into Pandas dataframe using read_csv (Please have the csv file in the same directory as your program) - Print the shape of the dataframe - Remove the "Unnamed" column using iloc (or drop) - Print the title, genre and release year columns using .loc - Print the mean, max, and standard deviation for the scores of the dataframe - Convert the scores column to 100 base by multiplying it by 10 - Create a new dataframe that only includes the rows with a score above the mean score of the main dataframe (your new dataframe should have 11,373 rows) - Print a series that lists the count of scores by platform from the above mean dataframe sorted descending (PC should have 2191 for a count) Submit your working program for grading. This assignment is worth 15 points
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
