/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

6 votes280 views4 answers
Python get date file last modified
Python
0 vote259 views1 answer
Python request add header
Python
-1 vote292 views2 answers
Python dict remove duplicates where name are not the same
Python
30 votes292 views3 answers
Python newline character
Python
1 vote269 views1 answer
How to run the server in django
Python
2 votes264 views1 answer
Python dictonary of dictonary
Python
5 votes294 views1 answer
Python test is nan
Python
17 votes264 views4 answers
Inverse matrix numpy
Python
8 votes293 views4 answers
Glob
Python
0 vote278 views1 answer
Metodo estatico de python
Python