outlets_exploded = outlets_h3.explode(column='rings') outlets_exploded['weight'] = outlets_exploded['rings'].map(h3_to_score) #can contains hexagons not relavent to current region outlets_exploded.dropna(inplace=True) #final scoring for outlets outlets_exploded.groupby("category").agg(outlet_importance=("weight",'sum'))