---
title: "Discussion on \"TypeError: '<' not supported between instances of 'str' and 'Timestamp' when merging Excel files in pandas\" | Hashnode"
description: "Discussion on \"TypeError: '<' not supported between instances of 'str' and 'Timestamp' when merging Excel files in pandas\". One workbook holds a real date, another holds the text 2026.10.04. How to see it, and a repair that refuses to guess."
url: "https://hashnode.com/posts/typeerror-not-supported-between-instances-of-str-and-timestamp-when-merging-excel-files-in-pandas/6af0841707a70d02352f9d50"
---

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

Discussion

# [TypeError: '<' not supported between instances of 'str' and 'Timestamp' when merging Excel files in pandas](https://whackfirst.hashnode.dev/typeerror-not-supported-between-instances-of-str-and-timestamp-when-merging-excel-files-in-pandas?utm_source=hashnode&utm_medium=feed)

One workbook holds a real date, another holds the text 2026.10.04. How to see it, and a repair that refuses to guess.

Nov 8 · 6 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.
