Pandas and SQLAlchemy offer powerful conversions between CSV files and tables in databases. Here is a small example:
import pandas as pd
from sqlalchemy import create_engine
df = pd.read_csv('mydata.csv')
engine = create_engine('sqlite:///mydata.db')
df.to_sql('mytable', engine)
Read more:
Leave a Reply
You must be logged in to post a comment.