An Easy Beginners Guide to SQLite in Python and Pandas

Learn how to create tables and query for data in SQLite as well as access SQLite from Pandas

Julia Kho
Towards Data Science
6 min readDec 29, 2021

--

Photo by Clément Hélardot on Unsplash

Welcome to an easy beginners guide to SQLite. In this article, you’ll learn about what SQLite is, how to connect to databases, create tables, insert and query for data, and access SQLite in Pandas. I am assuming that…

--

--

Julia is an analytics professional who loves to write easy to understand Python and data science articles for beginners