Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hands On Database

Authors: Steve Conger

1st Edition

013610827X, 978-0136108276

More Books

Students also viewed these Databases questions

Question

Distinguish between an open- and closed-end mutual fund.

Answered: 1 week ago

Question

I dont trust that theyll keep my complaint confi dential.

Answered: 1 week ago

Question

3. What may be the goal of the team?

Answered: 1 week ago

Question

Is how things are said consistent with what is said?

Answered: 1 week ago