The files we will be working with in this chapter can be found in the GitHub repository at https://github.com/stefmolin/Hands-On-Data-Analysis-with-Pandas-2nd-edition/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
There are four CSV files and a SQLite database file, all of 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 and a subset of the columns from the
earthquakes.csv file. The
tsunamis.csv file is a subset of the data in the
earthquakes.csv file for all earthquakes that were accompanied by tsunamis during the aforementioned date range. The
quakes.db file contains a SQLite database...