[R] Tr : create a table in the console!!
Steve Lianoglou
mailinglist.honeypot at gmail.com
Tue Aug 18 17:32:35 CEST 2009
Hi,
On Aug 18, 2009, at 10:52 AM, Inchallah Yarab wrote:
> ----- Message transféré ----
> De : Inchallah Yarab <inchallahyarab at yahoo.fr>
> À : r-help at r-project.org
> Envoyé le : Mardi, 18 Août 2009, 16h26mn 20s
> Objet : create a table in the console!!
>
>
> HI
>
> I want to do a table with R (in the console)
>
> GWP_Max NumberOfPolicies
> No_GWPMax 8
> [0-1000] 4
> [1000-3000] 3
> [> 3000] 5
>
> i begin by calculate the number of policies in each class :
>
> Data1 <- read.csv2("c:/Total1.csv", sep=",")
>> Data2 <- read.csv2("c:/GWPMax1.csv",sep=",")[1:20,1:2]
>> M <- merge(Data1,Data2, by.x = "Policy.Number",by.y =
>> "Policy.Number",all.x = TRUE,all.y = TRUE )
>> (No_GWPMax<-nrow(M[M[,25]=="NA",]))
> [1] 8
>> M2<- merge(Data1,Data2, by.x = "Policy.Number",by.y =
>> "Policy.Number")
>> M2$GWP_Max <- as.numeric(as.character(M2$GWP_Max ))
>> class1 <- M2[M2[,25]>0 & M2[,25]<1000,]
>> (NbpolicyClass1 <- nrow(class1))
> [1] 5
>> class2 <- M2[M2[,25]>1000 & M2[,25]<3000,]
>> (NbpolicyClass2 <- nrow(class2))
> [1] 3
>> class3 <- M2[M2[,25]>3000,]
>> (NbpolicyClass3 <- nrow(class3))
> [1] 4
>
> can you help me ?
I don't understand what you want to do.
From the code you've pasted, you already have extracted the numbers
you wanted, so what do you mean when you say "I want to do a table"
with them? Do you just want to put them in a data.frame, or something?
-steve
--
Steve Lianoglou
Graduate Student: Computational Systems Biology
| Memorial Sloan-Kettering Cancer Center
| Weill Medical College of Cornell University
Contact Info: http://cbio.mskcc.org/~lianos/contact
More information about the R-help
mailing list