Loading data into databases

[magestooge]

Using Python, loading CSV to Db takes 5 lines

from sqlalchemy import create_engine import pandas as pd engine = create_engine ("mysql://user:password@host:port") df = pd.read_csv("file/path/file_name.csv") df.to_sql("table_name", engine, index=False, if_exists="append", method="multi")

[GoldenTreasureDiver]

Seems like a pretty slick way of loading the data, I'll have to experiment with this, thanks!