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 vote295 views6 answers
List Comprehensions
Python
0 vote265 views0 answer
Python
1 vote300 views1 answer
How to print out all functions of an object in python
Python
6 votes361 views5 answers
Python urlencode
Python
54 votes356 views6 answers
Conda create environment python 3.6
Python
0 vote296 views1 answer
Pvector python processing
Python
0 vote314 views1 answer
How to check nth prime in python
Python
11 votes318 views3 answers
How to remove na values in r data frame
Python
2 votes302 views2 answers
How to round to the nearest 25 python
Python
-3 votes315 views2 answers
Python list of characters
Python