Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import sqlite3
- def import_csv_to_sql(csv_filename, sql_filename, **kwargs):
- df = pd.read_csv(csv_filename, **kwargs)
- conn = sqlite3.connect(sql_filename)
- df.to_sql("detail_201701_201801", conn, if_exists='append', index=False)
- if __name__ == '__main__':
- import_csv_to_sql(
- "csv_filename.csv",
- "sqlite_filename.db",
- low_memory=True)
Add Comment
Please, Sign In to add comment