Answers for "python dataframe split column by delimiter"

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

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

dataframe split column

df[['First','Last']] = df.Name.str.split(" ", expand=True)

splitting column values in pandas

df[['A', 'B']] = df['AB'].str.split('@', 1, expand=True)
#'@' - Split at @
#1 = Axis 1 i.e on column level