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.
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?
SQLite is basically a form of sql. Data is stored by data type whether that’s text, int, date etc. It’s just a database. Since you started a new job and have a lot of excel, keep a look out later today and I got a vid coming out on exposing excel data to an Api in 10 lines of easy code. Pretty neat stuff
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?
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
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?
You need to re-run jupyter and either open the notebook in the directory where the file is located or start a new file and copy and paste the code. I believe it means that you are opening a jupyter kernel without a token
Just chiming in: I just tried this, and it helped by changing the python environment I was working in. I first used Anaconda with python 3.8, then i downgraded to pure Python 3.6. It could be as simple as a compatibility issue between package versions / python versions.
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
This channel is really underrated. Very simple, concise, and direct to the point. This is what the people need.
Thank you 🙏
@@SATSifaction thank you for this? Is it possible if to drop users in a text file from a database role in an Oracle database?
Had a problem, got it worked out. This has been very helpful.
great video, exactly what I am looking for
Very important video thanks
You’re welcome
Seriously, you have some great videos!
Thank you
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.
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?
SQLite is basically a form of sql. Data is stored by data type whether that’s text, int, date etc. It’s just a database. Since you started a new job and have a lot of excel, keep a look out later today and I got a vid coming out on exposing excel data to an Api in 10 lines of easy code. Pretty neat stuff
SATSifaction Thank you sir. Can we adapt this same logic for Oracle databases using cx_oracle package?
Instead of using string formatting, would it be okay to use an f-string? (for simpler syntax)
great thank you so much! very helpful
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?
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
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?
You need to re-run jupyter and either open the notebook in the directory where the file is located or start a new file and copy and paste the code. I believe it means that you are opening a jupyter kernel without a token
Just chiming in: I just tried this, and it helped by changing the python environment I was working in. I first used Anaconda with python 3.8, then i downgraded to pure Python 3.6. It could be as simple as a compatibility issue between package versions / python versions.
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
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
sql = 'INSERT INTO salesdata ({}) VALUES ({})'.format(' ,'.join(df.columns), ' ,'.join(['?']*len(df.columns)))
Returns an error >>>> InterfaceError: Error binding parameter 5 - probably unsupported type.
Will NOT ACCEPT >>>>> datetime64[ns] types as input value !!!! So either del date col or change it to other type !!!!