tansylusha/benchmarking

1import pandas as pd2 3# Read excel file with sheet name4dict_df = pd.read_excel('database.xlsx', sheet_name=['Sheet1','ProductTypeName_of_hiot (2)', 'ProductTypeName (2)'])5# Get DataFrame from Dict6unique_type = dict_df.get('ProductTypeName (2)')7unique_hiot_type = dict_df.get('ProductTypeName_of_hiot (2)')8main_df = dict_df.get('Sheet1')9 10main_df = main_df[main_df['ProductTypeName'].isin(unique_type['ProductTypeName'])]11main_df.to_excel("food_related_emissions.xlsx")