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

20 votes143 views5 answers
Remove first character from string python
Python
1 vote213 views1 answer
Timer pythongame
Python
3 votes148 views1 answer
Python replace backslash with forward slash
Python
1 vote402 views1 answer
Python typed list
Python
0 vote175 views2 answers
Django edit object foreign key id
Python Django
0 vote130 views1 answer
Repeats in python
Python
0 vote170 views1 answer
Index and reversing a sub list in python list
Python
0 vote151 views1 answer
What is self
Python
-2 votes190 views2 answers
Create virtual environment python stack overflow
Python
0 vote147 views1 answer
Inicair venv python
Python