writing data into a csv file as float values in python

Question

I want to write data into a .csv file using python as float values. everytime I try to do it using the writerow function of the csv module it writes into the csv file but in quotes, rendering it as a string. I also cannot use float() function since the data acquires is in a list. Thanks in advance

wpedrak · Accepted Answer · 2017-06-09 11:22:35Z

0

I believe this is correct behaviour. From wiki 'Comma-separated values':

Standardization

Any field may be quoted (with double quotes).

EDIT

To avoid quoting u can set quoting=csv.QUOTE_NONE in your csv writer. Working example for Python 3.5.2:

import csv
with open('eggs.csv', 'w', newline='') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=',',
                            quotechar='|', quoting=csv.QUOTE_NONE)
    spamwriter.writerow([str(1.1112233), str(1.3355)])

egg.csv

1.1112233,1.3355

edited Jun 9, 2017 at 11:22

answered Jun 9, 2017 at 10:05

wpedrak

6877 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dragon Over a year ago

thanks for the response. how can i remove the quotes appearing automatically in csv file?

wpedrak Over a year ago

I extended my answer. It's good idea to look at: docs.python.org/3/library/csv.html#csv.QUOTE_NONE and stackoverflow.com/questions/23882024/… aswell.

Dragon Over a year ago

Thanx for all ur responses but I got over with it by using the np.genfromtxt function, and setting the delimiters and the deletechars

Collectives™ on Stack Overflow

writing data into a csv file as float values in python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related