/Python/Pandas split column into multiple columns by delimiter

Pandas split column into multiple columns by delimiter

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

Source: stackoverflow.com

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 vote197 views1 answer
Convert string to object in python
Python
0 vote189 views1 answer
Python split string regular expression
Python
2 votes220 views3 answers
Python beep
Python
-1 vote196 views2 answers
Convert two numpy array to pandas dataframe
Python
0 vote210 views1 answer
Django retrieveupdatedestroyapiview
Python Django
0 vote188 views1 answer
How to make html files open in chrome using python
Python
107 votes186 views6 answers
Python do while loop
Python
11 votes184 views5 answers
Convert dataframe column to float
Python
20 votes161 views5 answers
Flatten a list of lists python
Python
0 vote217 views1 answer
Check if a date is reached django
Python Django