Split a column into two columns pandas
Code examples
how to use split in pandas
import pandas as pd
# new data frame with split value columns
data["Team"]= data["Team"].str.split(" ", n = 1, expand = True)
# df display
data pandas split by space
# importing pandas module
import pandas as pd
# new data frame with split value columns
data["Team"]= data["Team"].str.split(" ", n = 1, expand = True)
# df display
data pandas split column into multiple columns by delimiter
df[['A', 'B']] = df['AB'].str.split(' ', 1, expand=True)
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)pandas split column into multiple columns
df.Name.str.split(expand=True,)
0 1
0 Steve Smith
1 Joe Nadal
2 Roger Federer
Similar pages
Similar pages with examples
In other languages
This page is in other languages
empty row
Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................
Popular in the category
Popular pages with examples in the category
empty row