Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import psycopg2
- from sqlalchemy import create_engine
- df = pd.read_csv('products.csv', sep=';', low_memory=False)
- engine = create_engine('postgresql://myuser:mypass@server/postgres')
- df.to_sql('new_table', con=engine, if_exists='append', index=False, chunksize=20000)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement