Chapter 3: Data I/O
In the previous chapter, you learned how pandas stores information in Series and DataFrames, and were introduced to the .read_csv()
and .to_csv()
methods, which are used to read data from a storage drive into DataFrames or Series and save data in a CSV file. In this chapter, you will learn about a range of other data sources, including different file formats and data from web pages and application programming interfaces (APIs). By the end of this chapter, you will be comfortable with getting data into pandas from a wide range of common sources, enabling you to work with different teams in your organization.
In this chapter, we will cover the following topics:
- The world of data
- Exploring data sources
- Fundamental formats
- Additional text formats
- Manipulating SQL data
- Activity 3.01 – using SQL data for pandas analytics