Create and Query SQL Database with Python | SQL and Pandas


In this video you will learn how to create and query an sql database with pandas

Learn how to build a machine learning API that connects to a back end machine learning model and returns a response based on feedback from the ML model.

πŸ‘‰ Patreon:
πŸ‘‰ Facebook Group:
πŸ‘‰ Instagram: @theaiwarriors
πŸ‘‰ Corporate Training and Up skilling:

Netfirms (Affiliate) –
Bluehost (Affiliate) –
Heroku –
NordVPN (Affiliate) –

βœ… Here is a link to my python for beginners, master python course:

What Does a Data Science Executive Carry Around in 2019?

Bag – (will fit laptop plus one tablet and a few accessories)
Laptop – 2018 MacBook Pro with Touch Bar
Tablet – 2017 9.7” iPad or
Tablet – Amazon Fire HD 10 –
Folding Keyboard –
Power Bank –
Bose QC35 –

Home Setup for more intense analysis and editing:

AMD MSI Vega 56 Graphics Card –
Razor X Core egpu with thunderbolt 3 –
Two LG 29” Ultrawide Monitors –

Other options to run Python on a budget

Raspberry Pi Starters kit –
Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)
Minimalist Keyboard and Mouse –

Favourite Mobile Apps to Run Python and Code
iOS – Pythonista (paid) –
Android – Dcoder (free) –


Finally by Loxbeats
Creative Commons β€” Attribution 3.0 Unported β€” CC BY 3.0
Free Download:
Music promoted by Audio Library



Comment List

  • SATSifaction
    December 16, 2020

    I have been trying to replicate the code with a excel file that has spaces in the name and it is crashing. How can I compensate for a sheet that has headers with spaces in the file?

  • SATSifaction
    December 16, 2020

    Hi ..i have tried the same code but my data has varchar and integers along with date data types .. i see this error
    "InterfaceError: Error binding parameter 6 – probably unsupported type."

    any solution please

  • SATSifaction
    December 16, 2020

    getting "OperationalError: near ".": syntax error" when running: c.execute("CREATE TABLE IF NOT EXISTS sales ({})".format(' ,'.join(df.columns)))

  • SATSifaction
    December 16, 2020

    hi sir, thank you for this vedio ,
    but as Iam new in python and data base so I am not able to solve this error : OperationalError: near "DATE": syntax error which is occurring as i execute this code
    import sqlite3

    import pandas as pd

    conn = sqlite3.connect('xldb.db')

    df = pd.read_excel('Option.xlsx')

    c = conn.cursor()

    c.execute("CREATE TABLE IF NOT EXISTS xldbdata ({})".format(','.join(df.columns)))

    #to check how many row and colum are ther we use (df.shape)

    # it will iterate all rows and columns

    for row in df.iterrows():

    sql = 'INSERT INTO xldbdata ({}) VALUES ({})'.format(','.join(df.columns), ','.join(['?']*len(df.columns)))

    c.execute(sql, tuple(row[1]))


    so if it is possible please suggest . thank you

  • SATSifaction
    December 16, 2020

    great thank you so much! very helpful

  • SATSifaction
    December 16, 2020

    Very on point video! Exactly what I was looking for as a guide for my programming assignment πŸ™‚ But I have a question, how would I assign data types for each of the columns? Thanks in advance.

  • SATSifaction
    December 16, 2020

    While I let this code run: 'c.execute('CREATE TABLE IF NOT EXISTS sales ({})'.format(' ,'.join(df.columns)))' , the system of jupyter notebook responsed me the message of error: ' OperationalError: unrecognized token: ":" ' .
    How could I solve this problem?

  • SATSifaction
    December 16, 2020

    Awesome video! I just started a new job and have so much different data coming from excels and csv's, that I was looking for a quick way to get it all into SQL. Question: what are the datatypes that get set into sqllite? Are all the columns shown as strings?

  • SATSifaction
    December 16, 2020

    This channel is really underrated. Very simple, concise, and direct to the point. This is what the people need.

Write a comment