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 vote236 views1 answer
Metodo estatico de python
Python
1 vote154 views2 answers
How ro have a incresing variable in python
Python
0 vote138 views1 answer
Opencv waitkey example
Python
5 votes149 views4 answers
Prime numbers from 1 to 100 in python
Python
1 vote142 views1 answer
Logging python utf-8
Python
0 vote142 views1 answer
Python - match two df on a variable with different name
Python
0 vote133 views1 answer
Python pyqt5 checkbox trigger
Python
0 vote241 views1 answer
Python placeholder
Python
0 vote137 views1 answer
Response object has no code
Python
0 vote143 views1 answer
Hidden semi markov model python from scratch
Python