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

6 votes347 views2 answers
Python - count total numeber of row in a dataframe
Python
0 vote323 views1 answer
Openpyxl add worksheet
Python
1 vote313 views1 answer
Discord python command alias
Python
0 vote324 views1 answer
Python polyfit with errors
Python
0 vote313 views1 answer
How to remove time in datetime in python
Python
0 vote312 views1 answer
R stagazer html knit
Python
0 vote321 views1 answer
Get more than one decimal in python
Python
8 votes316 views6 answers
Declare variable in python
Python
13 votes365 views2 answers
Wap in python to check a number is odd or even
Python
17 votes376 views4 answers
Substring in python
Python