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 vote251 views1 answer
Python enable pyqt errors
Python
0 vote292 views1 answer
Django cleanup settings
Python Django
0 vote256 views1 answer
Nested list flask
Python
9 votes255 views6 answers
Python absolute path
Python
0 vote258 views1 answer
Networkx create graph from dataframe
Python
0 vote257 views2 answers
Pandas rename columns by position
Python
2 votes275 views2 answers
Python jinja2 loop dict
Python
0 vote261 views1 answer
Convert_text_to_hexadecimal_viva.py in python
Python
0 vote265 views1 answer
How to repeat a python file
Python
43 votes260 views5 answers
Import sklearn
Python