Displaying 20 results from an estimated 2000 matches similar to: "how import Excel data into R?"
2011 May 24
1
document
Hello evryone,
Thank you for helping me to choose a CRAN MIRROR. When Icome to choose a
mirror an error message comes:
>Message d'avis :
In open.connection(con, "r") :
connexion ? 'cran.r-project.org' impossible sur le port 80.
Again, I managed to download th package ttda.zip but an error message during
the installation comes to me:
>Erreur dans gzfile(file,
2009 Aug 17
4
number in R
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
2009 Aug 24
4
table function
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
2009 Jul 31
3
what is the meaning of this error message?
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]]
2007 Apr 29
2
impossible to open SPSS file
Hi,
I try to import a SPSS file with foreign but don't succeed. I looked
into the help pages but find no answer. The file has been produced with
SPSS 15 but I got the same error with a file in SPSS portable format.
mydata<-read.spss("C:\Rdata\ESS1_ICT.SAV")
Erreur dans read.spss("C:RdataESS1_ICT.SAV") :
impossible d'ouvrir le fichier
I guess the error is
2007 Feb 08
1
Impossible to get jpeg or png output
Hi,
When I want to output a png file, I have the following error message :
Error dans X11(paste("jpeg::", quality, ":", filename, sep = ""), width, :
inpossible de d?marrer le p?riph?rique JPEG
De plus : Warning message:
impossible d'ouvrir le fichier JPEG 'Test.jpeg'
or in english
Error in X11(paste("jpeg::", quality, ":",
2009 Aug 06
2
problem with r import data
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
2009 Aug 10
3
how use cat() function?
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 <-
2009 Jul 31
3
how can i delete a message in R-help?
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]]
2009 Aug 05
3
import data into R
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
2009 Aug 18
1
number 6 e+13
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
2009 Aug 18
1
Tr : create a table in the console!!
----- 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 <-
2009 Aug 06
2
delete lines
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]]
2009 Aug 21
2
multiple linear regression
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]]
2009 Aug 20
2
what is the meaning of this error
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]]
2009 Aug 10
2
(sans objet)
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)
>
2006 May 06
5
R and Java
Hello
I m tryng to execute the code below and I have a problem with the R-Java connection.:
import org.omegahat.R.Java.*;
public class REvalSample {
public static void main(String [] args) {
String [] rargs = {"--slave", "--vanilla"};
System.out.println("Sample program to call R engine from Java");
ROmegahatInterpreter interp = new
2009 Aug 06
1
calasification table under conditions
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]]
2009 Aug 06
2
opration / dates in R
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]]
2009 Aug 11
1
error in names
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]]