similar to: Tr : create a table in the console!!

i  want to print in the console and to have an excel file like this no_GWP                NbOfPolicyClass1[0-1000]     NbOfPolicyClass2[1000-3000]        NbOfPolicyClass3[> 3000] No_GWPMax=8    NbpolicyClass1=5                   NbpolicyClass2=4                            NbpolicyClass3 =3              i have do it like this:!!! data1 <-

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 =

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 <-

Hi, i export data from an csv file like this :  Data <- read.csv2("c:/Art.csv",sep=",") # import data into R > Data <- Data [1:5,1:5]# extracting the first 5 rows and columns > Data   Policy.Number AXA.Entity Country LoB ccy.data 1         6e+13        BNL     BNL   P      EUR 2         6e+13        USA     BNL   P      EUR 3         6e+13         UK     BNL  

hi, i want to use the function table to build a table not of frequence (number of time the vareable is repeated in a list or a data frame!!) but in function of classes I don t find a clear explnation in  examples of  ?table !!! example x      y        z 1    0       100 5    1       1500 6    1       1200 2    2       500 1    1       3500 5     2     2000 8     5     4500 i want to do a

Hi, I need your help :: what i the meaning of this error message"Missing value where true / false needed??" Thank you [[alternative HTML version deleted]]

  Hi, i export data from an csv file like this :  Data <- read.csv2("c:/Art.csv",sep=",") # import data into R > Data <- Data [1:5,1:5]# extracting the first 5 rows and columns > Data   Policy.Number AXA.Entity Country LoB ccy.data 1         6e+13        BNL     BNL   P      EUR 2         6e+13        USA     BNL   P      EUR 3         6e+13         UK     BNL  

Good moorning, yesterday, i asked for how we can import data into R i found that it is necessary to make the file in csv format then use L<- read.csv2("path of file") now i see that the dimension of my table importing into R is 1 colonne (i have realy 20) and (655555) the number of all my lines in the excel file (i want to have only the 2600 lines in my table) Also, when i say to do

Hi i need to delete a message that a send to r -help ?? Can you please tell me how? Thank you [[alternative HTML version deleted]]

Hi I want to import Excel data into R I have used this code data<-read.table("C:\Total_Art_Policies.xls",header=TRUE,sep=";") i have an error msg: Erreur dans file(file, "r") : impossible d'ouvrir la connexion De plus : Warning message: In file(file, "r") : impossible d'ouvrir le fichier 'C:\Total_Art_Policies.xls' : No such file or

Thank you Gabor Grothendieck for your answer !! i have charge the pachage but now i have this massage  read.table("c:/TOTAL.xls",h=T) [1] ÐÏ.à.. <0 rows> (or 0-length row.names) Warning messages: 1: In read.table("c:/TOTAL.xls", h = T) :   incomplete final line found by readTableHeader on 'c:/TOTAL.xls' 2: In if (!header) rlabp <- FALSE :   the condition has

Hi , I need to write a function to delete a row if the value of one element of the row is negatif!!! I have a big file of data and i will check every lines!!! Any ideas Thank you !! [[alternative HTML version deleted]]

Good morning, I want to make a linear regression of a variable fuction of  two variables y = a1 x1 + a2 x2 + c I found the function lm (y ~ x)  but it used  for a simple linear regression, but for  multiple regression i do not know which function do this!!  Can you help me please!!  Thank you in advance [[alternative HTML version deleted]]

Error in Math.factor(c(2L, 1L, 1L, 1L, 1L, 3L, 1L, 1L, 1L, 1L, 1L, 1L,  :   log not meaningful for factors In addition:Warning messages: 1: In Ops.factor(LRUpBound, LRLowBound) : * not meaningful for factors 2: In Ops.factor(TransitCoefStdDev, TransitCoefMean) :   / not meaningful for factors [[alternative HTML version deleted]]

hi, i have a file with 49000 lines i want to do a classification in two tables suppose data <- read.csv2("c:/total.csv", sep=",") if the second colonne contains ( A,B,C,D)------------> tab1 if the second colonne contains ( E,F,G,H)------------> tab2 How can do this ? Thank you for your help [[alternative HTML version deleted]]

Hi, how can i use operation + , - , / with veriable format DATES? for example i have two variable a <- 18/08/2008 and b <- 18/09/2010 and i want to calculate a-b ?? thank you? [[alternative HTML version deleted]]

Hi, what is meaning this errors !!! Error in names(o.pr)[p.ok] <- names(qs) :   incompatible types (from NULL to character) in subassignment type fix In addition: Warning message: In Ops.factor(from, (0:(length.out - 1)) * by) :   + not meaningful for factors thank you very much [[alternative HTML version deleted]]

HI, i have this matrix and i want to extract  a section of the matrix which present the first and second value of optim position:    OptimYear            LRPhase                                  PriorLRPosition                 OptimPosition            LRPosition   5      2009                      1                                         1.15641679414676       0.33037984561357            1 6