It is also possible to construct the r call in the GUI. See:


http://www.deducer.org/pmwiki/index.php?n=Main.MergeData

Ian


Sent from my iPhone

On Dec 28, 2012, at 4:41 AM, Djordje Bajic <je.li.bre@gmail.com> wrote:

> see ?merge, 
> 
> for your dataframes, the following should work:
> 
> merge(bat_activity, weather, by=c(date, time), all=T) 
> 
> 
> 2012/12/28 Neotropical bat risk assessments <neotropical.bats@gmail.com>
>> Hi all,
>> 
>> I am trying to merge several data sets and end up with a long data
>> format by date & time so I can run correlations and plots.  I am using
>> Deducer as an R GUI but can just use the R console if easier.
>> 
>> The data sets are weather with wind speed, relative humidity and
>> temperatures by date and minute and bat activity with date, time, label,
>> and an activity index number.  The bat activity is only during the
>> nocturnal time frames while the weather data was recorded for 24 hours.
>> Therefore a lot of weather data with no related activity for bats.
>> 
>> I have failed so far to achieve what I need and tried plyr and reshape2.
>> There are many Null data rows with no data or 0 (zero) for wind speed..
>> What other tools steps would be more appropriate short of manually in
>> Excel cutting and pasting for a day or more?
>> 
>> 
>> Data formats are:
>> bat activity
>> Date    Time    Label   Number
>> 6/3/2011        10:01   Tadbra  2
>> 6/3/2011        10:02   Tadbra  4
>> 6/3/2011        10:08   Tadbra  1
>> 6/3/2011        10:13   Tadbra  2
>> 6/3/2011        10:49   Tadbra  2
>> 6/3/2011        10:51   Tadbra  2
>> 6/3/2011        10:52   Tadbra  4
>> 
>> 
>> Weather:
>> 
>> date    time    Temp_I  Temp_E  RH      mph_a   mph_x
>> 6/3/2011        0:00    15      15.7    30.4    4.4     15.5
>> 6/3/2011        0:30    15      15.2    31.6    5.7     11.2
>> 6/3/2011        1:00    15      15.1    31.3    10.3    17.5
>> 6/3/2011        1:30    14      13.6    44.5    4.7     12.1
>> 6/3/2011        2:00    12.5    13.2    37.9    2.1     6.5
>> 6/3/2011        2:30    12.5    13.5    35.3    6.3     10.1
>> 6/3/2011        3:00    12      12.1    37.7    3       7.4
>> 6/3/2011        3:30    11.5    11.5    38.7    3.4     6
>> 6/3/2011        4:00    10      9.9     52.7    1.4     4.2
>> 6/3/2011        4:30    9.5     9.1     43.2    1.3     3.8
>> 6/3/2011        5:00    8       8.7     59.2    1.2     3.1
>> 6/3/2011        5:30    7       8       62.5    1.1     4.2
>> 6/3/2011        6:00    6       7.8     47.8    0.5     2.2
>> 6/3/2011        6:30    7.5     11.5    37.5    1.7     3.8
>> 6/3/2011        7:00    10.5    14      33.1    0.6     2.2
>> 6/3/2011        7:30    14      17.3    32.1    1.6     3.6
>> 6/3/2011        8:00    17.5    20.3    23.9    0.4     2
>> 6/3/2011        8:30    21.5    22.8    20.7    0.4     1.8
>> 6/3/2011        9:00    24.5    24.9    14.1    0.3     2.2
>> 6/3/2011        9:30    26      26.9    20.3    1.7     5.6
>> 6/3/2011        10:00   27.5    27.4    20.7    2.5     6.5
>> 6/3/2011        10:30   28.5    29.8    10      1.6     4.2
>> 6/3/2011        11:00   29.5    29.4    9.8     1.8     4
>> 6/3/2011        11:30   30      29.9    9.2     2.7     7.8
>> 
>> 
>> Tnx for any suggestions,
>> 
>> Bruce
>> 
>>         [[alternative HTML version deleted]]
>> 
>> ______________________________________________
>> R-help@r-project.org mailing list
>> 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]]


