Importing Data: Python Data Playbook

In order to work with data in Python, you need to know how to get data into Python. This playbook defines data import recipes for common data import problems you’ll encounter using Python.

Python is one of the most powerful and widely used languages to work with data. In this course, Importing Data: Python Data Playbook, you will learn foundational knowledge and gain the ability to import data from multiple different file formats, including: text, tabular data, binary formats as well as from databases. First, you will learn how to import text and CSV files. Next, you will discover how to import data from JSON, XML, SAS, Stata, HDF5, Matlab, Pickle files, and more. Finally, you will explore how to import relational data from databases, including: SQLite, MySQL, and PostgreSQL. When you're finished with this course, you will have the skills and knowledge of importing data into Python needed to analyze, visualize, and in general work with data.

Topics:

• Course Overview
• Importing Text Data into Python Using NumPy
• Importing CSV Data into Python Using csv and pandas
• Import Data into Python from JSON and XML Files
• Import Data into Python from Excel Files
• Import Data into Python from Common Binary Data File Formats
• Import Data into Python from Relational Databases