How would I interpolate monthly->daily for a single column in a dataframe?
Example DF:
df = pd.DataFrame({'date': date, 'one': np.random.randint(100, 200, date.size),
'two': np.random.randint(100, 200, date.size)})
date one two
0 1991-01-01 149 157
1 1991-02-01 173 160
2 1991-03-01 168 135
3 1991-04-01 141 174
4 1991-05-01 169 161
5 1991-06-01 186 132
6 1991-07-01 181 191
7 1991-08-01 108 102
8 1991-09-01 197 189
9 1991-10-01 105 174
10 1991-11-01 144 138
To interpolate to daily and drop the last date:
df.set_index('date').resample('D').interpolate()[:-1]
I want to output daily values for 'date' and 'one', and ignore 'two'. Do I need to break it up into steps or similar?