[Python] split을 이용하여 pandas 컬럼 분리하기

 

import pandas as pd

lst_A = ['banana 3','apple 5','orange 6','mango 7']
df = pd.DataFrame(lst_A, columns=['text'])

df

 

 

 

df['fruit'] = df.text.str.split(' ').str[0]
df['count'] = df.text.str.split(' ').str[1]
df