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:

Processing Large Datasets In Pandas

Intermediate

The median completion time for this course is 5.3 hours.

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

START LEARNING FREE