python
pip install pandas
pip install SQLAlchemy
python
import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('sqlite:///database.db')
data = pd.read_csv('data.csv')
data.to_sql('table_name', engine, if_exists='replace')
python
pip install psycopg2
python
import psycopg2
conn = psycopg2.connect(database="mydatabase", user="myuser", password="mypassword", host="localhost", port="5432")
cur = conn.cursor()
with open('data.csv', 'r') as f:
next(f)
cur.copy_from(f, 'table_name', sep=',')
conn.commit()
cur.close()
conn.close()
python
import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('sqlite:///database.db')
query = "SELECT * FROM table_name"
data = pd.read_sql_query(query, engine)
data.to_csv('exported_data.csv', index=False)
python
import psycopg2
conn = psycopg2.connect(database="mydatabase", user="myuser", password="mypassword", host="localhost", port="5432")
cur = conn.cursor()
with open('exported_data.csv', 'w') as f:
cur.copy_to(f, 'table_name', sep=',')
cur.close()
conn.close()
