Mixing
to excel pivot table in tabular view/repeat items
-1
I would like to send to excel a pivot table done with python/pandas in a tabular view repeating in each line the item values:
Thank you for your help!
Here the code:
df2 = pd.pivot_table(dataframe,index=
['COD_ARTC','COD_COLR','START_CONF_WEEK', 'START_REQ_WEEK'],values =
'QTY_ORDERED',aggfunc=np.sum)
writer_orig = pd.ExcelWriter('test2.xlsx', engine='xlsxwriter')
df2.to_excel(writer_orig, index=True)
writer_orig.save()
Output in the file 'test2.xlsx':
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
201903 201851 6
201903 33
But I would like to have this:
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
SKU41-51 black 201903 201851 6
SKU41-51 black 201903 201903 33
python-3.x pandas pivot-table
edited Dec 31 '18 at 9:38
Siyu
3,08411231
asked Dec 31 '18 at 9:10
srmelsrmel
1
add a comment |
-1
I would like to send to excel a pivot table done with python/pandas in a tabular view repeating in each line the item values:
Thank you for your help!
Here the code:
df2 = pd.pivot_table(dataframe,index=
['COD_ARTC','COD_COLR','START_CONF_WEEK', 'START_REQ_WEEK'],values =
'QTY_ORDERED',aggfunc=np.sum)
writer_orig = pd.ExcelWriter('test2.xlsx', engine='xlsxwriter')
df2.to_excel(writer_orig, index=True)
writer_orig.save()
Output in the file 'test2.xlsx':
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
201903 201851 6
201903 33
But I would like to have this:
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
SKU41-51 black 201903 201851 6
SKU41-51 black 201903 201903 33
python-3.x pandas pivot-table
edited Dec 31 '18 at 9:38
Siyu
3,08411231
asked Dec 31 '18 at 9:10
srmelsrmel
1
1
Hi, welcome to stack overflow. Please refer the How to Ask link for more details on how to ask a question and update your question accordingly.
– Jeroen Heier
Dec 31 '18 at 9:12
did you mean usingdf2.ffill()?
– anky_91
Dec 31 '18 at 9:57
add a comment |
-1
-1
-1
I would like to send to excel a pivot table done with python/pandas in a tabular view repeating in each line the item values:
Thank you for your help!
Here the code:
df2 = pd.pivot_table(dataframe,index=
['COD_ARTC','COD_COLR','START_CONF_WEEK', 'START_REQ_WEEK'],values =
'QTY_ORDERED',aggfunc=np.sum)
writer_orig = pd.ExcelWriter('test2.xlsx', engine='xlsxwriter')
df2.to_excel(writer_orig, index=True)
writer_orig.save()
Output in the file 'test2.xlsx':
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
201903 201851 6
201903 33
But I would like to have this:
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
SKU41-51 black 201903 201851 6
SKU41-51 black 201903 201903 33
python-3.x pandas pivot-table
edited Dec 31 '18 at 9:38
Siyu
3,08411231
asked Dec 31 '18 at 9:10
srmelsrmel
1
I would like to send to excel a pivot table done with python/pandas in a tabular view repeating in each line the item values:
Thank you for your help!
Here the code:
df2 = pd.pivot_table(dataframe,index=
['COD_ARTC','COD_COLR','START_CONF_WEEK', 'START_REQ_WEEK'],values =
'QTY_ORDERED',aggfunc=np.sum)
writer_orig = pd.ExcelWriter('test2.xlsx', engine='xlsxwriter')
df2.to_excel(writer_orig, index=True)
writer_orig.save()
Output in the file 'test2.xlsx':
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
201903 201851 6
201903 33
But I would like to have this:
COD_ARTC COD_COLR START_CONF_WEEK START_REQ_WEEK QTY_ORDERED
SKU41-51 black 201852 201852 15
SKU41-51 black 201903 201851 6
SKU41-51 black 201903 201903 33
python-3.x pandas pivot-table
python-3.x pandas pivot-table
edited Dec 31 '18 at 9:38
Siyu
3,08411231
asked Dec 31 '18 at 9:10
srmelsrmel
1
edited Dec 31 '18 at 9:38
Siyu
3,08411231
asked Dec 31 '18 at 9:10
srmelsrmel
1
edited Dec 31 '18 at 9:38
Siyu
3,08411231
edited Dec 31 '18 at 9:38
Siyu
3,08411231
edited Dec 31 '18 at 9:38
Siyu
3,08411231
3,08411231
asked Dec 31 '18 at 9:10
srmelsrmel
1
asked Dec 31 '18 at 9:10
srmelsrmel
1
asked Dec 31 '18 at 9:10
srmelsrmel
1
1
1
Hi, welcome to stack overflow. Please refer the How to Ask link for more details on how to ask a question and update your question accordingly.
– Jeroen Heier
Dec 31 '18 at 9:12
did you mean usingdf2.ffill()?
– anky_91
Dec 31 '18 at 9:57
add a comment |
1
Hi, welcome to stack overflow. Please refer the How to Ask link for more details on how to ask a question and update your question accordingly.
– Jeroen Heier
Dec 31 '18 at 9:12
did you mean usingdf2.ffill()?
– anky_91
Dec 31 '18 at 9:57
1
1
Hi, welcome to stack overflow. Please refer the How to Ask link for more details on how to ask a question and update your question accordingly.
– Jeroen Heier
Dec 31 '18 at 9:12
Hi, welcome to stack overflow. Please refer the How to Ask link for more details on how to ask a question and update your question accordingly.
– Jeroen Heier
Dec 31 '18 at 9:12
did you mean using
df2.ffill() ?– anky_91
Dec 31 '18 at 9:57
did you mean using
df2.ffill() ?– anky_91
Dec 31 '18 at 9:57
add a comment |
1 Answer
1
active
oldest
votes
0
if I add merge_cells=False in to_ excel, it works
df2.to_excel(writer_orig, index=True, merge_cells=False)
answered Jan 2 at 8:56
srmelsrmel
1
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');
});
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%2f53985586%2fto-excel-pivot-table-in-tabular-view-repeat-items%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
if I add merge_cells=False in to_ excel, it works
df2.to_excel(writer_orig, index=True, merge_cells=False)
answered Jan 2 at 8:56
srmelsrmel
1
add a comment |
0
if I add merge_cells=False in to_ excel, it works
df2.to_excel(writer_orig, index=True, merge_cells=False)
answered Jan 2 at 8:56
srmelsrmel
1
add a comment |
0
0
0
if I add merge_cells=False in to_ excel, it works
df2.to_excel(writer_orig, index=True, merge_cells=False)
answered Jan 2 at 8:56
srmelsrmel
1
if I add merge_cells=False in to_ excel, it works
df2.to_excel(writer_orig, index=True, merge_cells=False)
answered Jan 2 at 8:56
srmelsrmel
1
answered Jan 2 at 8:56
srmelsrmel
1
answered Jan 2 at 8:56
srmelsrmel
1
answered Jan 2 at 8:56
srmelsrmel
1
1
add a comment |
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');
});
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%2f53985586%2fto-excel-pivot-table-in-tabular-view-repeat-items%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
1
Hi, welcome to stack overflow. Please refer the How to Ask link for more details on how to ask a question and update your question accordingly.
– Jeroen Heier
Dec 31 '18 at 9:12
did you mean using
df2.ffill()?– anky_91
Dec 31 '18 at 9:57