Guest User

Untitled

a guest
May 25th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. import pandas as pd
  2. import sqlite3
  3.  
  4.  
  5. def import_csv_to_sql(csv_filename, sql_filename, **kwargs):
  6. df = pd.read_csv(csv_filename, **kwargs)
  7. conn = sqlite3.connect(sql_filename)
  8. df.to_sql("detail_201701_201801", conn, if_exists='append', index=False)
  9.  
  10.  
  11. if __name__ == '__main__':
  12. import_csv_to_sql(
  13. "csv_filename.csv",
  14. "sqlite_filename.db",
  15. low_memory=True)
Add Comment
Please, Sign In to add comment