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 vote318 views1 answer
Calling function whose name is in a variable
Python
57 votes322 views4 answers
Get date and time in python
Python
6 votes338 views1 answer
How print ?
Python
0 vote314 views1 answer
How to use the dot lower function
Python
5 votes327 views1 answer
Tkinter maximum window size
Python
-1 vote313 views2 answers
Crop image python
Python
0 vote307 views1 answer
Python check if ip is up or down
Python
3 votes330 views3 answers
Python play music
Python
0 vote300 views1 answer
Python slice a list a specific amount of times
Python
3 votes323 views1 answer
Pandas groupby column count distinct values
Python