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

Course Info:

Processing Large Datasets In Pandas

Intermediate

The average completion time for this course is 10-hours.

This course requires a premium subscription and includes 2 free missions, 2 paid missions, and 1 guided project.  It is the 3rd course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside

Show Buttons
Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit
Hide Buttons