SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. It is the most used database engine on the world wide web. Python has a library to access SQLite databases, called sqlite3. Let’s see how we can delete a specific row from a given Sqlite table. First, Let’s create a database and table then […]
Category: Sqlite3
How to import CSV file into an SQLite Table using Python?
In this post, we will see how to import CSV file data into an SQLite database table using Python. Now, For solving this requirement we will be using two modules: sqlite3 and pandas. So let’s discuss these first. sqlite3 module is used to access SQLite databases in Python. SQLite is a self-contained, high-reliability, embedded, full-featured, […]