[R] R-hts

[deva d]

thanks jeff and jeremie,

i am attaching 40 rows of the data, randomly picked from the large table.

the vars are - entity (1-46, with some missing IDs not included due to
missing data), group (1/2), sub group (1/2/3/4), year (2002-2016), y, x1
and x2 - large values included due to size of players - (may not be
considered as outliers as they constitute the sample and are important
countrywide entities)

hope this helps.

i thought an hts may be a better analytical tool compared to panel (a pivot
table in excel helps me obtain some aggregation), hence the query ...

thanks for your guidance,

*....*

*Deva*


...............



*in search of knowledge, everyday something is added ....*

*in search of wisdom, everyday something is dropped  ... an old Chinese
Proverb*
:::::::::::::::::::::::::

On Thu, Jan 11, 2018 at 12:22 AM, Jeff Newmiller <jdnewmil at dcn.davis.ca.us>
wrote:

> Sorry Jérémie, I mis-read who the OP was. Deva needs to get the ball
> rolling.
>
> I would say that for a hierarchical analysis the sample data generally
> needs to be larger than for other types of analysis to illustrate
> correlation between classification variables or the example calculation
> will break. That is, 10 rows will likely be insufficient for a dry run.
>
> --
> Sent from my phone. Please excuse my brevity.
>
> On January 10, 2018 2:02:29 PM PST, Jeff Newmiller <
> jdnewmil at dcn.davis.ca.us> wrote:
> >You are the one with data. Supply what you have (or a simulated version
> >of same, hence the reading recommendation) using dput, and someone may
> >suggest how to transform it. In most cases a simple tabular format
> >(data frame) is sufficient.
> >--
> >Sent from my phone. Please excuse my brevity.
> >
> >On January 10, 2018 12:20:47 PM PST, "Jérémie Juste"
> ><jeremiejuste at gmail.com> wrote:
> >>Hello,
> >>
> >>It's difficult to help without a sample of the format. Can you provide
> >>a
> >>short sample like 10 lines and a few columns.?
> >>
> >>Best regards,
> >>Jeremie
> >>
> >>
> >>On Wed, Jan 10, 2018 at 6:12 PM, John Kane via R-help
> >><r-help at r-project.org>
> >>wrote:
> >>
> >>> Have a look at
> >>http://stackoverflow.com/questions/5963269/how-to-make-
> >>> a-great-r-reproducible-example
> >>> and
> >>> http://adv-r.had.co.nz/Reproducibility.html
> >>>
> >>>
> >>>
> >>>
> >>>     On Wednesday, January 10, 2018, 11:51:22 AM EST, deva d <
> >>> devazresearch at gmail.com> wrote:
> >>>
> >>>  dear all,
> >>>
> >>> i need some help in structuring my data file for a hierarchical time
> >>series
> >>> analysis.
> >>>
> >>> can someone help please ?
> >>>
> >>> i have a 600 row database in the nature of a panel data, with 3 time
> >>series
> >>> values of interest. the data also has 4 classificatory variables
> >>comprising
> >>> a code for each entity in the panel, a value for time (year), and
> >>> classification of type of entity and a further sub-group of the
> >type.
> >>>
> >>> i am unable to structure the data file for performing the hts
> >>analysis.
> >>>
> >>> thanks in advance.
> >>>
> >>> *....*
> >>>
> >>> *Deva*
> >>>
> >>>
> >>> ...............
> >>>
> >>>
> >>>
> >>> *in search of knowledge, everyday something is added ....*
> >>>
> >>> *in search of wisdom, everyday something is dropped  ... an old
> >>Chinese
> >>> Proverb*
> >>> :::::::::::::::::::::::::
> >>>
> >>>     [[alternative HTML version deleted]]
> >>>
> >>> ______________________________________________
> >>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> >>> https://stat.ethz.ch/mailman/listinfo/r-help
> >>> PLEASE do read the posting guide http://www.R-project.org/
> >>> posting-guide.html
> >>> and provide commented, minimal, self-contained, reproducible code.
> >>>
> >>>         [[alternative HTML version deleted]]
> >>>
> >>> ______________________________________________
> >>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> >>> https://stat.ethz.ch/mailman/listinfo/r-help
> >>> PLEASE do read the posting guide http://www.R-project.org/
> >>> posting-guide.html
> >>> and provide commented, minimal, self-contained, reproducible code.
> >>>
> >>
> >>
> >>
> >>--
> >>Jérémie Juste
> >>
> >>      [[alternative HTML version deleted]]
> >>
> >>______________________________________________
> >>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> >>https://stat.ethz.ch/mailman/listinfo/r-help
> >>PLEASE do read the posting guide
> >>http://www.R-project.org/posting-guide.html
> >>and provide commented, minimal, self-contained, reproducible code.
> >
> >______________________________________________
> >R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> >https://stat.ethz.ch/mailman/listinfo/r-help
> >PLEASE do read the posting guide
> >http://www.R-project.org/posting-guide.html
> >and provide commented, minimal, self-contained, reproducible code.
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/
> posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.