Answers for "dataframe to sqlite3 python"

SQL
1

sqlite to pandas

import pandas as pd
import sqlite3

con = sqlite3.connect('/Users/mac/Desktop/Python/Baye_stat/productiondisruption/PCI_meat.sqlite')

df = pd.read_sql(<your query here>, con)
Posted by: Guest on November-12-2020
1

how to transfer pandas datafra,e to sqlite

import sqlite3 as db
# Create your connection.
conn = db.connect('connection_name')
df.to_sql(name='table_name', con=conn)
Posted by: Guest on September-03-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language