/Python/Pandas split column into multiple columns

Pandas split column into multiple columns

Pandas split column into multiple columns by delimiter

df[['A', 'B']] = df['AB'].str.split(' ', 1, expand=True)

Source: stackoverflow.com

How to split a text column into two separate columns?

import pandas as pd 

df = pd.DataFrame(["STD, City    State",
"33, Kolkata    West Bengal",
"44, Chennai    Tamil Nadu",
"40, Hyderabad    Telengana",
"80, Bangalore    Karnataka"], columns=['row'])

out = pd.DataFrame(df.row.str.split(' ',2).tolist(),columns=['STD','City','State'])
out.drop(index=0,inplace=True)

R separate column into multiple columns

df %>%
  separate(mainColumn,c('c1','c2'),'_',extra ='merge')

Split coumn of df into multiple dynamic columns

d = [pd.DataFrame(df[col].tolist()).add_prefix(col) for col in df.columns]
df = pd.concat(d, axis=1)

   id0  id1   id2  value0  value1  value2
0   10   10   NaN   apple  orange    None
1   15   67   NaN  banana  orange    None
2   12   34  45.0   apple  banana  orange

Pandas split column into multiple columns

df.Name.str.split(expand=True,)
          0  1
0   Steve   Smith
1   Joe Nadal
2   Roger   Federer

Source: cmdlinetips.com

Similar codes

0 vote240 views1 answer
Add up all the numbers in each row and output that number output the grand total of all rows
Python
16 votes272 views1 answer
Python bitwise operators methods
Python
0 vote248 views1 answer
Python global variable that can be iterated
Python
2 votes292 views2 answers
Run python script every hour
Python
0 vote259 views1 answer
Value keys in dictionary are immutable true/false
Python
0 vote304 views1 answer
Difference between __gte and __lte in Django
Python Django
3 votes251 views2 answers
Distplot in python
Python
0 vote255 views1 answer
Django get child element
Python
0 vote245 views1 answer
Scrapy create project
Python
0 vote266 views1 answer
Pandas return indices that match
Python