Pandas split column with tuple

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

Source: stackoverflow.com

Pandas split tuple column

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

Source: stackoverflow.com

Similar codes

4 votes108 views1 answer
Django pandas queryset
Python
1 vote152 views1 answer
How to add captcha in django forms
Python Django
0 vote176 views1 answer
Returns the cartesian product with another DataFrame
Python
0 vote116 views1 answer
Pandas append sheet to workbook
Python
0 vote121 views1 answer
How to plot side by side bar horizontal bar graph in python
Python
0 vote101 views1 answer
Python get last modification time of file
Python
0 vote186 views1 answer
The day before today python datetime
Python
1 vote134 views2 answers
Python easter egg
Python
1 vote126 views1 answer
Convert pandas dataframe to django queryset
Python Django
0 vote121 views1 answer
Python how to align text writen to a file
Python