I tried to flatten a small nested dataframe which is given below.
>nested dataframe
     A   B    C
0   1   1  [1, 2]
1   2   2  [2, 3]
2   3   3  [3, 4]
       
After flattening the C column I achieved this columnwise.
   A   B   C
0   1   1  1
0   1   1  2
1   2   2  2
1   2   2  3
2   3   3  3
2   3   3  4
The code I used
 dat = pd.DataFrame({'A ': [1,2,3] ,
                        'B ':[1,2,3, ],
                        'C':[[1,2 ], [ 2,3],[ 3,4] ]})
 dataa= dat.explode('C') 
but what I'm expecting is to obtain something like this row wise.
    A   B  C1  C2
0   1   1  1  2
1   2   2  2  3
2   3   3  3  4
as I could easily do this in R but in python any help will be appreciated
