CODEWITHSUNDEEP
pandaspython-2.7indexingexport-to-excel
lsheng
lsheng

Reputation: 3739

Export from pandas to_excel without row names (index)?

I'm trying to print out a dataframe from pandas 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?

Upvotes: 126

Views: 303416

Answers (4)

Dean
Dean

Reputation: 302

Ok Don't set the Sheet_name to the dataframe. I think you want the sheet name to be "test". It looks like the issue is in the sheet_name that you have set.

test = pd.DataFrame(biglist)
writer = pd.ExcelWriter('test.xlsx')
test.to_excel(writer, sheet_name="test", index=False)
writer.close()

Upvotes: 0

GTaylor
GTaylor

Reputation: 121

I did that and got the error message:

TypeError: 'DataFrame' objects are mutable, thus they cannot be hashed.

The code is as follows where 'test' is a dataframe with no column names

test = pd.DataFrame(biglist)
writer = pd.ExcelWriter("test.xlsx", engine='xlsxwriter')
test.to_excel(writer,sheet_name=test, index=False)
writer.save()

Upvotes: 4

Anurag Singh
Anurag Singh

Reputation: 571

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()

Upvotes: 54

EdChum
EdChum

Reputation: 394189

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

Upvotes: 211

Related Questions