Hello,
I have a data set has
2001Q1 100
2001Q2 101
2001Q3 120
2001Q4 103
...
And would like to convert it to a monthly data. i.e.
200101 XXX
200102 XXX
200103 XXX
200104 XXX
200105 XXX
200106 XXX
200107 XXX
200108 XXX
200109 XXX
200110 XXX
200111 XXX
200112 XXX
I googled for "convert quarterly data to monthly data R" but most
search results shows how to convert monthly data to quarterly data, not the way
I need.
Is there any library or function in R can do that?
Thanks very much!
Cheers,
Rebecca
----------------------------------------------------------------------
This message, and any attachments, is for the intended r...{{dropped:5}}
This question doesn't make a lot of sense to me. What do
you expect/want your "XXX" values to be? If you only know
that the value for the first quarter was 100, you cannot infer
the individual values for January, February and March. All
you know is that these values sum to 100.
cheers,
Rolf Turner
On 02/21/2013 08:15 AM, Yuan, Rebecca wrote:> Hello,
>
> I have a data set has
>
> 2001Q1 100
> 2001Q2 101
> 2001Q3 120
> 2001Q4 103
> ...
>
>
> And would like to convert it to a monthly data. i.e.
>
> 200101 XXX
> 200102 XXX
> 200103 XXX
> 200104 XXX
> 200105 XXX
> 200106 XXX
> 200107 XXX
> 200108 XXX
> 200109 XXX
> 200110 XXX
> 200111 XXX
> 200112 XXX
>
> I googled for "convert quarterly data to monthly data R" but most
search results shows how to convert monthly data to quarterly data, not the way
I need.
>
> Is there any library or function in R can do that?
>
> Thanks very much!
>