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

2 votes142 views4 answers
Hack instagram account with python
Python
0 vote93 views1 answer
How to shift the x axis matplot lib
Python
0 vote132 views1 answer
Python set prcess name
Python
17 votes136 views3 answers
Making log files in python
Python
1 vote127 views1 answer
ModuleNotFoundError: No module named 'rospkg'
Python
95 votes140 views6 answers
Pandas dataframe sort by column
Python
0 vote139 views1 answer
Tb to pb with python calculator
Python
18 votes137 views4 answers
If __name__ == '__main__'
Python
5 votes161 views2 answers
Python get user home directory
Python
8 votes139 views1 answer
Jupyter column limit pd
Python