Python Pandas and SQLite

Using SQLite to store your Pandas dataframes gives you a persistent store and a way of easily selecting and filtering your data

Photo by Markus Winkler on Unsplash

The SQLite database is a built-in feature of Python and a very useful one, at that. It is not a complete implementation of SQL but it has all the features that you need for a personal database or even a backend…