csv file how to modify the row

muttu2244 at yahoo.com muttu2244 at yahoo.com
Tue Dec 27 17:45:16 EST 2005


Hi everybody


Am trying to read a csv file "temp.csv", which has the below info,


compName       macAddr                ipAddr
opSys


Chris-Dev             0003469F44CC      10.160.24.226   Microsoft
Windows XP
Professional
Shivayogi-Dev  000D5234F44C     10.160.24.136   Microsoft Windows XP
Professional
John-test             000D123F44CC      10.160.24.216   Microsoft
Windows XP
Professional Steve-Dev        000D123F55CC      10.160.24.116
Microsoft
Windows XP Professional


am trying to read it in the following way--



>>> import csv
>>> infoFile = open ('c:\\temp.csv','r')
>>> rdr = csv.reader(infoFile)
>>> for row in rdr:


...     if row[0] == infnList[0]:
...             if not row[1] == infnList[1] or not row[2] ==
infnList[2]:

now am comparing my comp Name  with the "compName" fields, and if it
matches i ll then compare for the "mac address" and "ip address". if
they are not matching with my system, i have to modify them there
itself, i mean i have to update "mac address" and "ip address" in the
same row itself, i dont want to append the information with another row

to the "temp.csv" file. otherwise it will have two similar computer
names for two rows, which i dont want to happen.


please give me the ways how i can work on this.


thanks in advance 
yogi




More information about the Python-list mailing list