Python remove ' from string when using CSV writer

Question

I managed with converting the txt file to .csv with python.

However, now I don't know how to remove the quotes enclosing all strings in my CSV file.

I tried the following code:

 import csv

 with open('UPRN.txt', 'r') as in_file:
 stripped = (line.strip() for line in in_file)
 lines = (line.split(",") for line in stripped if line)
 with open('UPRN.csv', 'w', newline='') as out_file:
    writer = csv.writer(out_file)
    writer.writerow(('Name', 'UPRN','ADMIN_AREA','TOWN','STREET','NAME_NUMBER'))
    writer.writerows(lines)
    for lines in writer:
        lines = [x.replace("'","") if x == '*' else x for x in row]
        writer.writerow(lines)

but I am getting an error:

TypeError: '_csv.writer' object is not iterable

The easiest way could be:

Remove quotes from String in Python

but the CSV writer has no attributes like write, replace, etc. '_csv.writer' object has no attribute 'write'

Moreover, I am not sure if a wildcard is needed here:

Python wildcard search in string

Is there any quick way of removing the quotes when the CSV module is imported?

What's with the if x == '*'? Of course the string doesn't contain ' if it's literally * — tripleee
– tripleee, Commented Sep 16, 2022 at 11:46
you are iterating over your csv writer, instead of the lines. should be something like for line in lines: then line = [element.replace("'", "") for element in line] and writer.writerow(line) — Jeanot Zubler
– Jeanot Zubler, Commented Sep 16, 2022 at 11:46
Does this answer your question? Using python csv writer without quotations — fsimonjetz
– fsimonjetz, Commented Sep 16, 2022 at 11:49

PlainRavioli · Accepted Answer · 2022-09-16 13:32:25Z

1

I think you should rather iterate on your lines list,

with open('UPRN.txt', 'r') as in_file:
    lines = [line.strip().replace("'","") for line in in_file]

with open('UPRN.csv', 'w', newline='') as out_file:
    writer = csv.writer(out_file)
    writer.writerow(('Name', 'UPRN','ADMIN_AREA','TOWN','STREET','NAME_NUMBER'))

    for line in lines:
        writer.writerow(line.split(","))

edited Sep 16, 2022 at 13:32

answered Sep 16, 2022 at 11:50

PlainRavioli

1,2191 gold badge4 silver badges11 bronze badges

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

6 Comments

tripleee Over a year ago

The if is still pointless, "*".replace("'", "") simply returns "*"

Geographos Over a year ago

NameError: name 'lines' is not defined unfortunately this error I am getting

PlainRavioli Over a year ago

@tripleee I have let it although yes it doesn't have much use here

PlainRavioli Over a year ago

@MKR I added code for to read the lines. I removed the split(",") as you don't need to split your string I believe

Geographos Over a year ago

Still doesn't work. Now I have the string split between every column.

|

Collectives™ on Stack Overflow

Python remove ' from string when using CSV writer

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related