Step-by-step to load a CSV file into SQLite3 using Python.

In this video, I will use the internet to find some data. I use the weather data from Florida. I clean this data up in Microsoft Excel, then I write a small Python program to load this data into SQLite3.

This video will answer the following questions:
a) What is CSV in SQLite?
b) How do I use CSV files in SQLite?
c) Which command is used to import CSV into sqlite3?
d) How do i create a SQLite database from a CSV file in Python?

How to find data on the internet.
How to clean up file downloaded from internet
How to prepare file for CSV import into SQLite3
How to Skip header in CSV file
How to Build Insert Statement and Execute

If you found this video, informative, and worthy for other programmers to view, please consider leaving a Thumbs-Up, a Comment, and if you feel like I'm someone that is followable, please consider sub-scribing. Thanks.

In the video, I used a software application to view the SQLite3 data base.

Here is the URL for that app.
https://sqliteBrowswer.org

SQLite 3 command line application works great too.

#softwareNuggets, #python, #sqlite3, #csv,#skipHeader,#download,#insert