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

20 votes227 views2 answers
How to create string in python
Python
2 votes208 views1 answer
Tkinter info box
Python
0 vote233 views1 answer
Python - retrieve unconnected node pairs
Python
0 vote206 views1 answer
Re mobile no validate python
Python
0 vote205 views1 answer
How to query json field django
Python
0 vote217 views1 answer
Change the frequency to column in pandas
Python
0 vote226 views1 answer
Odoo order by xml rpc
Python
1 vote208 views1 answer
Pyspark new column
Python
5 votes177 views1 answer
Automate the boring stuff with python
Python
0 vote236 views1 answer
Read emails from gmail python
Python