Python and Databases 6 - SQLite3 - Bulk Loading

Let's learn about how we can bulk load, ie large set of data from a csv file into our SQLite3 database using Python.

------

----

----
Schedule: New educational videos every week
-----

Learn Something New:
------
-----
Learn Something New:
------

[MukeshSharma-wqtk]

this is easy but takes time, I am trying to insert 4 million records and it takes some good time.

[karramsos]

Let's bulk load tasks into our database from a csv file with Python :-)

[namithah]

Are you inserting into an already existing DB?

[rimleetalukdar]

Please explain the steps while writing the code.

[rajan]

please give the details of todo.db..like what we need to mention there

[saif]

Let's "talk about it" - proceeds to not talk about it.

[purnarohithginjupalli]

Can we load more than 2 CSV file into 2 different tables in the same database using python?
For example, I have CSV files list and I run a loop on the list but it throws an error.

[polisettirohit]

How about using dataframes from pandas and use the toSQl function?

[rinka]

why data_filename = sys.argv[1] ? please explain. Thanks :)