Populate Sqlite3 DB with Python3
Iterating over and creating sqlite3 databases with help of python3
Added Support For auto population of sqlite3 database from CSV data
-
Made script to automate the process of filling data in sqlite3 databases
in populate.py
Fill in the columns that you want as a field in your dataset df = df[['columns']] and num_columns with total columns then run the script as:
python3 populate.py /path/to/example.csv /path/to/example.sqlite3
TO DO
- Add support for JSON