sql_10.py

import pandas as pd
import sqlite3

# read csv files
df_train = pd.read_csv('./train_food/train.csv')
df_meal = pd.read_csv('./train_food/meal_info.csv')
df_center = pd.read_csv('./train_food/fulfilment_center_info.csv')

# connect to database
conn = sqlite3.connect('.\sql_db\FOOD.db')
cur = conn.cursor()

# load dataframes into database
df_train.to_sql("train", conn)
df_meal.to_sql('meal',conn)
df_center.to_sql('centers',conn)