The Beginners Guide to SQLite with Pandas | Python | Create DB | Create tables | Insert & Update

In this tutorial we will cover the basics of using SQLite3 with Python. SQLite is an easy-to-use database engine included with Python. This is a beginner’s guide to SQLite. In this video, we’ll cover about what SQLite is, how to connect to a database, create tables, insert and query data, and access SQLite in Pandas.

I assume you should already have a basic knowledge of Python and SQL, but you don’t need to know anything at all about databases or SQLite.

What is SQLite?
SQLite is a software library that provides us with an open-source relational data management system where we can store large amounts of data.

💻 Code: https://github.com/hnawaz007/pythondataanalysis/tree/main/SQLite
⚙️ Set up Python and Jupyter Environment: https://www.youtube.com/watch?v=B0G-44dqHRM&t

———————————————
Follow me on social media!

Subscribe: https://www.youtube.com/c/HaqNawaz
Github: https://github.com/hnawaz007
Instagram: https://www.instagram.com/bi_insights_inc
LinkedIn: https://www.linkedin.com/in/haq-nawaz/

———————————————

Download Chinook database: https://www.sqlitetutorial.net/wp-content/uploads/2018/03/chinook.zip
Northwind database for SQLite3: https://github.com/jpwhite3/northwind-SQLite3/blob/master/Northwind.Sqlite3.create.sql
More information about the data inside the Chinook database can be found here: https://www.sqlitetutorial.net/sqlite-sample-database/

#SQLite #Pandas #Python

Topics covered in this video:
0:00 – Intro to SQLite
2:49 – Jupyter Notebook UI
4:15 – Install Pandas
5:17 – Loading the data into Pandas DataFrame
6:21 – Examine Data (Check, Columns, Cells, Headers, Rename columns)
12:29 – Handle missing value and data conversion