similar to: Help with read.csv2

Hi all, I use "write.csv" and "write.table" to write a data frame in a file like following: write.csv2(allRandomTestCase_XDroped, "allRandomTestCase.csv") But in the created file "allRandomTestCase.csv" an additional column with consecutive numbers is automatically added to the column of the data frame "allRandomTestCase_XDroped". That is why my

hello, Does anybody know how to aggregate a lag series ? when I try to use aggregate I get the following message > try<-ts(1:100,start=c(1985,1),freq=12) > aggregate(try,4,mean,na.rm=T) Qtr1 Qtr2 Qtr3 Qtr4 1985 2 5 8 11 1986 14 17 20 23 1987 26 29 32 35 1988 38 41 44 47 1989 50 53 56 59 1990 62 65 68 71 1991 74 77 80 83 1992

Hello, I apologize for this question that may has been asked a lot of times but I could not go through it. I create a multivariate time series containing NA values. I want to compute a linear regression and obtain a time serie for both residuals and fitted values. I have tried the trick ts.intersect, without success. Could you help me out of this? #### Example: y<-ts(1:10+rnorm(10))

Dear R-List, I'm trying to read an UTF-8-encoded text file which works fine under ##################################################################### ### CONFIG 1 > sessionInfo() R version 2.12.1 (2010-12-16) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=German_Germany.1252 LC_CTYPE=German_Germany.1252 [3] LC_MONETARY=German_Germany.1252 LC_NUMERIC=C

Dear all, I have a huge problem after downloading and exporting data from Reuters3000 XTra: I downloaded many many monthly, quarterly and yearly data. I do not know why, but after saving, I have mixed-data sets, i.e. files which can be imported as “read.csv” and others that are in the format of “read.csv2”. Sure I could change them, but normally it should be possible to mix them… For

hello, Suppose you a monthly series you want to aggregate at a quaterly frequency with the start and the end of your series in the middle of the quarter. For example 2001M2 2001M3 2001M4 2001M5 2001M6 2001M7 12 13 12 14 16 15 how can you get something like : 2001Q1 2001Q2 200Q3 NA 14 NA or 2001Q1 2001Q2 200Q3 12.5 14 15 Thanks in advance

hello, Suppose in Rnw file, I compute a numeric of name x containing the value 1. In my tex file, I want to write Let x= "the real value of x" so that I can see in my dvi file : Let x = 1, with 1, the actual value of x written in a math environnement for example. Thanks, Matthieu

Hi, I have a data file with columns separated by ";" I read this file without any problem using read.csv2( ) but I had problems trying to read it with read.table( ... sep=";"). So it is not a problem for me, but I wonder if there is a bug here. drt <- read.csv2("t.txt", header=TRUE) # ok dcs <- read.table("t.txt", header=TRUE,

Hello, I've imported a csv, semi-colon spearated file with read.csv2, containing one column of rownames and one column of floating point numbers. When I look at the column of data with framename$columnname, I get the values of the column plus level values. Are these level values created automatically ? The problem is when I try to calcluate the correlation coefficient between this set of data

Bruno Cornec via Syslinux said on Sun, Oct 25, 2015 at 12:39:53PM +0100: >I'm indeed trying to have everything I need on the boot part of the >ISO9660 image (kernel and an initrd which is normally built by >MondoRescue which then mounts the ISO9660 FS to have access to >additional content once booted). For now I do not seem to get to boot the >kernel. > >My machines are HP

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 all, I have a problem to read csv file with comma as decimal. The numbers were readed as strings. I used the following string in R, but I do not understand why it does not work. tab <- read.csv2("Specimen_RawData_1.csv", header = TRUE, sep = ";", dec = ",", nrows = -1) In addition, I copy/past into the post the link to the csv file generated by my instrument.

R2.13.2, W7x64 Dear list, Excuse my ignorance, but I have gone through the R help (?parse, ?eval, etc.) and still really don't know how to do the following. I have the general following structure that I would like to automate [edited to make it shorter]: >>> city1997 <- dataCleaning(read.csv2("C:\\city\\year1997.txt")) city1997 <- wasteCalculations(city1997, year

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

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 have the next procedure: t1<-data.frame(table(substr(names(subset(lasker[[1]], lasker[[1]] >= 4)), 1, 7))) t1[1:5,] Var1 Freq 1 1988-02 3 2 1988-03 1 3 1988-04 1 4 1988-05 2 5 1988-06 3 How to make a new list?, dataframe? having 189 elements in the 'lasker' list: > str(lasker[[1]]) 'table' int [, 1:1274] 1 1 3 2 1 5 4 1 1 4 ... -

Hello, Does anyone know how to write the files created by the call of "texi2dvi" in another directory ? Thanks, Matthieu

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, Having a dataframe 'l1' (dput output is below): >dim(l1) 1274 2 >l1[1:12,] Var1 Freq 1 1988-01-13 1 2 1988-01-16 1 3 1988-01-20 3 4 1988-01-25 2 5 1988-01-30 1 6 1988-02-01 5 7 1988-02-08 4 8 1988-02-14 1 9 1988-02-16 1 10 1988-02-18 4 11 1988-02-24 2 12 1988-03-04 1 I want to extract the times

[This email is either empty or too large to be displayed at this time]