Python to_excel without row names (index)?

I'm trying to print out a dataframe into Excel. Here I am using to_excel() functions. However, I found that the 1st column in Excel is the "index",

0   6/6/2021 0:00   8/6/2021 0:00

1   4/10/2024 0:00  6/10/2024 0:00

2   4/14/2024 0:00  6/14/2024 0:00

Is there any ways to get rid of the first column?

asked Feb 28 '14 at 7:52

lsheng

1,75632233

2

Have you tried index=False as a param to to_excel? You could also exclude the first column as to_excel takes a cols param

– EdChum
Feb 28 '14 at 8:08

index = False works! Thanks very much!

– lsheng
Feb 28 '14 at 8:25

Cool, I've posted it as an answer along with some useful links

– EdChum
Feb 28 '14 at 8:27

add a comment |

I'm trying to print out a dataframe into Excel. Here I am using to_excel() functions. However, I found that the 1st column in Excel is the "index",

0   6/6/2021 0:00   8/6/2021 0:00

1   4/10/2024 0:00  6/10/2024 0:00

2   4/14/2024 0:00  6/14/2024 0:00

Is there any ways to get rid of the first column?

asked Feb 28 '14 at 7:52

lsheng

1,75632233

2

Have you tried index=False as a param to to_excel? You could also exclude the first column as to_excel takes a cols param

– EdChum
Feb 28 '14 at 8:08

index = False works! Thanks very much!

– lsheng
Feb 28 '14 at 8:25

Cool, I've posted it as an answer along with some useful links

– EdChum
Feb 28 '14 at 8:27

add a comment |

I'm trying to print out a dataframe into Excel. Here I am using to_excel() functions. However, I found that the 1st column in Excel is the "index",

0   6/6/2021 0:00   8/6/2021 0:00

1   4/10/2024 0:00  6/10/2024 0:00

2   4/14/2024 0:00  6/14/2024 0:00

Is there any ways to get rid of the first column?

asked Feb 28 '14 at 7:52

lsheng

1,75632233

I'm trying to print out a dataframe into Excel. Here I am using to_excel() functions. However, I found that the 1st column in Excel is the "index",

0   6/6/2021 0:00   8/6/2021 0:00

1   4/10/2024 0:00  6/10/2024 0:00

2   4/14/2024 0:00  6/14/2024 0:00

Is there any ways to get rid of the first column?

python-2.7 pandas export-to-excel

asked Feb 28 '14 at 7:52

lsheng

1,75632233

asked Feb 28 '14 at 7:52

lsheng

1,75632233

asked Feb 28 '14 at 7:52

lsheng

1,75632233

asked Feb 28 '14 at 7:52

lsheng

1,75632233

asked Feb 28 '14 at 7:52

lsheng

1,75632233

2

Have you tried index=False as a param to to_excel? You could also exclude the first column as to_excel takes a cols param

– EdChum
Feb 28 '14 at 8:08

index = False works! Thanks very much!

– lsheng
Feb 28 '14 at 8:25

Cool, I've posted it as an answer along with some useful links

– EdChum
Feb 28 '14 at 8:27

add a comment |

2

Have you tried index=False as a param to to_excel? You could also exclude the first column as to_excel takes a cols param

– EdChum
Feb 28 '14 at 8:08

index = False works! Thanks very much!

– lsheng
Feb 28 '14 at 8:25

Cool, I've posted it as an answer along with some useful links

– EdChum
Feb 28 '14 at 8:27

Have you tried index=False as a param to to_excel? You could also exclude the first column as to_excel takes a cols param

– EdChum
Feb 28 '14 at 8:08

index = False works! Thanks very much!

– lsheng
Feb 28 '14 at 8:25

Cool, I've posted it as an answer along with some useful links

– EdChum
Feb 28 '14 at 8:27

add a comment |

2 Answers
2

active

oldest

votes

You need to set index=False in to_excel in order for it to not write the index column out, this semantic is followed in other Pandas IO tools, see http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_excel.html and http://pandas.pydata.org/pandas-docs/stable/io.html

answered Feb 28 '14 at 8:26

EdChum

