2021年3月3日星期三

Split a column with a number and name into two different columns 'ID' and 'Name'

I am converting a text file to csv. In the csv file Im getting a column having a number and name in it (e.g 1: Aki ) , I want to seperate them both in two different columns.

samle data

1: Aki   2: Aki  3: Kano  

code tried

df_output.columns = ['Name', 'date', 'Description']    ###df_output['ID'],df_output['Name_'] = df_output['Name'].str[:1],df_output['Name'].str[1:]    obj = df_output['Name']  obj = obj.str.strip()  obj = obj.str.split(':/s*')  df_output['Name'] = obj.str[-1]  df_output['idx'] = obj.str[0]  df_output = df_output.set_index('idx')  
https://stackoverflow.com/questions/66468250/split-a-column-with-a-number-and-name-into-two-different-columns-id-and-name March 04, 2021 at 11:44AM

没有评论:

发表评论