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 vote188 views1 answer
How to fill an array with consecutive numbers python
Python
2 votes181 views1 answer
Django setup allowed hosts
Python
3 votes205 views2 answers
Python try without except
Python
0 vote195 views1 answer
Parquet to dataframe
Python
0 vote199 views1 answer
Save datetime day in seperate column
Python
2 votes192 views1 answer
Mulitplication symbo for unpacking in python
Python
0 vote180 views1 answer
InsertionSort
Python
0 vote208 views1 answer
How to give autocomplete in python
Python
1 vote177 views1 answer
TypeError: unhashable type: 'list' python dictionary
Python
0 vote181 views1 answer
Get the first element that is larger than
Python