pandas split tuple column

Solutions on MaxInterview for pandas split tuple column by the best coders in the world

Search
showing results for - "pandas split tuple column"
Bronwyn
28 Oct 2017
1In [2]: df = pd.DataFrame({'a':[1,2], 'b':[(1,2), (3,4)]})                                                                                                                      
2
3In [3]: df                                                                                                                                                                      
4Out[3]: 
5   a       b
60  1  (1, 2)
71  2  (3, 4)
8
9In [4]: df['b'].tolist()                                                                                                                                                        
10Out[4]: [(1, 2), (3, 4)]
11
12In [5]: pd.DataFrame(df['b'].tolist(), index=df.index)                                                                                                                                          
13Out[5]: 
14   0  1
150  1  2
161  3  4
17
18In [6]: df[['b1', 'b2']] = pd.DataFrame(df['b'].tolist(), index=df.index)                                                                                                                       
19
20In [7]: df                                                                                                                                                                      
21Out[7]: 
22   a       b  b1  b2
230  1  (1, 2)   1   2
241  2  (3, 4)   3   4
source
Hugo
15 Feb 2018
1In [2]: df = pd.DataFrame({'a':[1,2], 'b':[(1,2), (3,4)]})
2
3In [3]: df
4Out[3]:
5   a       b
60  1  (1, 2)
71  2  (3, 4)
8
9In [4]: df['b'].tolist()
10Out[4]: [(1, 2), (3, 4)]
11
12In [5]: pd.DataFrame(df['b'].tolist(), index=df.index)
13Out[5]:
14   0  1
150  1  2
161  3  4
17
18In [6]: df[['b1', 'b2']] = pd.DataFrame(df['b'].tolist(), index=df.index)
19
20In [7]: df
21Out[7]:
22   a       b  b1  b2
230  1  (1, 2)   1   2
241  2  (3, 4)   3   4
25
source
similar questions
split pd dataframe to excel files based on a column valuesplit a pd dataframepandas split by spacepandas split column into multiple columns by delimitersplit column in exact spot pythonpandas read from txt separtionsplitting column values in pandashow to pick out separate columns from the pandas dataframe objectpython split a string of tuples into a list of listsnp split dataframe specific conditionmpandas split dataframe into chunks with a conditionsplit a column into two columns pandaspython split into rowssplit pandas dataframe in twohow to use split in pandasexpand pandas dataframe into separate rowshow explode by using two columns pandashow to assign a tuple to a cell in pandas dataframe
queries leading to this page
split tuple in dataframesplitting a tuple column in pandasspliting tuples pandaspandas split tuple into columnssplit tuple column pandasreturn tuple from pandas apply functionpandas split column value betweenpandas split column with tuplepandas split tuple columnpython df split colum of tuplepandas dataframe split tuple into columnssplitting dataframe into tuplessplit tuples in pandas seriessplit tuple into columns and add in pandaspandas splitting columnssplit tuple into columns pandashow to separate tuple to columns in pandassplit columns pandaspython df split tuple column pandas split column of tuplespandas split tuple column