Question: Often when presented with a data table, additional cleaning and filtering may be required before you can analyze the data the way you want to.

 Often when presented with a data table, additional cleaning and filtering

Often when presented with a data table, additional cleaning and filtering may be required before you can analyze the data the way you want to. There are many ways to do this, but most involve "masking" the data in some way--removing everything from your data except the values that you want, usually based on some condition. In your exploration in Part 1, you may have noticed some entries for competitors who did not achieve a total, create a new data frame that contains only competitors with a valid total. Hint: There are built in Pandas functions that can help you with this. 1 # Put your pseudocode and code here 2 The next task in this assignment will require you to do analysis on one weight class. Create a new dataframe for the weight class that you want to work with. Recall that the weight classes we want to focus on in this dataframe are: Women: 47 kg, 52 kg, 57 kg, 63 kg, 72 kg, 84 kg, 84 kg+ Men: 59 kg, 66 kg, 74 kg, 83 kg, 93 kg, 105 kg, 120 kg, 120 kg+ 1 2 # Put your code and psedocode here How many entries are in your cleaned dataframe? How do you know that your masking is working? Put your answer here

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!