Opening and editing a CSV file

Asked Dec 08 '18 at 23:35

Active Dec 08 '18 at 23:35

Viewed 22 times

I have a CSV file named x.CSV saved in the folder (C:\Users\HP\Downloads) and I want to add an extra column to it and also know how to open it in python and edit it or just read it in general.

I've tried to do a few things like

import csv
with open('x.csv','rb') as f:
   reader = csv.reader(f)
   for row in reader:
       print (row)

and also quite a few other things but keep getting an error like [Errno 2] No such file or directory: 'x.csv'.

I think I should be able to add the column but the main problem is just accessing the file, editing it and just doing basic things like std, mean etc.

asked Dec 08 '18 at 23:35

ace 10101

3

Are you running the python script from the same folder where x.csv is located? – Victor10 Dec 08 '18 at 23:37
Look up/into using pandas. Quite easily read in csv files and do what you are describing. – chitown88 Dec 09 '18 at 00:07
Thanks - I managed to figure it out - not quite sure what the problem was. – ace 10101 Dec 09 '18 at 00:27

Opening and editing a CSV file

0 Answers0