import pandas as pd # Read the Excel files df1 = pd.read_excel('Downloads/UUID with Farmonaut.xlsx') df2 = pd.read_excel('Downloads/All Fields ipRHhCOFIDV2pxgg7Nfz1ufZBmV2 (1).xlsx') # Initialize an empty list to store the matching IDs matching_ids = [] # Iterate through the rows of excel sheet 2 for index, row in df2.iterrows(): # Get the value from column C and split it by comma description_values = str(row['Field Description']).split(',') # Get the first element from the split values first_element = description_values[0].strip() # Compare the first element with the values in column D of excel sheet 1 matching_row = df1[df1['UUID Final'] == first_element] if not matching_row.empty: # If a match is found, add the value of column B from excel sheet 1 to the list matching_ids.append(matching_row['Field ID'].values[0]) # Save the resulting array to a new Excel sheet result_df = pd.DataFrame(matching_ids, columns=['Matching IDs']) result_df.to_excel('matching_ids.xlsx', index=False)