This part of the chapter will show you how to load data in the computer memory. This is, of course, essential to all the downstream work and analysis that you plan to do.
Types of data sources and loading into pandas
Databases
A relational database is one of the most common ways that enterprises can store data. So, loading from and interacting with databases is essential for most fieldwork. The Python library that we will use is sqlite3 and is included in Anaconda's package. Let's begin by connecting to the database, which is stored in a .db file, and included with the book materials. After we connect to the database, we will create a cursor object that we will use to traverse the object during a query. Next, we...