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

35 votes171 views6 answers
Python for in range
Python
0 vote187 views1 answer
Dataframe pandas filter rows by list of values
Python
0 vote152 views1 answer
C++ vs python
Python
0 vote146 views1 answer
Pyspark check all columns for null values
Python
0 vote207 views1 answer
Django save another class data while saving a class
Python Django
7 votes156 views1 answer
Python primality test
Python
0 vote160 views1 answer
Python limit round with 2 decimal
Python
26 votes141 views6 answers
Delete columns pandas
Python
0 vote169 views1 answer
Numpy combinations of 5 bits
Python
3 votes151 views2 answers
Pandas df row count
Python