Split tuples columns in pandas dataframe

Question

How can I split this dataframe in two separate columns?

I have tried:

df_partes1=pd.DataFrame(df_partes1[1].values.tolist(), index=df_partes1[0], columns=['x','y'])

but:

Shape of passed values is (12, 1), indices imply (12, 2)

Post the output of df.to_dict() in your question

The Singularity
– The Singularity

2021-10-10 08:20:32 +00:00
Commented Oct 10, 2021 at 8:20 — The Singularity
– The Singularity, Commented Oct 10, 2021 at 8:20

Muhammad Hassan · Accepted Answer · 2021-10-10 08:51:09Z

1

You can use:

df = pd.DataFrame(data={0: ['Neck', 'RShoulder', 'LShoulder', 'RElbow', 'RWrist', 'LElbow'],
                        1: [None, None, (840, 183), None, None, (936,255)]})

df[['new_col_1', 'new_col_2']] = df[1].apply(pd.Series)

Output:

           0           1  new_col_1  new_col_2
0       Neck        None        NaN        NaN
1  RShoulder        None        NaN        NaN
2  LShoulder  (840, 183)      840.0      183.0
3     RElbow        None        NaN        NaN
4     RWrist        None        NaN        NaN
5     LElbow  (936, 255)      936.0      255.0

answered Oct 10, 2021 at 8:51

Muhammad Hassan

4,2492 gold badges17 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Split tuples columns in pandas dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related