Output a pandas dataframe to .XLSB (Excel Binary Workbook) format
1
Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).
Any guidance on if at all this is possible would be greatly appreciated.
python python-3.x pandas
edited Nov 24 '18 at 20:00
petezurich
3,65081835
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
add a comment |
1
Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).
Any guidance on if at all this is possible would be greatly appreciated.
python python-3.x pandas
edited Nov 24 '18 at 20:00
petezurich
3,65081835
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
add a comment |
1
1
1
Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).
Any guidance on if at all this is possible would be greatly appreciated.
python python-3.x pandas
edited Nov 24 '18 at 20:00
petezurich
3,65081835
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).
Any guidance on if at all this is possible would be greatly appreciated.
python python-3.x pandas
python python-3.x pandas
edited Nov 24 '18 at 20:00
petezurich
3,65081835
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
edited Nov 24 '18 at 20:00
petezurich
3,65081835
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
edited Nov 24 '18 at 20:00
petezurich
3,65081835
edited Nov 24 '18 at 20:00
petezurich
3,65081835
edited Nov 24 '18 at 20:00
petezurich
3,65081835
3,65081835
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
asked Nov 24 '18 at 19:38
Code_SipraCode_Sipra
487621
487621
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
-1
Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
Were you able to open the output file in excel? I tried theto_csvmethod. I am getting a message sayingExcel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?
– Code_Sipra
Nov 24 '18 at 19:56
its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.
– Subha Saha
Nov 24 '18 at 20:23
Just of curiosity , are you planning to use xlsb file for analysis purpose ?
– Subha Saha
Nov 24 '18 at 20:24
Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.
– Code_Sipra
Nov 24 '18 at 20:34
well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.
– Subha Saha
Nov 24 '18 at 20:58
|
show 6 more comments
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%2f53461728%2foutput-a-pandas-dataframe-to-xlsb-excel-binary-workbook-format%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
-1
Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
Were you able to open the output file in excel? I tried theto_csvmethod. I am getting a message sayingExcel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?
– Code_Sipra
Nov 24 '18 at 19:56
its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.
– Subha Saha
Nov 24 '18 at 20:23
Just of curiosity , are you planning to use xlsb file for analysis purpose ?
– Subha Saha
Nov 24 '18 at 20:24
Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.
– Code_Sipra
Nov 24 '18 at 20:34
well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.
– Subha Saha
Nov 24 '18 at 20:58
|
show 6 more comments
-1
Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
Were you able to open the output file in excel? I tried theto_csvmethod. I am getting a message sayingExcel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?
– Code_Sipra
Nov 24 '18 at 19:56
its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.
– Subha Saha
Nov 24 '18 at 20:23
Just of curiosity , are you planning to use xlsb file for analysis purpose ?
– Subha Saha
Nov 24 '18 at 20:24
Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.
– Code_Sipra
Nov 24 '18 at 20:34
well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.
– Subha Saha
Nov 24 '18 at 20:58
|
show 6 more comments
-1
-1
-1
Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
edited Jan 7 at 6:53
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
answered Nov 24 '18 at 19:48
Subha SahaSubha Saha
177
177
Were you able to open the output file in excel? I tried theto_csvmethod. I am getting a message sayingExcel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?
– Code_Sipra
Nov 24 '18 at 19:56
its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.
– Subha Saha
Nov 24 '18 at 20:23
Just of curiosity , are you planning to use xlsb file for analysis purpose ?
– Subha Saha
Nov 24 '18 at 20:24
Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.
– Code_Sipra
Nov 24 '18 at 20:34
well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.
– Subha Saha
Nov 24 '18 at 20:58
|
show 6 more comments
Were you able to open the output file in excel? I tried theto_csvmethod. I am getting a message sayingExcel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?
– Code_Sipra
Nov 24 '18 at 19:56
its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.
– Subha Saha
Nov 24 '18 at 20:23
Just of curiosity , are you planning to use xlsb file for analysis purpose ?
– Subha Saha
Nov 24 '18 at 20:24
Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.
– Code_Sipra
Nov 24 '18 at 20:34
well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.
– Subha Saha
Nov 24 '18 at 20:58
Were you able to open the output file in excel? I tried the
to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?– Code_Sipra
Nov 24 '18 at 19:56
Were you able to open the output file in excel? I tried the
to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?– Code_Sipra
Nov 24 '18 at 19:56
its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.
– Subha Saha
Nov 24 '18 at 20:23
its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.
– Subha Saha
Nov 24 '18 at 20:23
Just of curiosity , are you planning to use xlsb file for analysis purpose ?
– Subha Saha
Nov 24 '18 at 20:24
Just of curiosity , are you planning to use xlsb file for analysis purpose ?
– Subha Saha
Nov 24 '18 at 20:24
Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.
– Code_Sipra
Nov 24 '18 at 20:34
Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.
– Code_Sipra
Nov 24 '18 at 20:34
well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.
– Subha Saha
Nov 24 '18 at 20:58
well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.
– Subha Saha
Nov 24 '18 at 20:58
|
show 6 more comments
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%2f53461728%2foutput-a-pandas-dataframe-to-xlsb-excel-binary-workbook-format%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
