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 vote335 views1 answer
Celery beat command for django celery beat
Python Django
0 vote304 views3 answers
Python nc group variables
Python
0 vote256 views1 answer
Sentinel policy for tag
Python
0 vote310 views2 answers
Matplotlib subtitle
Python
0 vote311 views1 answer
Install older version of python
Python
20 votes322 views3 answers
Convert a number column into datetime pandas
Python
2 votes289 views4 answers
Eval function
Python
0 vote302 views1 answer
List of files to zip python
Python
0 vote324 views1 answer
Django listview
Python Django
-1 vote347 views1 answer
How to normalize a 1d numpy array
Python