How to change column name to weekday in Python

Question

In python I have a column name on Pandas:

Example

country/Region 1/22/19  1/23/19  1/24/19  1/25/19  1/26/19

how can I change date to weekday

country/Region Tue   Wed       Thu     Fri       Sat

*It have a lot of column than Example

Where are these columns? In a file? Or a string? Or something else. See [ask], particularly how to create a [mcve]. — Peter Wood, May 14 '20 at 15:56
@PeterWood Thank you, I will read it before I ask question next time. — thexsecret, May 14 '20 at 15:59

score 0 · Accepted Answer · answered May 14 '20 at 15:56

0

Assuming all your columns are dates, use something like:

df.columns = [pd.to_datetime(col).day_name() for col in df.columns]

answered May 14 '20 at 15:56

ilyankou

1

@PeterWood The questioner confirmed it in a comment – Barmar May 14 '20 at 15:57
1

Thank you it works – thexsecret May 14 '20 at 16:14

1 Answers1