Question: How to get this plot? Part 1: Getting a Feel for the Data Before doing any data analysis, you should determine what your data looks

 How to get this plot? Part 1: Getting a Feel for

How to get this plot?

Part 1: Getting a Feel for the Data Before doing any data analysis, you should determine what your data looks like! Task 1.1 (3 points) Task: Write a piece of code that reads in the data file openpowerlifting_data.csv and prints out the descriptive information about the data (e.g., Columns, number of entries, mean values, etc.). Write a print statement that prints the number of lifters in this dataset. NOTE: From your previous work with this data, you recall the following: A minus sign in front of a lift (i.e. -200.0) means a missed/failed lift The weight class, best squat, best bench, best deadlift, and total measurements are in kilograms (kg) The IPF weight classes for women are: 47 kg, 52 kg, 57 kg, 63 kg, 72 kg, 84 kg, 84 kg+ The IPF weight classes for men are: 59 kg, 66 kg, 74 kg, 83 kg, 93 kg, 105 kg, 120 kg, 120 kg+ Competitors are assigned to a weight class by the nearest class above their bodyweight (i.e. if they weigh 50.25 kg, their weight class is the 52 kg class) with the exception of competitors in the 84kg+ of 120kg+ categories where the competitors have bodyweights greater than the listed weight class. Task 1.2 (3 points) Choose one of the lifts (i.e., squat, bench, or deadlift) and make a scatter plot of best lift weight vs competitor bodyweight. (Be sure to label your axes) In [11]: # Put your pseudocode and code here 1 2 3 Out[11] Name Sex Equipment Age Division Bodyweightkg WeightClasskg Best3 SquatKg Best3BenchKg Best3DeadliftKg Totalkg Dots Countr 0 0 Alicia Urbaniak F Raw NaN Open 46.50 47 60.0 51.0 97.5 208.5 275.43 Polan 1 Patrycja Nowak F Raw 25.5 Open 45.40 47 62.5 40.0 100.0 202.5 272.34 Polan 2 Klaudia Rusztyn F Raw 20.5 Open 51.80 52 97.5 52.5 148.0 298.0 364.21 Polan 3 Ewa Mioduszewska F Raw 24.5 Open 51.20 52 100.0 50.0 145.0 295.0 383.49 Polan 4 Katarzyna Synak F Raw NaN Open 51.30 52 100.0 57.5 125.0 282.5 347.81 Polan 5 Patrycja Jurga-Murcha F Raw 31.5 Open 51.00 52 85.0 50.0 130.0 265.0 327.43 Polan 6 Joanna Stankowska F Raw NaN Open 52.00 52 75.0 40.0 95.0 210.0 255.07 Polan >

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!