Dropping missing data
Now that you've explored the volunteer dataset and understand its structure and contents, it's time to begin dropping missing values.
In this exercise, you'll drop both columns and rows to create a subset of the volunteer dataset.
This exercise is part of the course
Preprocessing for Machine Learning in Python
Exercise instructions
- Drop the
LatitudeandLongitudecolumns fromvolunteer, storing asvolunteer_cols. - Subset
volunteer_colsby dropping rows containing missing values in thecategory_desc, and store in a new variable calledvolunteer_subset. - Take a look at the
.shapeattribute ofvolunteer_subset, to verify it worked correctly.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Drop the Latitude and Longitude columns from volunteer
volunteer_cols = ____
# Drop rows with missing category_desc values from volunteer_cols
volunteer_subset = ____
# Print out the shape of the subset
print(____.____)