Print

Bite 5: Connect to a SQL dataset and query the tables

In this Bite we are going to learn:

1. Connect to a SQLite database
2. Drop a table
3. Query tables
4. Convert them to a Pandas dataframe

Practice the basics first

Jupyter Lab notebook available here when the video gets released on YouTube.

Bite 5: Get data from database, and query it with Pandas | Python mystery game

The challenge

The final output of this bite is the small program below.

The solution

Bite Solution 5: Get data from database, and query it with Pandas | Python mystery game
Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents