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

1 vote90 views1 answer
Radiobuttons django
Python
0 vote122 views1 answer
Apply numba to itertools import product
Python
13 votes95 views5 answers
Pandas Set index
Python
20 votes108 views2 answers
Cv2 not found
Python
0 vote127 views1 answer
Set value through serializer django
Python Django
35 votes114 views2 answers
How to run cmd line commands in python
Python
0 vote97 views2 answers
Grid list python
Python
2 votes104 views1 answer
Download pdf from link using python
Python
-1 vote144 views2 answers
How to url encode using python django
Python Django
2 votes101 views1 answer
Flask session timeout
Python