Pandas split tuple column

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

0 vote223 views1 answer
Np print precision
Python
0 vote148 views1 answer
Create_polygon tkinter
Python
1 vote220 views1 answer
Django class based views ListView
Python
9 votes204 views1 answer
Install matplotlib conda
Python
14 votes214 views1 answer
Filter list with python
Python
34 votes204 views6 answers
Python to exe converter online
Python
0 vote201 views1 answer
Import argv python
Python
0 vote244 views1 answer
Django raise 404
Python Django
0 vote253 views2 answers
Where should favicon.ico be placed in flask app
Python Flask
4 votes230 views1 answer
Python stack data structure
Python