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

10 votes170 views5 answers
Create pickle file python
Python
1 vote115 views1 answer
Remove nas from dataframe in python
Python
0 vote167 views2 answers
Loading bar
Python
8 votes155 views1 answer
How to write a font in pygame
Python
11 votes157 views3 answers
Username Python
Python
0 vote175 views1 answer
How to check if a cell is empty in openpyxl
Python
0 vote166 views1 answer
Python use variable name as variable
Python
1 vote178 views1 answer
Pandas drop column by index range
Python
5 votes161 views2 answers
Matplotlib python background color
Python
0 vote174 views1 answer
> not supported between tuple and int
Python