Dear R-users,
I have a dataset as like below, and I want to subtotal the values of rice,wheat
and maize by year for each fid.
fid year rice wheat maize
------------------------------------------------
1 1995 5 NA NA
1 1995 NA 3 NA
1 1995 NA NA 2
1 1996 4 NA NA
1 1996 NA 2 NA
1 1996 NA NA 6
2 1995 3 NA NA
2 1995 NA 8 NA
2 1995 NA NA 4
2 1996 7 NA NA
2 1996 NA 6 NA
2 1996 NA NA
7-----------------------------------------------
And, my output should look like below:
fid year rice wheat maize
1 1995 5 3 2
1 1996 4 2 6
2 1995 3 8 4
2 1996 7 6 7I am looking for some ideas or r-codes
on resolving my problem.
I appreciate your kind help,
Thanks a lot,
Sincerely yours,
Shyam
Nepal
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
