test excel to sql using pandas and sqlalchemy

import pandas as pd
from sqlalchemy import create_engine

def test_create_excel():
    # create some data
    data = {'product_name': ['laptop', 'printer', 'tablet', 'desk', 'chair'],
        'price': [1200, 150, 300, 450, 200]
        }

    # make it a data frame
    df = pd.DataFrame(data)
    
    # write it to excel
    df.to_excel("file.xlsx")


def test_excel_to_sql():
    
    # create the engine to database
    engine = create_engine('sqlite:///my_database.db')

    # read the excel file
    data = pd.read_excel("file.xlsx")

    # drop it in the database
    data.to_sql('file', con=engine)