Handling csv files with Python
Today my brother came with a problem of exporting a csv file to his mobile. Though the source is a csv file, the mobile software says its not a valid file. Later I found that, wrapping the values within double quotes could make the mobile software read the file correctly. A little search on the net has given the clue that python has csv module to do different operations on it.
So I have a file like below
I have to convert it to something like
The following python program could solve that
fd = csv.reader(open("test.csv", "rb"))
for row in fd:
wr = csv.writer(open("new.csv", "a"),quoting=csv.QUOTE_ALL)
# python contact.py
Read the csv module documentation for more info. The above program puts double quotes in the first line also. Modify it to suits your own needs. The above code is self explanatory.