Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- df = pd.read_csv('/PATH/TO/FILE.csv', sep='|')
- # Optional, set your indexes to get Primary Keys
- df = df.set_index(['COL A', 'COL B'])
- engine = create_engine('mysql://user:pass@host/db', echo=False)
- df.to_sql(table_name, dwh_engine, index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement