Create a SQL table from a Pandas DataFrame

Question

Hi Guys,

I have one Pandas DataFrame in my Jupyter Notebook. I want to create one SQL table from this DataFrame. How can I do that?

Answer 1

Hi@akhtar,

You can use the Sqlalchemy module to create a SQL table from a DataFrame. I have attached one example below for your reference.

from sqlalchemy import create_engine
import pandas as pd
data = pd.read_csv('marks.csv')
engine = create_engine('sqlite:///:memory:')
data.to_sql('data_table', engine)

I hope this will help you.