CSV remove field value wrap quotes

2024/9/19 9:47:45

I'm attempting to write a list to a csv, however when I do so I get wrapper quotes around my field values:

number1,number2
"1234,2345"
"1235.7890"
"2345.5687"

Using this code:

with open('C:\\temp\\test.csv', 'wb') as out_file:
...     csv_writer = csv.writer(out_file, delimiter=',')
...     csv_writer.writerow(('number1','number2'))
...     for f in myList:
...         csv_writer.writerow(f)

After further research, I found that you can remove the writing of quotes by using:

quotechar='', quoting=csv.QUOTE_NONE**

When I apply this to my code I get this error:

Traceback (most recent call last): File "", line4, in Error: need to escape, but no escapechar set

with open('C:\\temp\\test.csv', 'wb') as out_file:
...     csv_writer = csv.writer(out_file, delimiter=',',quotechar='', quoting=csv.QUOTE_NONE)csv_writer.writerow(('number1','number2'))
...     for f in myList:
...         csv_writer.writerow(f)

How do I remove these quotes?

Edit

myList looks like:

     [['1234,2345'], ['1235,7890'], ['2345,5687']]
Answer

what's in your list are not numbers but text, which is even containing the delimiter character. that means to export this as csv it has to be escaped.

you need to convert your data to numbers before you export it to csv if you want it to be written correctly.

edit: on the other hand your data already looks like it consits of comma separated values - why not write it to a file directly without using a csv writer?

https://en.xdnf.cn/q/72551.html

Related Q&A

Python - Py_Initialize unresolved during compilation

I have statically compiled Python2.7 without any error. To test my build, I use the following snippet: #include "Python.h" int main() {Py_Initialize(); }And I am compiling it like this:$ gcc…

Python download large csv file from a url line by line for only 10 entries

I have a large csv file of the client and shared via a url to download and I want to download it line by line or by bytes and I want to limit only for 10 entries.I have the following code which will do…

Flask-Login still logged in after use logouts when using remember_me

To logout a user in flask using Flask-login, i simply call logout_user(), but after adding some additional checks with session, after I click logout and click back to "login page" again, im s…

How to write integers to a file

I need to write ranks[a], ranks[b], countto a file, each time on a new lineI am using:file = open("matrix.txt", "w") for (a, b), count in counts.iteritems():file.write(ranks[a], ran…

seaborn changing xticks from float to int

I am plotting a graph with seaborn as sns and pylab as plt:plt.figure(figsize=(10,10),) sns.barplot(y = whatever_y, x = whatever_x , data=mydata) plt.xticks(fontsize=14, fontweight=bold)The xticks are …

What are the use cases for a Python distribution?

Im developing a distribution for the Python package Im writing so I can post it on PyPI. Its my first time working with distutils, setuptools, distribute, pip, setup.py and all that and Im struggling a…

Recovering a file deleted with python

So, I deleted a file using python. I cant find it in my recycling bin. Is there a way I can undo it or something. Thanks in advance.EDIT: I used os.remove. I have tried Recuva, but it doesnt seem to fi…

Using Py_buffer and PyMemoryView_FromBuffer with different itemsizes

This question is related to a previous question I asked. Namely this one if anyone is interested. Basically, what I want to do is to expose a C array to Python using a Py_buffer wrapped in a memoryview…

selenium remotewebdriver with python - performance logging?

Im trying to get back some performance log info from a remote webdriver instance. Im using the Python Selenium bindings.From what I can see, this is information I should be able to get back. Think it m…

Python - replace unicode emojis with ASCII characters

I have an issue with one of my current weekend projects. I am writing a Python script that fetches some data from different sources and then spits everything out to an esc-pos printer. As you might ima…