Banner using R

 Classic List Threaded
2 messages
Reply | Threaded
Open this post in threaded view
|

Banner using R

 Hi, I am a bit rusty with R programming and I would appreciate some assistance with the following. I have a dataset like: Data <- data.frame(v1 = c('A', 'B' ,'B' ,'A', 'B'), v2 =c('A', 'B', 'A', 'A', 'B'), v3 = c('A', 'A', 'A', 'A', 'A’)) How can I get a banner of the sort? Count v1 v2 v3 TOT A 2 3 5 10 B 3 2 0 5 I have tried with xtabs and expss but I do not seem to get what I need... Thanks, Luca ______________________________________________ [hidden email] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code. Mr. Luca Meyer www.lucameyer.com
Reply | Threaded
Open this post in threaded view
|

Re: Banner using R

 You need to read the data without converting to factors: > Data <- data.frame(v1 = c('A', 'B' ,'B' ,'A', 'B'), v2 =c('A', 'B', 'A', 'A', 'B'), +      v3 = c('A', 'A', 'A', 'A', 'A'), stringsAsFactors=FALSE) Then you need to stack it: > Data.stack <- stack(Data) > str(Data.stack) 'data.frame':   15 obs. of  2 variables:  \$ values: chr  "A" "B" "B" "A" ...  \$ ind   : Factor w/ 3 levels "v1","v2","v3": 1 1 1 1 1 2 2 2 2 2 ... Then table (or xtabs) will work: > Data.tbl <- table(Data.stack) > addmargins(Data.tbl, 2)       ind values v1 v2 v3 Sum      A  2  3  5  10      B  3  2  0   5 ---------------------------------------- David L Carlson Department of Anthropology Texas A&M University College Station, TX 77843-4352 -----Original Message----- From: R-help <[hidden email]> On Behalf Of Luca Meyer Sent: Tuesday, January 15, 2019 12:26 PM To: [hidden email] Subject: [R] Banner using R Hi, I am a bit rusty with R programming and I would appreciate some assistance with the following. I have a dataset like: Data <- data.frame(v1 = c('A', 'B' ,'B' ,'A', 'B'), v2 =c('A', 'B', 'A', 'A', 'B'), v3 = c('A', 'A', 'A', 'A', 'A’)) How can I get a banner of the sort? Count v1 v2 v3 TOT A 2 3 5 10 B 3 2 0 5 I have tried with xtabs and expss but I do not seem to get what I need... Thanks, Luca ______________________________________________ [hidden email] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code. ______________________________________________ [hidden email] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code.