Splitting the values of column in csv and write in new column using Pandas

Question

I have an excel column as shown below :-

FileName               Coordinates
abc.text               0 0.41, 0.42, 0.43, 0.44

I want the output to be in this fashion :-

FileName               Coordinates                   Label    X-1      Y-1      X-3      X-4
abc.txt                0, 0.41, 0.42, 0.43, 0.44       0      0.41     0.42     0.43     0.44

I have written the below code and before it worked for me, dont know what I am mission in this specific case :-

import pandas as pd


df = pd.read_csv('path/to/Coordinates_v3_updated.csv')

df[['Label', 'x1','y1', 'x2', 'y2']] = df['Coordinates'].str.split(" ",expand=True)

print(df)

df.to_csv('path/to/save/to/Coordinates_v3_updated_v1.csv', index=False)
print("Done")

itprorh66 · Accepted Answer · 2021-03-05 18:43:12Z

1

replace df[['Label', 'x1','y1', 'x2', 'y2']] = df['Coordinates'].str.split(" ",expand=True)

with df[['Label', 'x1','y1', 'x2', 'y2']] = df['Coordinates'].str.split(", ",expand=True)

answered Mar 5, 2021 at 18:43

itprorh66

3,2784 gold badges13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Splitting the values of column in csv and write in new column using Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related