Getting unwanted “ ” between words when appending a CSV file to a new CSV file in Python 3

I'm trying to append a CSV file to a new CSV file, and where there were no "" between the words in my first document, i get those when appending it to the new file. Example :

house

building 

apartment

loan

is how is the CSV file I want to import. I wrote this code :

import csv 



csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",")



document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])



document_to_append.close()

csv_file.close()

And the result in CSV is this :

"house

"

"building

"

and so on…

How can I get rid of those annoying ""? I have absolutely no idea…

asked Nov 14 '18 at 11:59

BeatJuice

223

I think it is the spaces and the quotes are coming to next line..try trimming spaces and try...It will work

– Rahul Agarwal
Nov 14 '18 at 12:16

What happens if you get rid of the last item of row ? csv_file_writer.writerow([row[:-1]])

– Patol75
Nov 14 '18 at 12:22

It works with csv_file_writer.writerow([row[:-1]]), I Don't understand why but ok. If you can explain it's perfect (for my knowledge), thanks anyway!

– BeatJuice
Nov 14 '18 at 12:26

add a comment |

I'm trying to append a CSV file to a new CSV file, and where there were no "" between the words in my first document, i get those when appending it to the new file. Example :

house

building 

apartment

loan

is how is the CSV file I want to import. I wrote this code :

import csv 



csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",")



document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])



document_to_append.close()

csv_file.close()

And the result in CSV is this :

"house

"

"building

"

and so on…

How can I get rid of those annoying ""? I have absolutely no idea…

asked Nov 14 '18 at 11:59

BeatJuice

223

I think it is the spaces and the quotes are coming to next line..try trimming spaces and try...It will work

– Rahul Agarwal
Nov 14 '18 at 12:16

What happens if you get rid of the last item of row ? csv_file_writer.writerow([row[:-1]])

– Patol75
Nov 14 '18 at 12:22

It works with csv_file_writer.writerow([row[:-1]]), I Don't understand why but ok. If you can explain it's perfect (for my knowledge), thanks anyway!

– BeatJuice
Nov 14 '18 at 12:26

add a comment |

I'm trying to append a CSV file to a new CSV file, and where there were no "" between the words in my first document, i get those when appending it to the new file. Example :

house

building 

apartment

loan

is how is the CSV file I want to import. I wrote this code :

import csv 



csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",")



document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])



document_to_append.close()

csv_file.close()

And the result in CSV is this :

"house

"

"building

"

and so on…

How can I get rid of those annoying ""? I have absolutely no idea…

asked Nov 14 '18 at 11:59

BeatJuice

223

I'm trying to append a CSV file to a new CSV file, and where there were no "" between the words in my first document, i get those when appending it to the new file. Example :

house

building 

apartment

loan

is how is the CSV file I want to import. I wrote this code :

import csv 



csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",")



document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])



document_to_append.close()

csv_file.close()

And the result in CSV is this :

"house

"

"building

"

and so on…

How can I get rid of those annoying ""? I have absolutely no idea…

python csv python-3.7

asked Nov 14 '18 at 11:59

BeatJuice

223

asked Nov 14 '18 at 11:59

BeatJuice

223

asked Nov 14 '18 at 11:59

BeatJuice

223

asked Nov 14 '18 at 11:59

BeatJuice

223

asked Nov 14 '18 at 11:59

BeatJuice

223

I think it is the spaces and the quotes are coming to next line..try trimming spaces and try...It will work

– Rahul Agarwal
Nov 14 '18 at 12:16

What happens if you get rid of the last item of row ? csv_file_writer.writerow([row[:-1]])

– Patol75
Nov 14 '18 at 12:22

It works with csv_file_writer.writerow([row[:-1]]), I Don't understand why but ok. If you can explain it's perfect (for my knowledge), thanks anyway!

– BeatJuice
Nov 14 '18 at 12:26

add a comment |

I think it is the spaces and the quotes are coming to next line..try trimming spaces and try...It will work

– Rahul Agarwal
Nov 14 '18 at 12:16

What happens if you get rid of the last item of row ? csv_file_writer.writerow([row[:-1]])

– Patol75
Nov 14 '18 at 12:22

It works with csv_file_writer.writerow([row[:-1]]), I Don't understand why but ok. If you can explain it's perfect (for my knowledge), thanks anyway!

– BeatJuice
Nov 14 '18 at 12:26

I think it is the spaces and the quotes are coming to next line..try trimming spaces and try...It will work

– Rahul Agarwal
Nov 14 '18 at 12:16

What happens if you get rid of the last item of row ? csv_file_writer.writerow([row[:-1]])

– Patol75
Nov 14 '18 at 12:22

It works with csv_file_writer.writerow([row[:-1]]), I Don't understand why but ok. If you can explain it's perfect (for my knowledge), thanks anyway!

– BeatJuice
Nov 14 '18 at 12:26

add a comment |

3 Answers
3

active

oldest

votes

You can set the csv.writer to quote nothing with quoting=csv.QUOTE_NONE like below:

import csv

csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",", escapechar=' ',quoting=csv.QUOTE_NONE,lineterminator='')

document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])

document_to_append.close()

csv_file.close()

Demo Link:

https://repl.it/repls/FarLopsidedBaitware

edited Nov 14 '18 at 12:37

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

add a comment |

replace the line:

document_to_append = open("test.csv", "r")

by:

document_to_append = [line.rstrip() for line in open('test.csv', "r")]

Note: this will work but you would have to remove the line: document_to_append.close() as document_to_append is no longer a handle, but a list.

If you want to close the file anyhow, then instead of list comprehension(the above solution), do this:

with open('test.csv') as f:

    document_to_append = [line.rstrip() for line in f]

answered Nov 14 '18 at 12:48

Shashank

222111

add a comment |

I'm not sure if this is the reason, but I think it's because you're turning row into a list in the line csv_file_writer.writerow([row]) I'd use this below:

import csv 



with open("bigcsv.csv", "r") csv_file:

with open("test.csv", "w") as csv_file_writer:

    for row in csv_file:

        csv_file_writer.writerow(row)

edited Nov 15 '18 at 10:29

answered Nov 14 '18 at 12:21

Jaba

7,471175494

If I remove the list, it's writing a coma between every letter

– BeatJuice
Nov 14 '18 at 12:24

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53299746%2fgetting-unwanted-between-words-when-appending-a-csv-file-to-a-new-csv-file-i%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

3 Answers
3

active

oldest

votes

3 Answers
3

active

oldest

votes

You can set the csv.writer to quote nothing with quoting=csv.QUOTE_NONE like below:

import csv

csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",", escapechar=' ',quoting=csv.QUOTE_NONE,lineterminator='')

document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])

document_to_append.close()

csv_file.close()

Demo Link:

https://repl.it/repls/FarLopsidedBaitware

edited Nov 14 '18 at 12:37

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

add a comment |

You can set the csv.writer to quote nothing with quoting=csv.QUOTE_NONE like below:

import csv

csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",", escapechar=' ',quoting=csv.QUOTE_NONE,lineterminator='')

document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])

document_to_append.close()

csv_file.close()

Demo Link:

https://repl.it/repls/FarLopsidedBaitware

edited Nov 14 '18 at 12:37

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

add a comment |

You can set the csv.writer to quote nothing with quoting=csv.QUOTE_NONE like below:

import csv

csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",", escapechar=' ',quoting=csv.QUOTE_NONE,lineterminator='')

document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])

document_to_append.close()

csv_file.close()

Demo Link:

https://repl.it/repls/FarLopsidedBaitware

edited Nov 14 '18 at 12:37

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

You can set the csv.writer to quote nothing with quoting=csv.QUOTE_NONE like below:

import csv

csv_file = open("bigcsv.csv", "a", encoding='utf-8', newline = "")

csv_file_writer = csv.writer(csv_file, delimiter= ",", escapechar=' ',quoting=csv.QUOTE_NONE,lineterminator='')

document_to_append = open("test.csv", "r")

for row in document_to_append:

    print(row)

    csv_file_writer.writerow([row])

document_to_append.close()

csv_file.close()

Demo Link:

https://repl.it/repls/FarLopsidedBaitware

edited Nov 14 '18 at 12:37

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

edited Nov 14 '18 at 12:37

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

answered Nov 14 '18 at 12:31

Jay Shankar Gupta

5,5661422

add a comment |

replace the line:

document_to_append = open("test.csv", "r")

by:

document_to_append = [line.rstrip() for line in open('test.csv', "r")]

Note: this will work but you would have to remove the line: document_to_append.close() as document_to_append is no longer a handle, but a list.

If you want to close the file anyhow, then instead of list comprehension(the above solution), do this:

