Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started