i have a df that contains some columns like the following table.

What I want is to extract the values from Column B into a new df with the Values from column C like this:

Maybe my search terms are not specific enough, cause its not my native language, but I just don't found a solution yet.

Thanks for help.

CodePudding user response：

I think this work for your problem:

import pandas as pd

data={
    'A': ['a', 'b','c'],
    'B': [[1,3,5], [2,5,7],[8,13,18]],
    'C':['id_1','id_2','id_3']
     }
data_frame=pd.DataFrame(data=data)
df_result=data_frame.apply(lambda r: pd.Series({'id_col':r['C'],
                                      'val_col':r['B'],
                                     }),axis=1).explode('val_col')
print(df_result)

CodePudding user response：

Let's try this:

df.assign(B=df['B'].str.split(',')).explode('B')[['B', 'C']]

Output:

    B     C
0   1  id_1
0   3  id_1
0   5  id_1
1   2  id_2
1   5  id_2
1   7  id_2
2   8  id_3
2  13  id_3
2  18  id_3