similar to: how use cat() function?

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 =

----- Message transféré ---- De : Inchallah Yarab <inchallahyarab@yahoo.fr> À : r-help@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 <-

i have written this in R, > data1 <- read.csv2("c:/Total1.csv",sep=",") > data2 <- read.csv2("c:/GWPMax1.csv",sep=",") > M <- merge(data1, data2, by.x = "Policy.Number", by.y = "Policy.Number") > nrow(data1) [1] 20 > nrow(M) [1] 12 > NbOfPolicyWithoutGWPMax <- nrow(data1)-nrow(M) >

i have a matrice M and i want to extract only rows where GWP_Max is positif and smaller than 1000 but it is given me this:!!!??? > M    Policy.Number   GWP_Max 1        4001023       500 2        4001025       700 3        4001028       600 4        4001062    2335.1 5        6100001      2000 6     1060000006      1400 7     1060000009     77.19 8     1060000071  18898.88 9     1060000073

Hi, Actually, i use the function merge like this: (Data1 <- Data1[1:7,1:3])   Policy.Number AXA.Entity Country 1    1060000077        BNL     BNL 2       4001023         CH     BNL 3    1060000006         UK     BNL 4       4001025         CH     BNL 5      6.00E+13        USA     BNL 6       6100001         UK     BNL 7       4001028        USA     BNL > Data2 <-