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.

👉 Instagram: @theaiwarriors

What Does a Data Science Executive Carry Around in 2019?

Laptop - 2018 MacBook Pro with Touch Bar
Tablet - 2017 9.7” iPad or

Home Setup for more intense analysis and editing:

Other options to run Python on a budget

Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)

Favourite Mobile Apps to Run Python and Code

Music:

Creative Commons — Attribution 3.0 Unported — CC BY 3.0

[theyvesyves]

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

[truckstomotorcycleswithtom]

Had a problem, got it worked out. This has been very helpful.

[pedro_em_bra]

great video, exactly what I am looking for

[torque]

Seriously, you have some great videos!

[marianlipana]

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.

[anthonyalvarez]

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?

[datagonia]

Instead of using string formatting, would it be okay to use an f-string? (for simpler syntax)

[PRIYANKASharma-uvlx]

Please made a video on jobless middle age woman no experience entry level Data analyst. How can we apply. What are the things needs to learn. Thanks

[thriftymarketing]

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?

[poornima]

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

[edbull]

sql = 'INSERT INTO salesdata ({}) VALUES ({})'.format(', '.join(df.columns), ', '.join(['?']*len(df.columns)))
Returns an error >>>> InterfaceError: Error binding parameter 5 - probably unsupported type.

[Shubhamsingh-egqv]

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]))
conn.commit()
con.close()
so if it is possible please suggest . thank you

[goodness]

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?