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.

---------------------------------------------
Follow me on social media!

---------------------------------------------

#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

[joshellisonpuray]

I always wanted to learn how I can combine SQL and Python seamlessly into a Jupyter Notebook and this tutorial just taught me how. Thanks a ton! :)

[gauravverma]

Quite informative and essential for Python programmers