[R] Attempting to plot two different time series together

[Jeff Newmiller]

Please keep the list in the conversation. 

Yes stacking was my intention, since the graphical presentation does not need the same time basis.  However, your other analyses may indeed require that you interpolate or decimate to obtain aligned data records. 
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

On November 6, 2015 8:01:55 AM PST, Ezra Boyd <ezgis76 at gmail.com> wrote:
>Jeff,
>
>Thank you very much for responding.  I actually read and worked through
>most of ggplot2 and ggplot2 Essentials for this task, but was starting
>to
>think they were not what I needed.
>
>The problem that I cannot get over is that my two timeseries datasets
>are
>based on different samplings, 30-mins for the tidal and 6-mins for the
>meteorological:
>
>Tidal Data
>TS Stage_ft 1/9/2001 16:00 -0.41 1/9/2001 16:30 -0.43 1/9/2001 17:00
>-0.44 1/9/2001
>17:30 -0.43 1/9/2001 18:00 -0.4
>Meteorological
>DATETIME  WINDSPEED           DIR 8/15/2012 0:00 5.05 228 8/15/2012
>0:06
>4.08 225 8/15/2012 0:12 4.08 216 8/15/2012 0:18 4.47 222 8/15/2012 0:24
>5.05
>219 8/15/2012 0:30 3.5 226
>
>Do I understand your suggestion correctly that I should tidy up the
>dataset
>by stacking them in the dataframe, and then facet them using a type
>column?
>TS Stage_ft  WINDSPEED  DIR Type 1/9/2001 16:00 -0.41    T 1/9/2001
>16:30
>-0.43    T 1/9/2001 17:00 -0.44    T 1/9/2001 17:30 -0.43    T 1/9/2001
>18:00 -0.4    T 8/15/2012 0:00 5.05 228    M 8/15/2012 0:06 4.08 225
> M 8/15/2012
>0:12 4.08 216    M 8/15/2012 0:18 4.47 222    M 8/15/2012 0:24 5.05
>219    M 8/15/2012
>0:30 3.5 226    M
>Or, do I need to look into timeseries methods for combining datasets
>with
>different samplings?
>
>Thanks again and I appreciate you taking the time to share your
>knowledge.
>
>Regards,
>
>Ezra
>
>
>
>
>
>
>
>
>On Thu, Nov 5, 2015 at 7:25 PM, Jeff Newmiller
><jdnewmil at dcn.davis.ca.us>
>wrote:
>
>> Seems like you would benefit from reading about long and wide data...
>> perhaps  [1].
>>
>> If I am understanding what you want,  ggplot facetting should be able
>to
>> do what you want.  You first have to put the data in long form (e.g.
>> variable, timestamp, value) before you give it to ggplot.
>>
>> If you want more specific help then you should provide a small sample
>data
>> set as one or more  R dputs as the Posting Guide recommends (see
>footer,
>> and  [2]).
>>
>> [1]
>https://cran.r-project.org/web/packages/tidyr/vignettes/tidy-data.html
>>
>> [2]
>>
>http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example
>>
>---------------------------------------------------------------------------
>> Jeff Newmiller                        The     .....       .....  Go
>Live...
>> DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live
>> Go...
>>                                       Live:   OO#.. Dead: OO#.. 
>Playing
>> Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
>> /Software/Embedded Controllers)               .OO#.       .OO#. 
>rocks...1k
>>
>---------------------------------------------------------------------------
>> Sent from my phone. Please excuse my brevity.
>>
>> On November 5, 2015 7:00:18 AM PST, Ezra Boyd <ezgis76 at gmail.com>
>wrote:
>> >Hello,
>> >
>> >I am trying to create a plot (I guess two plots) using two different
>> >time
>> >series datasets, but I'm not sure of the best approach.  The data is
>> >from a
>> >tidal surge due to a hurricane and I would like to show the
>> >relationship
>> >between stage and windspeed/direction.
>> >
>> >One dataset is the tidal stage and it is sampled in 30 minutes
>> >intervals.
>> >The other dataset is windspeed and direction and it is sampled every
>6
>> >minutes.  I would like to display the tidal hydrograph and then also
>> >show
>> >windspeed and direction as a banner above it.  They would be two
>> >separate
>> >plots, but with identical x-axis (as opposed to one plot that has
>both
>> >tide
>> >& wind.)
>> >
>> >Should I combine the two time series into one dataframe (with lots
>of
>> >NAs)
>> >so that I can create the plots together, for example using pairs or
>> >ggpairs? Or should I keep them separate, make the individual plots,
>and
>> >then work on the layout in graphic design software? I would prefer
>the
>> >former, but I just can't figure out how to make that work out.
>> >
>> >Also, is it possible to depict wind direction (which is given in
>degree
>> >clockwise from due north) with an arrow?
>> >
>> >Thank you very much,
>> >
>> >Ezra
>>
>>