Python Forum

Full Version: Exporting dataframes to excel without loosing datetime format

You're currently viewing a stripped down version of our content. View the full version with proper formatting.

I want to export to excel a DataFrame in which the index is formated in quarters (2019-Q1,2019-Q2...). However, when I export it to excel (through ExcelWriter), it looses the formatation and becomes a regular date. How can I mantain the quarter`s format when exporting it to excel?

Python Forum

Rafa