/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

69 votes167 views6 answers
How to activate venv python
Python
1 vote173 views1 answer
How to create a fixed size empty array in python
Python
0 vote168 views1 answer
Get random line from file python
Python
21 votes176 views2 answers
Python string does not contain
Python
0 vote171 views1 answer
How to find out the max and min date on the basis of property id in pandas
Python
18 votes179 views2 answers
Get columns by type pandas
Python
1 vote167 views1 answer
How to append data to csv file in python without replacing the already present text
Python
0 vote166 views1 answer
Stutter function in python
Python
8 votes152 views6 answers
Enumerate()
Python
2 votes166 views1 answer
Sess.run tensorflow
Python