I have two dataframes, with one containing the corresponding value of the id and another one with the lists of id in each rows.
How can I replace the list of id by the matching values of the other dataframes ?
df_1 :
| Id | Names |
| ------------------- | ---------------- |
| 1 | Name1 |
| 2 | Name2 |
| 3 | Name3 |
df_2 :
| Id_lists |
| ------------------- |
| [1] |
| [2,3,1] |
| [1,3 ] |
To create the dataframe in my exemple:
data = [[1, 'Name1'], [2, 'Name2'], [3,'Name3']]
data_2 = [[[1]],[[2,3,1]],[[1,3]]]
df_1 = pd.DataFrame(data, columns = ['Id', 'Names'])
df_2 = pd.DataFrame(data_2, columns = ['Id_lists'])
Try create the mapping
dict
withexplode