similar to: import data into R

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

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

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

  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 need to delete a message that a send to r -help ?? Can you please tell me how? Thank you [[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]]

Dear all, I am new R user and I am sure that this question has been asked quite often and I have also googled it and read about it! I understood that in order to read excel sheet into R you need to open it and saved it as csv or text, is this true? or you can use read.delim2 and read.csv2 to do this without the following error > dat <- read.csv2(file="C:\\Dokumente und

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

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

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

Hi, is there are reason for not supporting NULL or "NULL" values for argument colClasses in read.table(), much like you can use NULL values for argument 'what' in scan()? This would help quite a bit when reading large data files where only a few columns are of interest. I've modfied read.table() to so it calls scan(what=...) also with NULLs for the fields to be skipped.

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