[R] import contingency table

[Milan Bouchet-Valat]

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