Python 3: Write CSV file to StringIO buffer in UTF-8 format.

Question

The following code writes a CSV file in UTF-8 format. The csv file is stored in the filesystem.

with open('sample.csv', 'w', newline='', encoding='utf-8') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=' ',
                            quotechar='|', quoting=csv.QUOTE_MINIMAL)
    csvfile.write('\ufeff')
    spamwriter.writerow("嗨")

Now I don't want to write to the fileystem anymore, I only want to store the CVS into a StringIO buffer. How should I do this?

skrx · Accepted Answer · 2017-10-04 16:24:40Z

2

Why don't you just write the lines?

import io

s = io.StringIO()

with open('sample.csv') as file:
    for line in file:
        s.write(line)

s.seek(0)
for line in s:
    print(line)

answered Oct 4, 2017 at 16:24

skrx

20.5k5 gold badges37 silver badges51 bronze badges

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

Comments

Yocapell · Accepted Answer · 2022-10-25 23:56:50Z

1

    buf = StringIO()
    buf.write('\ufeff')
    writer = csv.writer(
        buf,
        "UNIX",
        delimiter=delimiter,
        quoting=csv.QUOTE_MINIMAL,
    )
    writer.writerow(h for h in header)
    for line in lines:
        writer.writerow(l for l in line)

answered Oct 25, 2022 at 23:56

Yocapell

662 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

user1187968 · Accepted Answer · 2017-10-04 17:58:28Z

0

import csv
import os

filename = "temp.csv"
with open(filename, 'w', encoding='utf-8') as fp:
    fp.write('\ufeff')
    csv_writer = csv.writer(fp, quoting=csv.QUOTE_MINIMAL)
    csv_writer.writerow(['嗨', '="00000011"', 'Lovely Spam', 'Wonderful Spam'])

buffer = open(filename, 'r').read()
print (buffer)
os.unlink(filename)


f= open("final.csv", "w")
f.write(buffer)
f.close()

answered Oct 4, 2017 at 17:58

user1187968

8,14619 gold badges93 silver badges173 bronze badges

Collectives™ on Stack Overflow

Python 3: Write CSV file to StringIO buffer in UTF-8 format.

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related