Periods not correctly represented in to_excel() with monthly PeriodIndex

[andreas-h]

When I have a Panel with a PeriodIndex with freq="M" and I use mypanel.to_excel(), then the PeriodIndex gets represented as YYYY-MM-DD in the output Excel file. I would expect it to be rather YYYY-MM.

Is this a bug or a feature?

[jreback]

not implemented

to_excel should deal with different kinds of indices better

welcome to have a PR though!

[jmcnamara]

We could add ExcelWriter options to pass default date and time formats as strings. Currently the date/time format strings are hardcoded.

This would be relatively easy to implement. Feel free to assign the issue/PR to me.

[jtratner]

@jmcnamara you are assigned to this :)

[jreback]

closed via 19ae1dc