[R] import contingency table

[Rui Barradas]

Ok, try the following.


df2table <- function(x, Var1="Var1", Var2="Var2"){
     tbl <- as.matrix(x)
     dnames <- list(rownames(x), colnames(x))
     names(dnames) <- c(Var1, Var2)
     attr(tbl, "dimnames") <- dnames
     attr(tbl, "class") <- "table"
     tbl
}

df2table(xls_contingency)  # using default names

Rui Barradas


Em 28-05-2012 15:00, Milan Bouchet-Valat escreveu:
> Le lundi 28 mai 2012 à 15:19 +0200, sylvain willart a écrit :
>> no,
>> the problem is that the lines in my file do not correspond to
>> individuals, but are variables, just like are the columns,
>> my file is already a contingency table, with each cell being a frequency:
>>
>> here is a sample of it:
>> *******************************************************
>>     ,AUC,Alin,BLG,BrDep,CRF,CMkt,CAS,Casto,Confo,ElDep,Geant,Halle,KIA,LMrl,Match,MET,MNP,SM,
>> Strasbg,4,0,0,2,3,0,0,6,2,1,2,1,0,2,3,2,3,6
>> Paris,0,0,0,0,10,1,5,2,4,0,5,1,0,0,0,3,7,7
>> Brest,3,0,0,2,8,0,5,9,4,0,5,0,2,0,0,0,0,0
>> Lyon,0,0,0,1,4,2,8,2,3,0,5,1,0,0,0,0,4,5
>> Nice,3,0,0,0,3,2,5,1,2,0,2,0,0,0,0,2,2,0
>> Limg,3,0,0,1,4,2,3,0,0,0,3,0,0,0,0,1,0,4
>> Toulse,0,0,0,1,5,4,3,2,2,0,5,0,0,0,0,2,1,5
>> Nancy,0,0,0,2,3,1,1,8,2,0,2,0,1,0,2,3,2,4
>> Lille,0,0,0,0,6,8,0,0,2,2,3,1,0,1,5,1,2,6
>> Mtplier,0,0,0,0,7,3,4,1,0,1,4,0,0,0,0,1,6,3
>> Aix,0,4,0,0,9,2,5,1,0,0,5,0,0,0,0,1,7,5
>> Senart,0,0,0,1,10,3,5,0,5,0,6,0,0,0,0,0,3,3
>> Grenbl,0,0,0,0,3,2,5,3,1,0,5,0,0,0,0,0,0,4
>> Angers,0,0,0,2,8,0,4,0,4,0,4,0,2,0,0,0,3,3
>> Brdx,3,0,0,2,4,3,3,0,1,0,5,0,2,0,0,1,3,4
>> Dijon,0,0,0,1,8,2,5,3,4,0,5,0,0,0,0,2,1,0
>> Rouen,3,0,0,1,2,0,2,0,3,1,2,1,2,0,0,0,0,6
>> **********************************************************
>>
>> I know how to read it into a df or a matrix,
>> if it was a df or matrix, i could turn it into a table,
>> but this is already a contingency table
> If it's already a matrix, just call as.table() on it, and you'll get a
> table object.
>
>> for example, the first number "4", is the number of people being in
>> city "Strasbg" (first row) and working at "AUC" (first column) (this
>> is Auchan actually)
>>
>> I do not have the original file where each row would be an individual,
>> I just have that flat file, with variables on the rows and variables
>> on the colums, and frequencies in each cell,
>> And I wonder how to read it in R telling him this is a
>> frequency/contingency table ....
>>
>> I can't believe there are no way of getting aroud it (or maybe the sun
>> stroke to heavy on my head) ....
> Please call dput() on the data as you have imported it, so that we can
> precisely discuss the problem.
>
>
> Regards
>
> ______________________________________________
> R-help at 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.