SQLite with Python using CSV files.

In this little project, we’re going to load a csv file into a SQLite database table, then we’ll manipulate the data with Python using Pandas and last but not least, we’ll make some simple graphs using Plotly.

SQLite does not support stored procedures, so you cannot create or execute procedures in SQLite. However, you can use Python to create and execute SQL statements, which can be used to accomplish the same tasks as stored procedures.

Similar to stored procedures, SQLite does not support CREATE FUNCTION, but you can use Python to create and execute SQL statements, which can be used to accomplish the same tasks as sql functions.

Dataframe 1.

Dataframe 2.

Dataframe 3.

Now that we have our 3 different dataframes, let’s make some graphs.

Plot 1.

Plot 2.

Plot 3.

Plot 4.

Printing all table names in our database.

This was a very simple project just to play around with SQLite databases and Python, when we have our data stored in CSV files.

Thanks for reading.

Related posts:

A tyranny of ignorance is rising. Proud banners proclaim righteous misbelief. Trolling fear and anxiety, stoking hatred’s deadly fires. Meanwhile, behind the scenes, the Get-it-while-I-can Gang…

When we talk about highly functioning teams in a Product or SAAS environment, we talk about the Agile Triad — equal parts usability (UX Design), feasibility (Development), and business value (Product…

In the world of promotional merchandise and branded goods, it’s easy to do what “everyone” does — a pen, a notebook, a keychain, hey — may as well throw in a lanyard too. These old favourites are…