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

69 votes313 views5 answers
Get text from txt file python
Python
4 votes323 views3 answers
ArrayField in Django
Python
3 votes306 views2 answers
Python custom exception
Python
1 vote346 views2 answers
Python merge pdf files into one
Python
0 vote320 views1 answer
Re date python
Python
0 vote318 views1 answer
Python read binary trj file
Python
0 vote328 views1 answer
Set list start at 1 python
Python
155 votes367 views6 answers
Python os if file exists
Python
0 vote332 views1 answer
Fibonacci series in python using for loop
Python
1 vote324 views1 answer
How to swap in list in python
Python