Can anyone help me bit here? Stuck for a while:
Its a pandas dataframe
id values
1 ['a', 'b', 'c']
2 ['a', 'c']
3 ['b', 'c']
4 ['d']
From above to below table:
id a b c d
1 1 1 1 0
2 1 0 1 0
3 0 1 1 0
4 0 0 0 1
Asked
Active
Viewed 35 times
0
Suneesh Jacob
- 806
- 1
- 7
- 15
-
From the duplicate: `new_df = df[['id']].join(pd.get_dummies(df['values'].apply(pd.Series).stack()).groupby(level=0).sum())` – Henry Ecker Aug 19 '21 at 02:56
-
1Awesomeeeeeeeeeeee Thanks man!! I am unable to upvote your answer :(( @HenryEcker – Sahil Gupta Aug 19 '21 at 03:06