Split a pandas column and append the new results to the dataframe

user_7679796 0
Viewed 4460

How can I split a pandas column and append the new results to the dataframe? I also want there to be no white space.

Example of my desired output: 

col1
Smith, John
Smith, John

col2               
Smith
Smith

col3
John
John

I been trying this but the lambda function is not appending the results how I want it to.

df_split = df1['col1'].apply(lambda x: pd.Series(x.split(',')))
df1['col2']= df_split.apply(lambda x: x[0])
df1['col3']= df_split.apply(lambda x: x[1])

I end up getting

col2  col3
Smith Smith
John  John
pandas lambda python
3 Answers

If you just want to store first string after split, then use following

df['col2'] = df['col1'].str.split(',', 1).str[0] 

          col1   col2
0  Smith, John  Smith  
1  Smith, John  Smith
user_70572510
Related