The below code takes a list of questions from an excel, and answers each one based on the directory I passed in. I use this for answering Statement of Works for proposals i write as a first path. Usually, I will have a number of different directorys that i pass in to 'Talk' to different intellegences and get a couple different answers for each prompt. One trains on the entire corpus of my past performance. One has a simple document discussing tone and other information, and one in training on only the SOW itself.

   def excelGPT(dir, excel_file, sheet):
    #my GPT Key
    os.environ['OPENAI_API_KEY'] = 'sk-~Your open AI Key Here'
    #Working Directory for training
    root_folder = ''
    documents = SimpleDirectoryReader(root_folder).load_data()
    index = GPTSimpleVectorIndex(documents)
    file_name = dir + excel_file
    

    df = pd.read_excel(file_name, sheet_name=sheet)

    answer_array = []
    df_series = df.iloc[:,0]
    
    for i,x in enumerate(df_series):
        print("This is the index ", i)
        print(x)
        response = index.query(x)
        answer_array.append(str(response))

    zip_to_doc(df_series, answer_array, dir)