Petr and David, Thank you so much! Both approaches do precisely what I need. I knew there had to be a very simple way to do this, but I am still very much a novice and struggle with data management at times. Also, thank you for the suggestion to use dput(yourdata) or dput(yourdata[1:20,]) -- I knew such a thing existed and search for it, but just could not recall the 'dput' command name.
Regards, Tom On Wed, Jun 1, 2016 at 7:23 AM, PIKAL Petr <petr.pi...@precheza.cz> wrote: > Hi > > It is preferable to use output of > > dput(yourdata) or dput(yourdata[1:20,]) > > so that we can use your data. > > From your description maybe > > boxplot(split(yourdata$value, yourdata$valid_time)) > > can give you what you want. > > Regards > Petr > > > -----Original Message----- > > From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Thomas > > Adams > > Sent: Wednesday, June 1, 2016 2:07 PM > > To: r-help@r-project.org > > Subject: [R] Help needed to format data for boxplot time-series > > > > All: > > > > I have used R in combination with GRASS GIS spatial data (using spgrass) > > many times in the past to generate a 'time series' of boxplots, to show > > variations over time. But I have a new problem, not involving spatial > data, but > > rather, true time-series data (snippet shown below). So, what I want to > do is > > to generate a 'time-series' of boxplots based on the column 'valid_time' > for > > the 'values' column data. What I can not figure out is how to either > select or > > format the data for the series of individual boxplots. > > Somehow it seems I need to use reshape; do I group the data within a > loop? > > This does not seem efficient. The full set of data I have covers a 30 > day period > > at 6-hourly time steps with 9320 rows > > > > Data > > > > lid|ens_num|basis_time|valid_time|value > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-21 00:00:00|1431.4787995285 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-21 00:00:00|740.777643846512 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-21 00:00:00|740.777778561401 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-21 00:00:00|740.777441774178 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-21 00:00:00|740.777441774178 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-21 06:00:00|1430.25545361671 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-21 06:00:00|673.404235368919 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-21 06:00:00|673.404370083809 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-21 06:00:00|673.404235368919 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-21 06:00:00|673.404235368919 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-21 12:00:00|1429.0170196373 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-21 12:00:00|602.801441559601 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-21 12:00:00|602.801239487267 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-21 12:00:00|602.801441559601 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-21 12:00:00|602.801441559601 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-21 18:00:00|1427.75029553108 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-21 18:00:00|532.976794630909 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-21 18:00:00|532.976727273464 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-21 18:00:00|532.97639048624 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-21 18:00:00|532.976895667076 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-22 00:00:00|1426.44531239624 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-22 00:00:00|467.520648461056 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-22 00:00:00|467.520513746166 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-22 00:00:00|467.520379031277 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-22 00:00:00|467.520783175945 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-22 06:00:00|1425.14127226563 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-22 06:00:00|408.103669752502 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-22 06:00:00|408.105117937565 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-22 06:00:00|408.102255246162 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-22 06:00:00|408.193086760426 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-22 12:00:00|1423.73767783165 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-22 12:00:00|356.017269114971 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-22 12:00:00|356.245105671883 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-22 12:00:00|355.568634854126 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-22 12:00:00|357.646308916569 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-22 18:00:00|1422.30188653908 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-22 18:00:00|310.664962696362 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-22 18:00:00|310.956081572628 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-22 18:00:00|310.891788891602 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-22 18:00:00|311.764674018288 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-23 00:00:00|1420.79065490837 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-23 00:00:00|271.319441647482 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-23 00:00:00|271.90585556159 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-23 00:00:00|272.571818617964 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-23 00:00:00|272.197900602722 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-23 06:00:00|1419.24197253838 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-23 06:00:00|238.587209240341 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-23 06:00:00|238.386618769836 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-23 06:00:00|246.312821885538 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-23 06:00:00|237.956154179716 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-23 12:00:00|1417.63953892746 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-23 12:00:00|209.872343232489 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-23 12:00:00|209.899606158257 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-23 12:00:00|215.785316521025 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-23 12:00:00|208.711723941135 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-23 18:00:00|1415.99035924988 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-23 18:00:00|184.638914114666 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-23 18:00:00|184.573223766661 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-23 18:00:00|189.508672138071 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-23 18:00:00|183.818062614059 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-24 00:00:00|1414.29375993118 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-24 00:00:00|162.991595356035 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-24 00:00:00|162.881398576403 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-24 00:00:00|166.706644703865 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-24 00:00:00|162.506082894182 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-24 06:00:00|1411.73094387283 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-24 06:00:00|144.685525805521 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-24 06:00:00|144.518832969093 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-24 06:00:00|147.765293413067 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-24 06:00:00|144.311169966888 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-24 12:00:00|1409.87780585251 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-24 12:00:00|128.826771134949 > > MDBV1|ens02|2016-04-20 18:00:00|2016-04-24 12:00:00|128.591449481988 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-24 12:00:00|131.575131694579 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-24 12:00:00|128.445443800783 > > MDBV1|ens01|2016-04-19 06:00:00|2016-04-24 18:00:00|1407.97159016571 > > MDBV1|ens01|2016-04-20 18:00:00|2016-04-24 18:00:00|115.098490343833 > > MDBV1|ens03|2016-04-20 18:00:00|2016-04-24 18:00:00|117.685470885491 > > MDBV1|ens04|2016-04-20 18:00:00|2016-04-24 18:00:00|114.647296500087 > > > > > > Thank you, > > Tom > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help@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. > > ________________________________ > Tento e-mail a jakékoliv k němu připojené dokumenty jsou důvěrné a jsou > určeny pouze jeho adresátům. > Jestliže jste obdržel(a) tento e-mail omylem, informujte laskavě > neprodleně jeho odesílatele. Obsah tohoto emailu i s přílohami a jeho kopie > vymažte ze svého systému. > Nejste-li zamýšleným adresátem tohoto emailu, nejste oprávněni tento email > jakkoliv užívat, rozšiřovat, kopírovat či zveřejňovat. > Odesílatel e-mailu neodpovídá za eventuální škodu způsobenou modifikacemi > či zpožděním přenosu e-mailu. > > V případě, že je tento e-mail součástí obchodního jednání: > - vyhrazuje si odesílatel právo ukončit kdykoliv jednání o uzavření > smlouvy, a to z jakéhokoliv důvodu i bez uvedení důvodu. > - a obsahuje-li nabídku, je adresát oprávněn nabídku bezodkladně přijmout; > Odesílatel tohoto e-mailu (nabídky) vylučuje přijetí nabídky ze strany > příjemce s dodatkem či odchylkou. > - trvá odesílatel na tom, že příslušná smlouva je uzavřena teprve > výslovným dosažením shody na všech jejích náležitostech. > - odesílatel tohoto emailu informuje, že není oprávněn uzavírat za > společnost žádné smlouvy s výjimkou případů, kdy k tomu byl písemně zmocněn > nebo písemně pověřen a takové pověření nebo plná moc byly adresátovi tohoto > emailu případně osobě, kterou adresát zastupuje, předloženy nebo jejich > existence je adresátovi či osobě jím zastoupené známá. > > This e-mail and any documents attached to it may be confidential and are > intended only for its intended recipients. > If you received this e-mail by mistake, please immediately inform its > sender. Delete the contents of this e-mail with all attachments and its > copies from your system. > If you are not the intended recipient of this e-mail, you are not > authorized to use, disseminate, copy or disclose this e-mail in any manner. > The sender of this e-mail shall not be liable for any possible damage > caused by modifications of the e-mail or by delay with transfer of the > email. > > In case that this e-mail forms part of business dealings: > - the sender reserves the right to end negotiations about entering into a > contract in any time, for any reason, and without stating any reasoning. > - if the e-mail contains an offer, the recipient is entitled to > immediately accept such offer; The sender of this e-mail (offer) excludes > any acceptance of the offer on the part of the recipient containing any > amendment or variation. > - the sender insists on that the respective contract is concluded only > upon an express mutual agreement on all its aspects. > - the sender of this e-mail informs that he/she is not authorized to enter > into any contracts on behalf of the company except for cases in which > he/she is expressly authorized to do so in writing, and such authorization > or power of attorney is submitted to the recipient or the person > represented by the recipient, or the existence of such authorization is > known to the recipient of the person represented by the recipient. > -- Thomas E Adams, III 2330 Jack Warner PKWY, #334 Tuscaloosa, AL 35401 1 (513) 739-9512 (cell) [[alternative HTML version deleted]] ______________________________________________ R-help@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.
