Pandas code

Setup code for pandas in python

# Read Excel sheet with pandas and using Sqlite DB

# Setup code 

engine = create_engine('sqlite://', echo=False)
df = pd.read_excel(file, sheet_name=sheetname)
df.to_sql("test", engine, if_exists="replace", index=False)
results = engine.execute("Select * from test")
final = pd.DataFrame(results, columns=df.columns)

Source: grepper.com

Similar codes

0 vote147 views1 answer
Django refresh form db
Python
0 vote140 views1 answer
Python subprocess.run output
Python
0 vote134 views1 answer
Using csv module how to read perticular lines in csv
Python
112 votes146 views5 answers
Python string cut last n characters
Python
0 vote187 views1 answer
How to get the current url path in django template
Python Django
7 votes132 views2 answers
Shorthand python if
Python
-1 vote137 views1 answer
Python numpy euler
Python
0 vote126 views1 answer
Show avg value in sns boxplot
Python
0 vote140 views1 answer
Even numbers from 1 to 100 in python
Python
-2 votes184 views1 answer
Jwt authentication python flask
Python Flask