Export from pandas to_excel without row names (index)?

ghz 1years ago ⋅ 1642 views

Question

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?

Answer

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

#pandas

ghz
- 8593Posts
- 0Comments
Favorites 0

Hot

1. Switch between two frames in tkinter?
2. Generating CSV file for Excel, how to have a newline inside a value
3. []byte(string) vs []byte(*string)
4. Kubernetes Service cluster IP, how is this internally load balanced across different nodes
5. PHP Startup Unable to load dynamic library php_mongo.dll
6. Make absolute positioned div expand parent div height

Latest

1. Web-scraping Remax.com in python
2. Problem in Selenium Browserstack session: loading existing Chrom
3. Python get XML siblings into dictionary
4. Setting my source to a file path outside of flask static f
5. Confusing probabilities from scikit-learn randomforest
6. Python calling an SDK function in DLL of a sensor that takes poi