How to SAVE a Pandas DataFrame into an SQLite Database using Python

0 min

Databases are extremely nice, especially when you want to handle a large amount of structured data.

Here is how to save a pandas DataFrame in an SQLite database using the DataFrame.to_sql() methods.

Here is the code

How to write into a SQLite Database

Here we write an example into the database.sqlite. In SQLite, a database is literally a file.

import pandas as pd
import sqlite3

# Create the connection to the database
con = sqlite3.connect("database.sqlite")

# We execute the sql query against the database
df = pd.DataFrame({"col1": range(10)})

# We print the dataframe
df.to_sql("my_table", con)

# Verify that result of SQL query is stored in the dataframe

# We close the connection

Here you are! You now know how to save a Pandas DataFrame into an SQLite Database.