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
没有评论:
发表评论