python解析csv文件如何去除单引号,Python CSV：从值中删除引号

I have a process where a CSV file can be downloaded, edited then uploaded again. On the download, the CSV file is in the correct format, with no wrapping double quotes

1, someval, someval2

When I open the CSV in a spreadsheet, edit and save, it adds double quotes around the strings

1, "someEditVal", "someval2"

I figured this was just the action of the spreadsheet (in this case, openoffice). I want my upload script to remove the wrapping double quotes. I cannot remove all quotes, just incase the body contains them, and I also dont want to just check first and last characters for double quotes.

Im almost sure that the CSV library in python would know how to handle this, but not sure how to use it...

EDIT

When I use the values within a dictionary, they turn out as follows

{'header':'"value"'}

Thanks

解决方案

For you example, the following works:

import csv

writer = csv.writer(open("out.csv", "wb"), quoting=csv.QUOTE_NONE)

reader = csv.reader(open("in.csv", "rb"), skipinitialspace=True)

writer.writerows(reader)

You might need to play with the dialect options of the CSV reader and writer -- see the documentation of the csv module.