Exercise 6: Working with Pandas dataframes

Create a new, clean IPython notebook to contain your homework submission. Download items.csv Download items.csv

Using the items.csv file and the pandas techniques we have been learning in class this week:

1. Clean the price, bedrooms and sqft fields and make each a float type
2. Calculate the mean, minimum, and maximum rent price, bedrooms and square footage
3. Create a subset dataframe with listings between $200 and $10,000, and excluding listings with missing values on bedrooms or square footage
4. Calculate the mean, minimum, and maximum rent price, bedrooms, and square footage on this filtered subset
5. Create histogram plots of the full dataset and the filtered dataset, for price, bedrooms and sqft

Use comments to document all of your logic throughout the notebook. Make sure your entire notebook runs properly and without any errors. Click Kernel > Restart > Clear all outputs and restart. This clears your memory and re-initializes your notebook. Then click Cell > Run all and make sure everything behaves properly. Then submit your .ipynb file via bcourses.