# https://www.globalsino.com/ICs/
# Check if a CSV cell value is NaN


import pandas as pd
import numpy as np
import os

filename = r"C:\GlobalSino2\ICs\4767pptPreparationBridge.csv"

NewFileName = "Luke"

# Read Pandas csv file with no header
df = pd.read_csv(filename, header=None)

for i in range(1, len(df)):
    print("Preparing pptx slides for: ", df.values[i][0])
    if df.values[i][0] == "Luke":
        theFileDirectory = df.values[i][1]
        print("Working slides are for the directory: ", theFileDirectory)
        print("\n")
        dfPPTXconfig = pd.read_csv(theFileDirectory, header=None)
        for j in range(1, len(dfPPTXconfig)):
            print(dfPPTXconfig.values[j][0], "|and| ", dfPPTXconfig.values[j][1])
            if pd.isnull(dfPPTXconfig.values[j][1]) == False: 
                print(dfPPTXconfig.values[j][0], j, "is not none") #================
                if "NewFile" == str(dfPPTXconfig.values[j][0]):
                    NewFile = dfPPTXconfig.values[j][1]