Hands-On Data Analysis with Pandas

Exercises

Using the CSV files in the exercises/ folder and what we have learned so far in this book, complete the following exercises:

1. With the earthquakes.csv file, select all the earthquakes in Japan with a magType of mb and a magnitude of 4.9 or greater.
2. Create bins for each full number of magnitude (for example, the first bin is 0-1, the second is 1-2, and so on) with a magType of ml and count how many are in each bin.
3. Using the faang.csv file, group by the ticker and resample to monthly frequency. Make the following aggregations:
   • Mean of the opening price
   • Maximum of the high price
   • Minimum of the low price
   • Mean of the closing price
   • Sum of the volume traded

4. Build a crosstab with the earthquake data between the tsunami column and ...