I am trying to merge three dataframes using intersection(). How can we check that all dataframes exists/initialised before running the intersection() without multiple if-else check blocks. If any dataframe is not assigned, then don't take it while doing the intersection(). Sometimes I am getting error - UnboundLocalError: local variable 'df_2' referenced before assignment, because file2 does not exist. OR is there any other easy way to achieve below? Below is my approach: if os.path.exists(file1): df_1 = pd.read_csv(file1, header=None, names=header_1, sep=',', index_col=None) if os.path.exists(file2): df_2 = pd.read_csv(file2, header=None, names=header_2, sep=',', index_col=None) if os.path.exists(file3): df_3 = pd.read_csv(file3, header=None, names=header_3, sep=',', index_col=None) common_columns = df_1.columns.intersection(df_2.columns).intersection(df_3.columns) filtered_1 = df_1[common_columns] filtered_2 = df_2[common_columns] filtered_3 = df_3[common_columns] concatenated_df = pd.concat([filtered_1, filtered_2, filtered_3], ignore_index=True) Continue reading...
