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 vote147 views1 answer
Time df.apply() python
Python
1 vote278 views1 answer
Flask render error template
Python Flask
9 votes286 views2 answers
Post request with proxy python
Python
0 vote158 views1 answer
Python convert images to pdf
Python
1 vote179 views1 answer
Two elements at a time in list comprehension
Python
0 vote196 views1 answer
Python list of datetimes as type string
Python
1 vote168 views1 answer
Required_fields = []
Python
2 votes173 views2 answers
Can immigrants vote in uk
Python
0 vote213 views1 answer
Python http request params
Python
28 votes155 views6 answers
Pandas create empty dataframe
Python