In [7]:

    

import pandas as pd
import mysql.connector


    

In [8]:

    

#read in CosIng ingredients
cosing = pd.read_csv('../../Data/COSING_Ingredients-Fragrance Inventory_v2.csv', header=3, error_bad_lines=False, warn_bad_lines=False)

#get CosIng names
ingredient_name = cosing['INCI name'].fillna('NA').values.tolist()
alt_name = cosing['Chem/IUPAC Name / Description'].fillna('NA').values.tolist()
function = cosing['Function'].fillna('NA').values.tolist()


    

In [9]:

    

#connect to mysql server
cnx = mysql.connector.connect(host='localhost', user='ctolson', password='ilaYOU5!', database='sephora_cosmetics')
cursor = cnx.cursor()

#mysql insert functions
add_ingredient = ("INSERT INTO Ingredients "
                    "(ingredient_name, alt_names) "
                    "VALUES (%s, %s)")


    

In [10]:

    

#add ingredients
for i in range(0, len(ingredient_name)):
    data_ingredient = (ingredient_name[i], alt_name[i])
    cursor.execute(add_ingredient, data_ingredient)
    cnx.commit()


    

In [11]:

    

#close mysql server
cnx.close()


    

In [ ]: