Python CSV printing issue
I have a problem with printing using python's csv package.
I want the headers to come out as "header 1, header 2, header 3, header 4"
But what I get is:
h,e,a,d,e,r, ,1
h,e,a,d,e,r, ,2
h,e,a,d,e,r, ,3
h,e,a,d,e,r, ,4
My codes look like this:
def write_to_excel(file_name, obj_lst):
with open(file_name, 'w', newline='') as output:
writer = csv.writer(output)
# Write the headers first
writer.writerow(['header 1', 'header 2', 'header 3', 'header 4'])
for obj in obj_lst:
writer.writerows(obj)
On a separate piece of code, the above code works just fine. I am not sure what I am doing wrong here.
python-3.x csv
edited Nov 13 '18 at 9:11
Mike
2,0211621
asked Nov 13 '18 at 8:35
AKJAKJ
7610
add a comment |
I have a problem with printing using python's csv package.
I want the headers to come out as "header 1, header 2, header 3, header 4"
But what I get is:
h,e,a,d,e,r, ,1
h,e,a,d,e,r, ,2
h,e,a,d,e,r, ,3
h,e,a,d,e,r, ,4
My codes look like this:
def write_to_excel(file_name, obj_lst):
with open(file_name, 'w', newline='') as output:
writer = csv.writer(output)
# Write the headers first
writer.writerow(['header 1', 'header 2', 'header 3', 'header 4'])
for obj in obj_lst:
writer.writerows(obj)
On a separate piece of code, the above code works just fine. I am not sure what I am doing wrong here.
python-3.x csv
edited Nov 13 '18 at 9:11
Mike
2,0211621
asked Nov 13 '18 at 8:35
AKJAKJ
7610
I ran your code and works fine for me. Not able to re-produce the error.
– Mayank Porwal
Nov 13 '18 at 8:58
I imagine you could expect such an output if you mistakenly addsto makewriter.writerows(['header 1', 'header 2', 'header 3', 'header 4'])
– Amadan
Nov 13 '18 at 9:04
@MayankPorwal Exactly why i have to ask for something so simple on stackoverflow because on my other codes it worked fine. Just this particular code is giving me this error. I am completely bam-boozled. I think my code is possessed.
– AKJ
Nov 13 '18 at 9:38
add a comment |
I have a problem with printing using python's csv package.
I want the headers to come out as "header 1, header 2, header 3, header 4"
But what I get is:
h,e,a,d,e,r, ,1
h,e,a,d,e,r, ,2
h,e,a,d,e,r, ,3
h,e,a,d,e,r, ,4
My codes look like this:
def write_to_excel(file_name, obj_lst):
with open(file_name, 'w', newline='') as output:
writer = csv.writer(output)
# Write the headers first
writer.writerow(['header 1', 'header 2', 'header 3', 'header 4'])
for obj in obj_lst:
writer.writerows(obj)
On a separate piece of code, the above code works just fine. I am not sure what I am doing wrong here.
python-3.x csv
edited Nov 13 '18 at 9:11
Mike
2,0211621
asked Nov 13 '18 at 8:35
AKJAKJ
7610
I have a problem with printing using python's csv package.
I want the headers to come out as "header 1, header 2, header 3, header 4"
But what I get is:
h,e,a,d,e,r, ,1
h,e,a,d,e,r, ,2
h,e,a,d,e,r, ,3
h,e,a,d,e,r, ,4
My codes look like this:
def write_to_excel(file_name, obj_lst):
with open(file_name, 'w', newline='') as output:
writer = csv.writer(output)
# Write the headers first
writer.writerow(['header 1', 'header 2', 'header 3', 'header 4'])
for obj in obj_lst:
writer.writerows(obj)
On a separate piece of code, the above code works just fine. I am not sure what I am doing wrong here.
python-3.x csv
python-3.x csv
edited Nov 13 '18 at 9:11
Mike
2,0211621
asked Nov 13 '18 at 8:35
AKJAKJ
7610
edited Nov 13 '18 at 9:11
Mike
2,0211621
asked Nov 13 '18 at 8:35
AKJAKJ
7610
edited Nov 13 '18 at 9:11
Mike
2,0211621
edited Nov 13 '18 at 9:11
Mike
2,0211621
edited Nov 13 '18 at 9:11
Mike
2,0211621
2,0211621
asked Nov 13 '18 at 8:35
AKJAKJ
7610
asked Nov 13 '18 at 8:35
AKJAKJ
7610
asked Nov 13 '18 at 8:35
AKJAKJ
7610
7610
I ran your code and works fine for me. Not able to re-produce the error.
– Mayank Porwal
Nov 13 '18 at 8:58
I imagine you could expect such an output if you mistakenly addsto makewriter.writerows(['header 1', 'header 2', 'header 3', 'header 4'])
– Amadan
Nov 13 '18 at 9:04
@MayankPorwal Exactly why i have to ask for something so simple on stackoverflow because on my other codes it worked fine. Just this particular code is giving me this error. I am completely bam-boozled. I think my code is possessed.
– AKJ
Nov 13 '18 at 9:38
add a comment |
I ran your code and works fine for me. Not able to re-produce the error.
– Mayank Porwal
Nov 13 '18 at 8:58
I imagine you could expect such an output if you mistakenly addsto makewriter.writerows(['header 1', 'header 2', 'header 3', 'header 4'])
– Amadan
Nov 13 '18 at 9:04
@MayankPorwal Exactly why i have to ask for something so simple on stackoverflow because on my other codes it worked fine. Just this particular code is giving me this error. I am completely bam-boozled. I think my code is possessed.
– AKJ
Nov 13 '18 at 9:38
I ran your code and works fine for me. Not able to re-produce the error.
– Mayank Porwal
Nov 13 '18 at 8:58
I ran your code and works fine for me. Not able to re-produce the error.
– Mayank Porwal
Nov 13 '18 at 8:58
I imagine you could expect such an output if you mistakenly add
s to make writer.writerows(['header 1', 'header 2', 'header 3', 'header 4'])– Amadan
Nov 13 '18 at 9:04
I imagine you could expect such an output if you mistakenly add
s to make writer.writerows(['header 1', 'header 2', 'header 3', 'header 4'])– Amadan
Nov 13 '18 at 9:04
@MayankPorwal Exactly why i have to ask for something so simple on stackoverflow because on my other codes it worked fine. Just this particular code is giving me this error. I am completely bam-boozled. I think my code is possessed.
– AKJ
Nov 13 '18 at 9:38
@MayankPorwal Exactly why i have to ask for something so simple on stackoverflow because on my other codes it worked fine. Just this particular code is giving me this error. I am completely bam-boozled. I think my code is possessed.
– AKJ
Nov 13 '18 at 9:38
add a comment |
0
active
oldest
votes
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276859%2fpython-csv-printing-issue%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276859%2fpython-csv-printing-issue%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I ran your code and works fine for me. Not able to re-produce the error.
– Mayank Porwal
Nov 13 '18 at 8:58
I imagine you could expect such an output if you mistakenly add
sto makewriter.writerows(['header 1', 'header 2', 'header 3', 'header 4'])– Amadan
Nov 13 '18 at 9:04
@MayankPorwal Exactly why i have to ask for something so simple on stackoverflow because on my other codes it worked fine. Just this particular code is giving me this error. I am completely bam-boozled. I think my code is possessed.
– AKJ
Nov 13 '18 at 9:38