The files we will be working with for this chapter can be found in the GitHub repository at https://github.com/stefmolin/Hands-On-Data-Analysis-with-Pandas/tree/master/ch_02. We will be working with earthquake data from the US Geological Survey (USGS) by using the USGS API and CSV files, which can be found in the data/ directory.
There are four CSV files and a SQLite database file in the data/ directory, which will be used at different points throughout this chapter. The earthquakes.csv file contains data that's been pulled from the USGS API for September 18, 2018 through October 13, 2018. For our discussion of data structures, we will work with the example_data.csv file, which contains five rows from earthquakes.csv for a few columns. The tsunamis.csv file is a subset of this data for all earthquakes that also had tsunamis during the aforementioned date...