pandas split column with tuple

Calm Chimpanzee answered on March 13, 2020 Popularity 9/10 Helpfulness 4/10

answer pandas split column with tuple

related pandas split tuple column

pandas split column with tuple

Comment

In [2]: df = pd.DataFrame({'a':[1,2], 'b':[(1,2), (3,4)]})                                                                                                                      

In [3]: df                                                                                                                                                                      
Out[3]: 
   a       b
0  1  (1, 2)
1  2  (3, 4)

In [4]: df['b'].tolist()                                                                                                                                                        
Out[4]: [(1, 2), (3, 4)]

In [5]: pd.DataFrame(df['b'].tolist(), index=df.index)                                                                                                                                          
Out[5]: 
   0  1
0  1  2
1  3  4

In [6]: df[['b1', 'b2']] = pd.DataFrame(df['b'].tolist(), index=df.index)                                                                                                                       

In [7]: df                                                                                                                                                                      
Out[7]: 
   a       b  b1  b2
0  1  (1, 2)   1   2
1  2  (3, 4)   3   4

Popularity 9/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: pandas python

Link to this answer
Share Copy Link

Contributed on Mar 13 2020

Calm Chimpanzee

0 Answers Avg Quality 2/10

Closely Related Answers

pandas split tuple column

Comment

In [2]: df = pd.DataFrame({'a':[1,2], 'b':[(1,2), (3,4)]})

In [3]: df
Out[3]:
   a       b
0  1  (1, 2)
1  2  (3, 4)

In [4]: df['b'].tolist()
Out[4]: [(1, 2), (3, 4)]

In [5]: pd.DataFrame(df['b'].tolist(), index=df.index)
Out[5]:
   0  1
0  1  2
1  3  4

In [6]: df[['b1', 'b2']] = pd.DataFrame(df['b'].tolist(), index=df.index)

In [7]: df
Out[7]:
   a       b  b1  b2
0  1  (1, 2)   1   2
1  2  (3, 4)   3   4

Popularity 8/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: python pandas py

Link to this answer
Share Copy Link

Contributed on Apr 25 2021

Joyous Jaguar

0 Answers Avg Quality 2/10

pandas split column with tuple

Contents

More Related Answers

pandas split column with tuple

Closely Related Answers

pandas split tuple column

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.