Extract Month and actual year from a Month Period Format

Question

Considering one dataframe with column which has values of the format " June 2021-22" or "January 2021-22", how do I parse Month and actual year from it?

This question is different because here we have values where year is i a period format ( "2022-23") and not a straightforward year. Thus the actual value will depend on the month considered based on the financial year.

Eg, in this case value should be June 2021 and January 2022. Appreciate the help !

`Thus the actual value will depend on the month considered based on the financial year.` - What month start financial year? — jezrael, Jun 26 '23 at 08:30
Financial year starts from April ( forgot to add it in the query) , thus 2021-22 starts from may 2021 and ends at April 2022. — user8112228, Jun 26 '23 at 10:14

score 1 · Accepted Answer · answered Jun 26 '23 at 08:21

1

Use:

df['date1'] = pd.to_datetime(df['date']).dt.strftime('%B %Y')
print (df)
              date         date1
0     June 2021-22     June 2021
1  January 2021-22  January 2021

answered Jun 26 '23 at 08:21

jezrael

822,522
95
1,334
1,252

Extract Month and actual year from a Month Period Format

1 Answers1