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 vote281 views1 answer
Convert negative to zero in list in python
Python
0 vote317 views1 answer
Django Signup form
Python
15 votes295 views2 answers
Python 3.9 beautifulsoup kurulumu
Python
1 vote296 views2 answers
Python spread operator
Python
0 vote282 views1 answer
List all subdirectories up to a level
Python
9 votes280 views1 answer
Cv2.cvtcolor grayscale
Python
0 vote301 views1 answer
Convert \x unicode utf 8 bytes to \u python
Python
1 vote310 views1 answer
Django get form id from request
Python
0 vote279 views1 answer
Python loop list from last to first
Python
1 vote270 views1 answer
Cannot be loaded as Python module
Python