I have a .csv file which looks as follows:link
I want to open this file using pandas and edit the column Coordinate by adding a constant value of 756 to each value in it. Finally, I want the changes to be reflected in the .csv file.
How do I do that?
Edit: What I had been doing is as follows (@EdChum):
df = pd.read_csv('C:/TestBook1.csv')
df = df[['Coordinate','Speed']]
Coord = df['Coordinate']
Coord = Coord + 756
you can also type:
df["Coordinate"] = df["Coordinate"] + 756