How can I create a new list column from a list column
My dataframe:
id x list_id
1 20 [2, 4]
2 10 [1, 3]
3 10 [1]
4 30 [1, 2]
What I want:
id x list_id list_x
1 20 [2, 4] [10, 30]
2 10 [1, 3] [20, 10]
3 10 [1] [20]
4 30 [1, 2] [20, 10]
My first idea is to iterate on each line then check if the id is in the list
for index, row in df.iterrows():
if ( df['id'].isin(row['list_id']) ):
do_somthing
But its not working, any suggestion !!