python对csv文件中的数据进行分类_使用python替换csv文件中的数据

This is the new input file format. I need to automate the process of replacing the content of one column in a .csv file with the use of python. I can also open the .csv file using Notepad and replace the content of the column but the file is very huge and it is taking a long time.

Name ID class Num

"kanika",""University ISD_po.log";" University /projects/asd/new/high/sde"","MBA","12"

"Ambika",""University ISD_po.log";" University /projects/asd/new/high/sde"","MS","13"

In the above, I need to replace the content of ID column. ID column is very inconsistent as it has big spaces and symbols like(; , /) in the content.The new content in the ID column should be "input".

This Id column is enclosed with 2 double quotes and has some extra spaces as well. Whereas other columns have only 1 double quote.

Is there any way to do it in python?

解决方案

Read the .csv line-by-line, split on ,, and replace the second column with "input".

Write it out (to a different file) as you go:

f = open('mycsv.csv','rb')

fo = open('out.csv','wb')

# go through each line of the file

for line in f:

bits = line.split(',')

# change second column

bits[1] = '"input"'

# join it back together and write it out

fo.write( ','.join(bits) )

f.close()

fo.close()

Then you can rename it to replace the original file if you like.