similar to: Converting factor data into Date-time format

Dear R experts, I am trying to import some data from some Excle files into R. My Excle file contains about 50 sheets. One solution I can think about is to convert my Excle file into csv file first and then load data into R using 'read.csv'. But it seems to me that 'read.csv' only supports reading one sheet (or 'one file') each time, so that seems I have to create 50 csv

Dear R users Say I wanted to read a vector into R as multi-dimensional array by row, e.g. a<-c(1:20) > b<-array(a,dim=c(2,5,2)) > b , , 1 [,1] [,2] [,3] [,4] [,5] [1,] 1 3 5 7 9 [2,] 2 4 6 8 10 , , 2 [,1] [,2] [,3] [,4] [,5] [1,] 11 13 15 17 19 [2,] 12 14 16 18 20 But actually I wanted... [,1] [,2] [,3] [,4] [,5]

Dear R user I have data created using code below b<-matrix(2:21,nrow=4) b[,1:3]=NA b[4,2]=5 b[3,1]=6 Now the data is > b [,1] [,2] [,3] [,4] [,5] [1,] NA NA NA 14 18 [2,] NA NA NA 15 19 [3,] 6 NA NA 16 20 [4,] NA 5 NA 17 21 I want to keep data in column 4 greater than 15 and the value in column 1 & 2 either greater than 4

Dear R-user, I'm trying to compare two sets of results and wanted to find out which element in the two data frame/matrix are different. I wrote the following function and it works ok, and gives me a long list of "good" as outcomes. CHECK<- function (x = "file1", y = "file2") { for (i in 1:nrow(x)) { for (j in 1:ncol(x)) { if (x[i, j]

Dear R users I am struggling from a data importing issue: I have some hundreds of csv files needed to be read into R for futher analysis. All those csv files are named in one of the three formats: (1) strings: e.g. London_Oxford street (2) Integer: e.g. 1234_5678 (3) combined: e.g. London_1234 I intend to use read.csv("xxxx_xxx.csv") but I only dealt with sigle documents before and

Dear R users I read two csv data files into R and called them Tem1 and Tem5. For the first column, data in Tem1 has 13 digits where in Tem5 there are 14 digits for each observation. Originally there are 'numerical' as can be seen in my code below. But how can I display/convert them using other form rather than scientific notations which seems a standard/default? I want them to be in

Dear R users I am trying to exporting plots from R to an external folder, or to the working directory, but the resolution of plots (pdf file) largely reduced. Any way I can get same quality as my original plots?? e.g. I tested the plotting part using one example and obtained pretty good (/readable) quality for each plot in the (4*4) multiple graph. But when I did the loop and tried to export

Dear R-help, I am trying to express myself as best as I can here. If you also use Latex to edit math reports or other languages with similar editing method, you'll see what I'm talking about. My sincere appologies if my question is not clear enough to some extend, as also I'm not able to provide my code here because I don`t know which one I can use... When editing the title in R

Dear R users I wondered if any of you ever tried to calculate distance matrix with very large data set, and if anyone out there can confirm this error message I got actually mean that my data is too large for this task. negative length vectors are not allowed My data size and code used dim(mydata_nor)[1] 365000 144> d <- dist(mydata_nor, method = "euclidean") Here my

Dear R user I want to create a table (as below) to summarize the attached data (Test.csv, which can be read into R by using 'read.csv(Test.csv, header=F)' ), to indicate the day that there are any data available, e.g.value=1 if there are any data available for that day, otherwise value=0. 28/04 29/04 30/04 01/05 02/05 532703 0 1 1

I have a problem moving from multistratum aov analysis to lmer. My dataset has observations of ampl at 4 levels of gapf and 2 levels of bl on 6 subjects levels VP, with 2 replicates wg each, and is balanced. Here is the summary of this set with aov: >> summary(aov(ampl~gapf*bl+Error(VP/(bl*gapf)),hframe2)) > >Error: VP > Df Sum Sq Mean Sq F value Pr(>F) >Residuals

Dear R users I tried an example earlier to check the results using two different methods of clustering with same data set, and for both methods, say method A and method B. Also I decided to have same number of groups/clusters (here 8 was chosen). I found a good graphical tool in R to compare the distribution of the number in each group/cluster created by method A and method B, e.g. how many of

I am forwarding this bug report from the Debian bug tracking system. Please preserve the CC header when responding. To reach the submitter directly, send mail to 179764-submitter@bugs.debian.org. ----- Forwarded message from HJ <inzanekaoz@yahoo.com> ----- Date: Tue, 4 Feb 2003 03:54:36 -0800 (PST) From: HJ <inzanekaoz@yahoo.com> Resent-From: HJ <inzanekaoz@yahoo.com> To:

Dear R-help, My dataset (which is a data frame, called 'Calender' here) includes 365 rows representing 365 days for a year. One column ('Season')contains factor data representing seasons, e.g. spring, summer, autumn and winter. Another column (called 'Day') contains data representing wether the day is a working day (I use 'Wd' for short here)or weekend (I use

Dear R users I have the matrix of the centres of some clusters, e.g. 20 clusters each with 100 dimentions, so this matrix contains 20 rows * 100 columns numeric values. I have collected new data (each with 100 numeric values) and would like to keep the above 20 centres fixed/'unmoved' whilst just see how my new data fit in this grouping system, e.g. if the data is close to cluster 1

Dear R-help, I am trying to rename the variables in a dataframe, called 'T1A' here. Seems renaming was successful, but when I call one of the variable I got error message and I wanted to know why. The data frame contains 365 rows and 49 columns. I would like to name the first column `DATE` and the others T0.5, T1, T1.5,...,T24 (as this is a set of data collected every half hour for a

Is anyone routing samba connections over a wan? Is there a way to do this that will make the network admins happy? Thanks for your help with this. -alan ============================================== Alan M. Goldberg SAP Basis Specialist, Web Consultant HJ Heinz Company of Canada Ltd PH: 416-226-7542 FX:416-226-7564 CEL: 416-606-8945 PAG:416-381-0157 alan.goldberg@hjheinz.com

Dear all, I am facing a strange problem with text files formats. I am currently using a C++ code named voro++ (http://math.lbl.gov/voro++/). This code accepts text files with four columns: <id> <x> <y> <z> where id is an identification number and x,y,z are the coordinates of a point in a 3D space. The input file, name it myfile_cpp.txt, is generated by another C++ code

--- Brendan Cully <brendan@xiph.org> wrote: > Whoops, I only meant to commit the HACKING file. configure.in > isn't broken, but > it isn't finished (I'm adding a shout-config script). <p>Has 'pkg-config' been considered for this sort of thing? http://www.freedesktop.org/software/pkgconfig/ Is it desirable/compatable/useful? ~HJ

hello all! After having read http://www.xiph.org/ogg/vorbis/listen.html and listened to the examples on that very educational page, I decided to augment the info. This example is more simple, it involves the comparision between two streams of the same radio station, FranceInter (a station of Radio France in Paris). The ogg stream is running at around 30 kbps/11 kHz in stereo. The WMA stream