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

7 votes220 views3 answers
Make exe file pycharm
Python
1 vote222 views1 answer
Np array describe
Python
0 vote223 views1 answer
If not working
Python
-2 votes207 views2 answers
Float() argument must be a string or a number, not 'dict_values'
Python
1 vote232 views1 answer
Generate valid sudoku board python
Python
4 votes227 views2 answers
How to print time python
Python
0 vote220 views2 answers
Dropna threshold
Python
2 votes228 views1 answer
What happen when we apply * before list in python
Python
0 vote215 views1 answer
Como calcular el rango en python
Python
1 vote256 views1 answer
Python multiple conditions in dataframe column values
Python