MISSION 166

Augmenting Pandas With SQLite

Learn the pandas SQLite workflow to combine the best of both tools.

Objectives

  • How to use pandas with SQLite.
  • Learn when to use disk space over in-memory space.
  • Learn to run SQL queries using pandas.

Mission Outline

1. Augmenting Pandas With SQLite
2. Pandas Types vs. SQLite Types
3. Setting Appropriate Types
4. Computing Primarily in SQL
5. Computing Primarily in Pandas
6. Reading in SQL Results Using Chunks
7. Next Steps
8. Takeaways

pandas-large-datasets

Course Info:

Intermediate

The median completion time for this course is 5.3 hours. View Details

This course requires a premium subscription and includes three missions, and two guided projects.  It is the third course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside