Expand DataFrame based on list and add index

Question

I have a dataframe that looks like the following:

My goal is to expand the dataframe for each item in the list and add a index column that refers to position in the source list.

WHat is the best way to do this?

Code Different · Accepted Answer · 2021-10-17 02:22:26Z

2

Use explode:

df = df.explode('Values')
df['index'] = df.groupby('Name').cumcount()

answered Oct 17, 2021 at 2:22

Code Different

93.4k16 gold badges154 silver badges175 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1