Dear All:
I have a daily price series. but some values in the price is NA and i want to replace it with that month's mean price value. I tried to run a for and if loop, but fail to deal with this.
Any help will be greatly appreciated.
date Price
2020-01-01 10
2020-01-02 23
2020-01-03 NA
2020-01-04 50
.
.
.
2020-01-31 67
2020-02-01 80
.
.
.
2020-11-10 100
Please note that not every month has NA values.
its not clear what representation of time series you are using. and particular package/class involved?
Could you share representative data here ? perhaps use dput(yourobjectname) so you can copy and paste it as runnable code.
Hi, thanks so much.
I solved it by using na.aggregate.
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.