/Python/Use sqlalchemy to create sqlite3 database

Use sqlalchemy to create sqlite3 database

from sqlalchemy import create_engine
import pandas as pd
# creates an engine for a database in current directory 
engine = create_engine('sqlite:///yourDatabaseName.sqlite3') 
# creates a dataframe in memory
df = pd.DataFrame({'tablename' : ['Data 1', 'Data 2', 'Data 3']})
# stores the dataframe as a table in the database
df.to_sql('tablename', con=engine)
# queries the table and stores the results in another dataframe
dfOne = pd.read_sql_table('tablename', engine)
# or you can create a custom sql query and store the results in a dataframe
dfTwo = pd.DataFrame(engine.execute("SELECT * FROM tablename").fetchall())

Similar codes

1 vote132 views1 answer
Turn off axes matplotlib
Python
0 vote129 views1 answer
Developpement limité sinus python
Python
2 votes145 views1 answer
Np.pad
Python
3 votes123 views1 answer
Simple colours python
Python
16 votes150 views6 answers
Joins in pandas
Python
0 vote125 views1 answer
Torch.utils.data.random_split(dataset, lengths)
Python
1 vote130 views5 answers
Scrapy proxy pool
Python
0 vote139 views2 answers
Convert pandas data frame to latex file
Python
0 vote130 views2 answers
Create column with values mapped from another column python
Python
0 vote162 views1 answer
First n lis tpython
Python