(I've edited the first column name in the labels_df for clarity)
I have two DataFrames, train_df and labels_df. train_df has integers that map to attribute names in the labels_df. I would like to look up each number within a given train_df cell and return in the adjacent cell, the corresponding attribute name from the labels_df.
I've tried variations of the function below but fear I am wayyy off:
def my_mapping(df1, df2): tags = df1['attribute_ids'] for i in tags.iteritems(): df1['new_col'] = df2.iloc[i] return df1
The data are originally from two csv files:
I tried this from @Danny :
sample_train_df['attribute_ids'].apply(lambda x: [sample_labels_df[sample_labels_df['attribute_name'] == i] ['attribute_id_num'] for i in x])
*please note - I am running the above code on samples of each DF due to run times on the original DFs. which returned: