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.b...@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]] ______________________________________________ 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.
