[R] A challenging question: merging excel files under a specific pattern

2012-07-03 Thread Stef Salvez
Dear all, I have an excel file that contains 6 sheets 1,2,3,4,5,6 The analysis is repeated every 3 sheets Sheets 1, 2, 3: I want to add (horizontally) the data contained in the matrix : sheet2 (5:end,3:end ) of *Sheet2 * to the sheet3 such that the first element of the matrix *sheet2 (5:end,3

Re: [R] Temporal disaggregation

2012-06-17 Thread stef salvez
or put differently, I want to change the data frequency of the time series to monthly thanks On 6/17/12, stef salvez wrote: > you are right Jeff and sorry for this > > I will try to explain what I want. > > I have the following dataset > > dat <- data.fra

Re: [R] Temporal disaggregation

2012-06-17 Thread stef salvez
Basics: ##.#. ##.#. Live Go... > Live: OO#.. Dead: OO#.. Playing > Research Engineer (Solar/BatteriesO.O#. #.O#. with > /Software/Embedded Controllers) .OO#. .OO#. rocks...1k > ---

[R] Temporal disaggregation

2012-06-16 Thread stef salvez
Dear R users, I have a panel data set (in MS excel) on prices across countries and time countrytime price 1 "23/11/08"2 1 "28/12/08" 3 1"25/01/09" 4 1 "22/02/09" 5 1"29/03/09"

Re: [R] interpolation to montly data

2012-06-16 Thread stef salvez
I would like to clarify that since each observation is obtained every 28 days, each such observation is a 4-week average thanks On 6/16/12, stef salvez wrote: > I have a panel data set (in MS excel) like the one below > > > 1 "23/11/08"

[R] interpolation to montly data

2012-06-16 Thread stef salvez
I have a panel data set (in MS excel) like the one below 1 "23/11/08"2 1 "28/12/08" 3 1"25/01/09" 4 1 "22/02/09" 5 1"29/03/09" 6 1 "26/04/09" 32 1 "24/05/09"

[R] data analysis problem

2012-06-04 Thread stef salvez
Dear R users, I have data on 4 types of interest rates. These rates evolve over time and across regions of countries . So for each type of interest rates I want to run a regression of rates on some other variables. So my regression for one type of interest rate will be I_{ij}_t= a +regressors

[R] plotting evolution of dates

2012-06-03 Thread stef salvez
Dear R users, I have the following problem I have a panel data across countries and individuals. For each country I have a sequence of dates For France for example 22/02/09 22/03/09 19/04/09 17/05/09 12/07/09 09/08/09 06/09/09 04/10/09 01/11/09 29/11/09 27/12/09 31/01/10 For Italy 14/06/09 12/07