Summary
As we talked about at the beginning of the chapter, accessing and storing data are foundational for data science. In this chapter, we learned how to open plain text files, deal with JSON data, and read and store data with SQL through the sqlite3
module and SQLAlchemy package in Python. There are many other ways to interact with data stores in Python as well, including packages in Python for interacting with big data and cloud resources, packages for interacting with NoSQL databases such as MongoDB, and the pandas
package. In fact, we're going to learn how to utilize pandas
for handling data in the next chapter.