0

please help me! i have example dataframe like this:

    a   b   c
0   1   a1  a
1   2   a2  b
2   3   a3  c / d
3   4   a4  e
4   5   a5  f
5   6   a6  g
6   7   a7  h
7   8   a8  I / j / k
8   9   a9  l
9   10  a10 m

and i want to turn that df to something like this:

    a   b   c
0   1   a1  a
1   2   a2  b
2   3   a3  c
3   4   a3  d
4   5   a4  e
5   6   a5  f
6   7   a6  g
7   8   a7  h
8   9   a8  i
9   10  a8  j
10  11  a8  k
11  12  a9  l
12  13  a10 m

please help, thank you

mozway
  • 194,879
  • 13
  • 39
  • 75
Aldino Nyda Prayoga
  • 1
  • `df.assign(c=df['c'].str.split(r'\s*,\s*')).explode('c').assign(a=lambda d: range(1, len(d)+1))` – mozway Mar 06 '23 at 13:57

0 Answers0