I have monthly data. When I apply resampling by day and cubic interpolation, there is a function to find the month end data
INPUT MONTHLY DATA
Period Values
Jan-22 1
Feb-22 3
Mar-22 7
Apr-22 5
May-22 4
After re-sampling by day and with cubic interpolation
Period
2022-01-01 1.000000
2022-01-02 0.884487
2022-01-03 0.785650
2022-01-04 0.703004
2022-01-05 0.636066
2022-01-06 0.584353
2022-01-07 0.547382
2022-01-08 0.524668
2022-01-09 0.515729
2022-01-10 0.520081
2022-01-11 0.537240
2022-01-12 0.566724
2022-01-13 0.608048
and so on
Desired output is Monday of each week
2022-01-03 0.785650
2022-01-10 0.520081
and so on
Thank you
import pandas as pd df=pd.read_excel(input_file, sheet_name='mthly', usecols='A:D', na_values='ND', index_col=0, header=0) df.index.names = ['Period'] df.index = pd.to_datetime(df.index) q= pd.Series(df[series], index=df.index) d = q.resample('D').interpolate(method='cubic') m=d[d.index.is_month_end]Now I want the data for the start of each week, but I can't find such a function. How do I solve this?
INPUT MONTHLY DATA
Period Values
Jan-22 1
Feb-22 3
Mar-22 7
Apr-22 5
May-22 4
After re-sampling by day and with cubic interpolation
Period
2022-01-01 1.000000
2022-01-02 0.884487
2022-01-03 0.785650
2022-01-04 0.703004
2022-01-05 0.636066
2022-01-06 0.584353
2022-01-07 0.547382
2022-01-08 0.524668
2022-01-09 0.515729
2022-01-10 0.520081
2022-01-11 0.537240
2022-01-12 0.566724
2022-01-13 0.608048
and so on
Desired output is Monday of each week
2022-01-03 0.785650
2022-01-10 0.520081
and so on
Thank you