lm_data[[ 'lm_format_reference', 'goal_name', 'exam_name', 'subject_name', 'unit_name', 'chapter_name' ]] = lm_data['lm_level_code'].str.split('--', expand=True) code example

Example 1: 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

Example 2: 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