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

Join this channel membership to get access to all the recorded bites as they become available:

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

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10

Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[jonathanjedrczak]

Hi Ruth, thanks for the video. I'm not a Python expert, but one little bit I'd do differently is using different variables name throughout the code instead of always using df. In this example, instead of saying df = df. to_list... I'd do something like df_list = df.to_list... That should stop you needing to go back to run earlier steps

[natsarev]

Hi Ruth, hope that part with "Type 1 for table.." is not just a text because I've spent some time to make it dynamic depending on the number of tables in db :) So I'm ready for the next lesson! 🤗

[scvslsravikiran]

Hey Ruth,
Please show on how to handle the empty name case also. I am able to just press enter and flow goes on...
""
A crime has taken place and Curbal Crime Labs (CCL) needs your help.
The crime is a murder that occurred sometime on Jan.15, 2018.
and a crime data analyst or curbalist as we call it at CCL,
is needed to help solve the case.

All the crime files will be provided to you
but before we do that:

Do you accept the challenge? (y/n)
y

What is your name?


Hi ! Welcome to Curbal Crime Labs.
Let's get you inciated! """

[rajagopalreddy]

Hi, I am not getting any data when i run the table of Crime Scene Report

[robinback]

How do I get the crime db? I am developing on my own computer.

[richardmartin]

I am finding the murder-mystery database is empty. Also that is awful way to do SQL. Doing anything with that structure would be a pain.