---
title: "Discussion on \"pandas read_excel treats the title as the header: 'Unnamed: 1' columns and a total that is too low\" | Hashnode"
description: "Discussion on \"pandas read_excel treats the title as the header: 'Unnamed: 1' columns and a total that is too low\". The script printed Done with a total of 12,500 instead of 15,000. Then the repair crashed with a to_excel TypeError."
url: "https://hashnode.com/posts/pandas-read-excel-treats-the-title-as-the-header-unnamed-1-columns-and-a-total-that-is-too-low/6af0846e058f0fdd876b869b"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [pandas read\_excel treats the title as the header: 'Unnamed: 1' columns and a total that is too low](https://whackfirst.hashnode.dev/pandas-read-excel-treats-the-title-as-the-header-unnamed-1-columns-and-a-total-that-is-too-low?utm_source=hashnode&utm_medium=feed)

The script printed Done with a total of 12,500 instead of 15,000. Then the repair crashed with a to\_excel TypeError.

Nov 8 · 7 min read · whackfirst.hashnode.dev  
Updated Nov 9  
Read the article

-   [#pandas](https://hashnode.com/tag/pandas)
-   [#python](https://hashnode.com/tag/python)
-   [#excel](https://hashnode.com/tag/excel)
-   [#openpyxl](https://hashnode.com/tag/openpyxl)
-   [#debugging](https://hashnode.com/tag/debugging)

## Written by

[whackfirst](https://hashnode.com/@whackfirst)

@whackfirst

  
[View profile](https://hashnode.com/@whackfirst)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
