Pandas: How to extra only latest date in pivot table dataframe

Viewed 743

How do I create a new dataframe which only include as index the latest date of the column 'txn_date' for each 'day' based on the pivot table in the picture? Thank you

Pivot Table of time series

1 Answers
Related