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