def return_mean(datafile, mapping, flag_columns=None):
mapped_regions = pd.DataFrame(datafile[datafile.iloc[:, 0].isin(mapping)])
mean_values = mapped_regions.iloc[:, 1:].applymap(float).mean()
if flag_columns.any() and (len(mapping) > 1):
mean_values[flag_columns] = (datafile[datafile.iloc[:, 0].isin(mapping)][flag_columns]
).apply(lambda x: pd.value_counts(x).index[0])
return mean_values
评论列表
文章目录