182k34395332

Thanks very much!!

– lsheng
Feb 28 '14 at 8:31

add a comment |

Example: index = False

import pandas as pd



writer = pd.ExcelWriter("dataframe.xlsx", engine='xlsxwriter')

dataframe.to_excel(writer,sheet_name = dataframe, index=False)

writer.save()

answered Nov 23 '18 at 14:33

Anurag Singh

311

I know this wasn't part of the original ask, but what if I want the data to append to an existing Excel spreadsheet and that spreadsheet is the old xls? (Please note, I can't change it or update it.)

– DataGirl
Jan 23 at 23:25

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%2f22089317%2fpython-to-excel-without-row-names-index%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

answered Feb 28 '14 at 8:26

EdChum

182k34395332

Thanks very much!!

– lsheng
Feb 28 '14 at 8:31

add a comment |

answered Feb 28 '14 at 8:26

EdChum

182k34395332

Thanks very much!!

– lsheng
Feb 28 '14 at 8:31

add a comment |

answered Feb 28 '14 at 8:26

EdChum

182k34395332

answered Feb 28 '14 at 8:26

EdChum

182k34395332

answered Feb 28 '14 at 8:26

EdChum

182k34395332

answered Feb 28 '14 at 8:26

EdChum

182k34395332

answered Feb 28 '14 at 8:26

EdChum

182k34395332

Thanks very much!!

– lsheng
Feb 28 '14 at 8:31

add a comment |

Thanks very much!!

– lsheng
Feb 28 '14 at 8:31

Thanks very much!!

– lsheng
Feb 28 '14 at 8:31

add a comment |

Example: index = False

import pandas as pd



writer = pd.ExcelWriter("dataframe.xlsx", engine='xlsxwriter')

dataframe.to_excel(writer,sheet_name = dataframe, index=False)

writer.save()

answered Nov 23 '18 at 14:33

Anurag Singh

311

I know this wasn't part of the original ask, but what if I want the data to append to an existing Excel spreadsheet and that spreadsheet is the old xls? (Please note, I can't change it or update it.)

– DataGirl
Jan 23 at 23:25

add a comment |

Example: index = False

import pandas as pd



writer = pd.ExcelWriter("dataframe.xlsx", engine='xlsxwriter')

dataframe.to_excel(writer,sheet_name = dataframe, index=False)

writer.save()

answered Nov 23 '18 at 14:33

Anurag Singh

311

I know this wasn't part of the original ask, but what if I want the data to append to an existing Excel spreadsheet and that spreadsheet is the old xls? (Please note, I can't change it or update it.)

– DataGirl
Jan 23 at 23:25

add a comment |

Example: index = False

import pandas as pd



writer = pd.ExcelWriter("dataframe.xlsx", engine='xlsxwriter')

dataframe.to_excel(writer,sheet_name = dataframe, index=False)

writer.save()

answered Nov 23 '18 at 14:33

Anurag Singh

311

Example: index = False

import pandas as pd



writer = pd.ExcelWriter("dataframe.xlsx", engine='xlsxwriter')

dataframe.to_excel(writer,sheet_name = dataframe, index=False)

writer.save()

answered Nov 23 '18 at 14:33

Anurag Singh

311

answered Nov 23 '18 at 14:33

Anurag Singh

311

answered Nov 23 '18 at 14:33

Anurag Singh

311

answered Nov 23 '18 at 14:33

Anurag Singh

311

I know this wasn't part of the original ask, but what if I want the data to append to an existing Excel spreadsheet and that spreadsheet is the old xls? (Please note, I can't change it or update it.)

– DataGirl
Jan 23 at 23:25

add a comment |

I know this wasn't part of the original ask, but what if I want the data to append to an existing Excel spreadsheet and that spreadsheet is the old xls? (Please note, I can't change it or update it.)

– DataGirl
Jan 23 at 23:25

I know this wasn't part of the original ask, but what if I want the data to append to an existing Excel spreadsheet and that spreadsheet is the old xls? (Please note, I can't change it or update it.)

– DataGirl
Jan 23 at 23:25

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

Search This Blog

Ufyukyu