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 vote340 views1 answer
Pandas read csv encoding thai
Python
1 vote339 views1 answer
Append a dataframe to an empty dataframe
Python
3 votes341 views1 answer
Install re package python
Python
0 vote341 views1 answer
Find & replace in csv file
Python
0 vote346 views2 answers
Fix ImportError: No module named PIL
Python
0 vote346 views1 answer
Soustraire deux listes python
Python
0 vote324 views1 answer
Getting multiple of 5 python
Python
1 vote315 views1 answer
Install python cap
Python
0 vote369 views1 answer
Count proportion pandas
Python
0 vote337 views1 answer
File handling in python append byte
Python