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 <r-help-bounces at r-project.org> On Behalf Of Luca Meyer
Sent: Tuesday, January 15, 2019 12:26 PM
To: r-help at r-project.org
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
______________________________________________
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.