On Aug 9, 2011, at 8:36 AM, RobinLovelace wrote:
Hello R users,
My problem is that the data I've got is in the minimum number of
columns
with each ward (geographic area) appearing multiple times. The first
30
terms look like this
HHum02
CASW Btype Yr CO2Group NumVeh
170597 00CCFA CARS 2002 C 2
170598 00CCFA CARS 2002 D 2
170599 00CCFA CARS 2002 E 22
170600 00CCFA CARS 2002 F 32
170601 00CCFA CARS 2002 G 32
170602 00CCFA CARS 2002 H 12
170603 00CCFA CARS 2002 I 12
170604 00CCFA CARS 2002 J 9
170605 00CCFA CARS 2002 K(L) 8
170606 00CCFA CARS 2002 K(M) 2
170607 00CCFA CARS 2002 K 9
170608 00CCFA AG 2002 non-cars 2
170609 00CCFA BS 2002 non-cars 2
170610 00CCFA GHEAVY 2002 non-cars 9
170611 00CCFA GLIGHT 2002 non-cars 23
170612 00CCFA MOTOS 2002 non-cars 24
170613 00CCFA OTHERS 2002 non-cars 6
170787 00CCFB CARS 2002 D 1
170788 00CCFB CARS 2002 E 11
170789 00CCFB CARS 2002 F 12
170790 00CCFB CARS 2002 G 20
170791 00CCFB CARS 2002 H 17
170792 00CCFB CARS 2002 I 4
170793 00CCFB CARS 2002 J 10
170794 00CCFB CARS 2002 K(L) 2
170795 00CCFB CARS 2002 K(M) 1
170796 00CCFB CARS 2002 K 5
170797 00CCFB GHEAVY 2002 non-cars 6
170798 00CCFB GLIGHT 2002 non-cars 4
170799 00CCFB MOTOS 2002 non-cars 25
But what I need is for there to be only 1 row for each ward (e.g.
00CCFA).
This would mean adding extra columns and would look like this:
> xtabs( NumVeh ~ CASW+CO2Group, data= HHum02)
CO2Group
CASW C D E F G H I J K K(L) K(M) non-cars
00CCFA 2 2 22 32 32 12 12 9 9 8 2 66
00CCFB 0 1 11 12 20 17 4 10 5 2 1 35
>
"CASW" " C" " D" " E" " F" " G" " H" " I" " J" " K(L)" " K(M)"
" K"
"non-cars"
"00CCFA" 2 2 22 32 32 12 12 9 8
2 9 66
"01CCFB" 0 1 11 12 20 17 4 10 2
1 5 35
I know R has the capability to do this, but people in my department
only
know how to do this using STATA. I've explored various options.
unstack()
seems to be the most appropriate but it's just not working using the
default
formula:
http://r.789695.n4.nabble.com/file/n3729817/Screenshot-*getting-started.txt_%28%7E-1Projects-OSS_general%29_-_gedit.png
Look forward to learning,
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.