with open('test.csv') as f:

    document_to_append = [line.rstrip() for line in f]

answered Nov 14 '18 at 12:48

Shashank

222111

add a comment |

replace the line:

document_to_append = open("test.csv", "r")

by:

document_to_append = [line.rstrip() for line in open('test.csv', "r")]

Note: this will work but you would have to remove the line: document_to_append.close() as document_to_append is no longer a handle, but a list.

If you want to close the file anyhow, then instead of list comprehension(the above solution), do this:

with open('test.csv') as f:

    document_to_append = [line.rstrip() for line in f]

answered Nov 14 '18 at 12:48

Shashank

222111

add a comment |

replace the line:

document_to_append = open("test.csv", "r")

by:

document_to_append = [line.rstrip() for line in open('test.csv', "r")]

Note: this will work but you would have to remove the line: document_to_append.close() as document_to_append is no longer a handle, but a list.

If you want to close the file anyhow, then instead of list comprehension(the above solution), do this:

with open('test.csv') as f:

    document_to_append = [line.rstrip() for line in f]

answered Nov 14 '18 at 12:48

Shashank

222111

replace the line:

document_to_append = open("test.csv", "r")

by:

document_to_append = [line.rstrip() for line in open('test.csv', "r")]

Note: this will work but you would have to remove the line: document_to_append.close() as document_to_append is no longer a handle, but a list.

If you want to close the file anyhow, then instead of list comprehension(the above solution), do this:

with open('test.csv') as f:

    document_to_append = [line.rstrip() for line in f]

answered Nov 14 '18 at 12:48

Shashank

222111

answered Nov 14 '18 at 12:48

Shashank

222111

answered Nov 14 '18 at 12:48

Shashank

222111

answered Nov 14 '18 at 12:48

Shashank

222111

add a comment |

I'm not sure if this is the reason, but I think it's because you're turning row into a list in the line csv_file_writer.writerow([row]) I'd use this below:

import csv 



with open("bigcsv.csv", "r") csv_file:

with open("test.csv", "w") as csv_file_writer:

    for row in csv_file:

        csv_file_writer.writerow(row)

edited Nov 15 '18 at 10:29

answered Nov 14 '18 at 12:21

Jaba

7,471175494

If I remove the list, it's writing a coma between every letter

– BeatJuice
Nov 14 '18 at 12:24

add a comment |

I'm not sure if this is the reason, but I think it's because you're turning row into a list in the line csv_file_writer.writerow([row]) I'd use this below:

import csv 



with open("bigcsv.csv", "r") csv_file:

with open("test.csv", "w") as csv_file_writer:

    for row in csv_file:

        csv_file_writer.writerow(row)

edited Nov 15 '18 at 10:29

answered Nov 14 '18 at 12:21

Jaba

7,471175494

If I remove the list, it's writing a coma between every letter

– BeatJuice
Nov 14 '18 at 12:24

add a comment |

I'm not sure if this is the reason, but I think it's because you're turning row into a list in the line csv_file_writer.writerow([row]) I'd use this below:

import csv 



with open("bigcsv.csv", "r") csv_file:

with open("test.csv", "w") as csv_file_writer:

    for row in csv_file:

        csv_file_writer.writerow(row)

edited Nov 15 '18 at 10:29

answered Nov 14 '18 at 12:21

Jaba

7,471175494

I'm not sure if this is the reason, but I think it's because you're turning row into a list in the line csv_file_writer.writerow([row]) I'd use this below:

import csv 



with open("bigcsv.csv", "r") csv_file:

with open("test.csv", "w") as csv_file_writer:

    for row in csv_file:

        csv_file_writer.writerow(row)

edited Nov 15 '18 at 10:29

answered Nov 14 '18 at 12:21

Jaba

7,471175494

edited Nov 15 '18 at 10:29

answered Nov 14 '18 at 12:21

Jaba

7,471175494

answered Nov 14 '18 at 12:21

Jaba

7,471175494

answered Nov 14 '18 at 12:21

Jaba

7,471175494

If I remove the list, it's writing a coma between every letter

– BeatJuice
Nov 14 '18 at 12:24

add a comment |

If I remove the list, it's writing a coma between every letter

– BeatJuice
Nov 14 '18 at 12:24

If I remove the list, it's writing a coma between every letter

– BeatJuice
Nov 14 '18 at 12:24

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Vfrdtyky