Printing output by looping through each item not correct
I have a table that stores definitions of various terms of our stores like store_name, store_location and others. Given below is the view of how our table looks like:
store_name,store_location,store_workinghours
store_a,madison_square,9am-9pm
I am trying to print this such that I have each definition to the right of each term as shown below:
store_name,store_a
store_location,madison_square
store_workinghours,9am-9pm
I am trying to do this as below:
row = 1
col = 1
for values in table:
for idx, value in enumerate(values):
worksheet.write(current_col, idx, value, number_format)
current_col += 1
I however see the above logic prints the data as well
store_name
store_a,madison_square
Could anyone advice as to where am I going wrong with the above. Thanks
Update :
cursor.execute('select {} from table'.format(', '.join(str(label) for label in label_names)))
table = cursor.fetchall()
python python-3.x for-loop
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
add a comment |
I have a table that stores definitions of various terms of our stores like store_name, store_location and others. Given below is the view of how our table looks like:
store_name,store_location,store_workinghours
store_a,madison_square,9am-9pm
I am trying to print this such that I have each definition to the right of each term as shown below:
store_name,store_a
store_location,madison_square
store_workinghours,9am-9pm
I am trying to do this as below:
row = 1
col = 1
for values in table:
for idx, value in enumerate(values):
worksheet.write(current_col, idx, value, number_format)
current_col += 1
I however see the above logic prints the data as well
store_name
store_a,madison_square
Could anyone advice as to where am I going wrong with the above. Thanks
Update :
cursor.execute('select {} from table'.format(', '.join(str(label) for label in label_names)))
table = cursor.fetchall()
python python-3.x for-loop
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
What istablehere? A dictionary?
– Mayank Porwal
Nov 24 '18 at 19:02
@MayankPorwal, it is the output of a SQL query that has all of these definitions.. I have updated my initial post with this remark on table and how it's generated.
– scott martin
Nov 24 '18 at 19:05
Can you tell me what is the output oftype(table)?
– Mayank Porwal
Nov 24 '18 at 19:15
@MayankPorwal, its <class 'list'>
– scott martin
Nov 24 '18 at 19:17
add a comment |
I have a table that stores definitions of various terms of our stores like store_name, store_location and others. Given below is the view of how our table looks like:
store_name,store_location,store_workinghours
store_a,madison_square,9am-9pm
I am trying to print this such that I have each definition to the right of each term as shown below:
store_name,store_a
store_location,madison_square
store_workinghours,9am-9pm
I am trying to do this as below:
row = 1
col = 1
for values in table:
for idx, value in enumerate(values):
worksheet.write(current_col, idx, value, number_format)
current_col += 1
I however see the above logic prints the data as well
store_name
store_a,madison_square
Could anyone advice as to where am I going wrong with the above. Thanks
Update :
cursor.execute('select {} from table'.format(', '.join(str(label) for label in label_names)))
table = cursor.fetchall()
python python-3.x for-loop
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
I have a table that stores definitions of various terms of our stores like store_name, store_location and others. Given below is the view of how our table looks like:
store_name,store_location,store_workinghours
store_a,madison_square,9am-9pm
I am trying to print this such that I have each definition to the right of each term as shown below:
store_name,store_a
store_location,madison_square
store_workinghours,9am-9pm
I am trying to do this as below:
row = 1
col = 1
for values in table:
for idx, value in enumerate(values):
worksheet.write(current_col, idx, value, number_format)
current_col += 1
I however see the above logic prints the data as well
store_name
store_a,madison_square
Could anyone advice as to where am I going wrong with the above. Thanks
Update :
cursor.execute('select {} from table'.format(', '.join(str(label) for label in label_names)))
table = cursor.fetchall()
python python-3.x for-loop
python python-3.x for-loop
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
edited Nov 24 '18 at 19:05
scott martin
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
asked Nov 24 '18 at 18:52
scott martinscott martin
1058
1058
What istablehere? A dictionary?
– Mayank Porwal
Nov 24 '18 at 19:02
@MayankPorwal, it is the output of a SQL query that has all of these definitions.. I have updated my initial post with this remark on table and how it's generated.
– scott martin
Nov 24 '18 at 19:05
Can you tell me what is the output oftype(table)?
– Mayank Porwal
Nov 24 '18 at 19:15
@MayankPorwal, its <class 'list'>
– scott martin
Nov 24 '18 at 19:17
add a comment |
What istablehere? A dictionary?
– Mayank Porwal
Nov 24 '18 at 19:02
@MayankPorwal, it is the output of a SQL query that has all of these definitions.. I have updated my initial post with this remark on table and how it's generated.
– scott martin
Nov 24 '18 at 19:05
Can you tell me what is the output oftype(table)?
– Mayank Porwal
Nov 24 '18 at 19:15
@MayankPorwal, its <class 'list'>
– scott martin
Nov 24 '18 at 19:17
What is
table here? A dictionary?– Mayank Porwal
Nov 24 '18 at 19:02
What is
table here? A dictionary?– Mayank Porwal
Nov 24 '18 at 19:02
@MayankPorwal, it is the output of a SQL query that has all of these definitions.. I have updated my initial post with this remark on table and how it's generated.
– scott martin
Nov 24 '18 at 19:05
@MayankPorwal, it is the output of a SQL query that has all of these definitions.. I have updated my initial post with this remark on table and how it's generated.
– scott martin
Nov 24 '18 at 19:05
Can you tell me what is the output of
type(table)?– Mayank Porwal
Nov 24 '18 at 19:15
Can you tell me what is the output of
type(table)?– Mayank Porwal
Nov 24 '18 at 19:15
@MayankPorwal, its <class 'list'>
– scott martin
Nov 24 '18 at 19:17
@MayankPorwal, its <class 'list'>
– scott martin
Nov 24 '18 at 19:17
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%2f53461364%2fprinting-output-by-looping-through-each-item-not-correct%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.
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%2f53461364%2fprinting-output-by-looping-through-each-item-not-correct%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
What is
tablehere? A dictionary?– Mayank Porwal
Nov 24 '18 at 19:02
@MayankPorwal, it is the output of a SQL query that has all of these definitions.. I have updated my initial post with this remark on table and how it's generated.
– scott martin
Nov 24 '18 at 19:05
Can you tell me what is the output of
type(table)?– Mayank Porwal
Nov 24 '18 at 19:15
@MayankPorwal, its <class 'list'>
– scott martin
Nov 24 '18 at 19:17