Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / Bite 5: Connect to a SQL dataset and query the tables
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

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

Posted
Updated
ByRuth Pozuelo Martinez

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

Let us know your thoughts...

Table of Contents