Summary
This chapter presents an overview of acquiring, reading, and storing data in widely used formats such as CSV, Excel, JSON, HDF5, Parquet, and Pickle, which are commonly used in real-world data analysis workflows. It also covers storing data in relational databases like SQLite and MySQL, along with NoSQL databases such as MongoDB, Cassandra, Redis, and Neo4j, which are increasingly important in Big Data and web applications due to their flexibility, speed, and schema-free design. In addition, the chapter introduces Neo4j for graph-based relationship-rich data, cloud storage platforms such as Amazon S3 and Azure Blob for scalable ETL and analytics pipelines, and REST and GraphQL APIs for extracting JSON data from external systems using Python libraries like requests and httpx.
The next chapter is about the important topic of data preprocessing and feature engineering with Python. The chapter starts with exploratory data analysis and leads to filtering, handling missing values...