On Sep 4, 2011, at 8:35 PM, R. Michael Weylandt wrote:
Kang Tu is right and you will certainly need to learn the techniques
being
suggesting to do more advanced data analysis, but it sounds like for
your
immediate problem the following might work:
# Suppose df is your data frame
This takes a sub-data-frame consisting only of columns 4 through 27
and does
rowSums on them.
And to take this a bit further you could record those results in the
same dataframe with:
df$dailySums <- rowSums(df[,4:27])
And print them out with:
df[ , c("Year", "Month", "day", dailySums") ]
Or assign them to a daySummary
dayRainSummary <- df[ , c("Year", "Month", "day", dailySims") ]
dayRainSummary$date <- with(dayRainSummary, as.POSIXct(paste(Year,
Month, day, sep="-"),
origin="1970-01-01")
)
with(dayRainSummary, plot(date, dailySums) )
save(dayRainSummary, file="daySummary.rda")
Hope this helps,
Michael Weylandt
On Sun, Sep 4, 2011 at 7:16 PM, Kang Tu <kang.tu.r...@gmail.com>
wrote:
Would you mind show us a simple example of your data? It is hard to
understand your request directly from your text.
If you just want to combine the data, you can try cbind() function
directly, or you can use subset() function to get a subset of your
data.frame. If you want to selectively aggregate some statistics
you can
try aggregate() function. If you want a more complex aggregation, you
may want to try ddply() in 'plyr' package.
On Sun, 2011-09-04 at 15:25 -0700, joonsum wrote:
First time using R and have so many basic questions.
The problem that I have confronted is combining rows. I have a
data frame
that contains daily rain falls from 60 to 80. There are 27 columns
which
are
Year,month, day, and record in hours.
I am trying to combine the 4th column to the 27th to get daily
rain fall
data.
rowSums() works in the case of merging all rows but in my case, I
need to
be
selective. How should I start?
--
View this message in context:
http://r.789695.n4.nabble.com/combining-rows-tp3790068p3790068.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
______________________________________________
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.
David Winsemius, MD
West Hartford, CT
______________________________________________
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.
