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 vote260 views1 answer
How to change the starting number for the loop count in pythin
Python
0 vote260 views2 answers
Python togli spazio
Python
19 votes242 views3 answers
Install mysql.connector
Python
1 vote265 views1 answer
How to get what type of file in python
Python
0 vote304 views1 answer
How to numbered jupyter notebook
Python
0 vote266 views1 answer
Applies the f function to all Row
Python
0 vote269 views1 answer
Python divide string in half
Python
0 vote279 views2 answers
Createview django
Python
2 votes320 views2 answers
Python fibonacci while loop
Python
30 votes290 views6 answers
Df drop column
Python