[R] Correlation

2014-07-27 Thread Nico Met
Dear all, I have written the following code for correlation calculations. I want to create a new matrix from corData) with correlation more than 0.5 only and the rest of the columns should be removed. How can I do it? set.seed(1234) data-matrix(rnorm(100),nrow=10)

[R] average and median values for each of the class

2014-04-26 Thread Nico Met
Dear all, I have a matrix (dimension, 16 x 12) where 2nd column represents class (1,1,1,1,1,2,2,2, etc) information. I want to estimate average and median values for each of the class and add this information as a row at end of the each classes. for example: dput(dat)

[R] Formatting with strings

2014-04-23 Thread Nico Met
Dear all, I have object where I stored clusters in the following manner: ---CLUSTER 1 --- 3 4 5 6 ---CLUSTER 2 --- 9 10 8 11 Now want to format the data in the following way: Object Cluster 31 41 51 61 9 2 10 2 8

Re: [R] Formatting with strings

2014-04-23 Thread Nico Met
are trying to solve? Tell me what you want to do, not how you want to do it. On Wed, Apr 23, 2014 at 5:58 AM, Nico Met nicome...@gmail.com wrote: Dear all, I have object where I stored clusters in the following manner: ---CLUSTER 1 --- 3 4 5 6 ---CLUSTER 2 --- 9 10 8 11 Now want

[R] Column value comparison and colouring

2014-04-06 Thread Nico Met
Dear all, I have a big matrix, where I want to compare, one element of a vector with many others and clear them. For example: In column sil compare elements with other columns (0.734)-1.0770 in 3rd column, so, color them bold else color them bold red For example: dput(test)

[R] matrix of mean values

2013-10-08 Thread Nico Met
Dear all, I have a data set where I want to make a matrix of the mean values using 3rd column (value). Where rows are unique “loc” and columns would be “variables”. If there is one observation or no observation just use “NA”. dput(d1) structure(list(loc = structure(c(6L, 9L, 9L, 9L, 9L, 4L,

Re: [R] matrix of mean values

2013-10-08 Thread Nico Met
...@yahoo.com wrote: To make it matrix: row.names(res)- res[,1] res1- as.matrix(res[,-1]) A.K. - Original Message - From: arun smartpink...@yahoo.com To: Nico Met nicome...@gmail.com Cc: R help r-help@r-project.org Sent: Tuesday, October 8, 2013 10:54 AM Subject: Re: [R] matrix

[R] t-test across columns

2013-07-15 Thread Nico Met
Dear all, I would like to do t-test across two columns name with different cat with overall mean (val). (Removing if there is a single observation) And finally, make a matrix with t-value and p-value associated with a name (in rows) and cat (in columns) dput(x) structure(list(name =

[R] Transpose of the rows

2013-06-26 Thread Nico Met
Dear R users, I am using a big data matrix and need to transpose rows (formatting of input matrix). I would like write a general code for this example. for example: my input file is dta dput(dta) structure(list(id = structure(c(1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 3L, 3L, 3L, 3L), .Label =

[R] Fetch and merge from a data set

2013-06-25 Thread Nico Met
Dear all, I would like to fetch a list (data1) of entities from a big data file (data) and merged together. for example: data is the file from where I want to extract dput(data) structure(list(NAME = structure(c(6L, 6L, 7L, 6L, 6L, 7L, 6L, 7L, 3L, 5L, 3L, 3L, 3L, 3L, 4L, 3L, 3L, 4L, 3L, 3L, 3L,

Re: [R] Fetch and merge from a data set

2013-06-25 Thread Nico Met
) Hope this helps, Rui Barradas Em 25-06-2013 10:34, Nico Met escreveu: Dear all, I would like to fetch a list (data1) of entities from a big data file (data) and merged together. for example: data is the file from where I want to extract dput(data) structure(list(NAME = structure(c(6L, 6L

Re: [R] split and common variables

2013-06-05 Thread Nico Met
Associate Professor of Anthropology Texas AM University College Station, TX 77840-4352 -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Nico Met Sent: Monday, June 3, 2013 8:42 AM To: R help Subject: [R] split and common variables

[R] split and common variables

2013-06-03 Thread Nico Met
Dear all, I would like to split the data based on the place and then would like to see how many names were common in place with corresponding value . Please find a demo file. Thanks for your expert comment best Nico dput(dta) structure(list(place = structure(c(3L, 2L, 5L, 6L, 4L, 3L, 2L,

[R] Coversion from yearly to weekly data

2013-03-08 Thread Nico Met
Dear all, I have a big data matrix and I want to convert those data into weekly basis which means 7 days needs to be avaraged and aggregate a single value dput(test) structure(list(locid = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L,

[R] Correlation with p value

2013-02-13 Thread Nico Met
Dear all, I have a data (bellow) and I want to make a correlation test with p-value structure(list(Name = structure(c(3L, 3L, 3L, 3L, 3L, 3L, 3L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L), .Label = c(CTJ, PKR, TTK), class = factor), score = c(86.4371428571428, 89.7028571428572,

[R] Average calculations

2013-01-23 Thread Nico Met
Dear all, I have a matrix with two columns: Names and Values In names: there are 4 groups they are, CK113234, CK116296, CK116292 and CK114042 I want to *sort values* (decreasing order) based on each group and take average of the *top two numbers* in each of the groups. dput(x)

[R] xlsx file read in R

2012-12-03 Thread Nico Met
Dear all, How can I read .xlsx files in R Regards Nico [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide

Re: [R] xlsx file read in R

2012-12-03 Thread Nico Met
* No idea where it went wrong Regards Nico On Mon, Dec 3, 2012 at 2:07 PM, jim holtman jholt...@gmail.com wrote: use the XLConnect package. On Mon, Dec 3, 2012 at 7:59 AM, Nico Met nicome...@gmail.com wrote: Dear all, How can I read .xlsx files in R Regards Nico

[R] mean value calculation

2012-10-18 Thread Nico Met
Dear all, I want to calculate mean values for multiple rows: structure(list(Name = structure(c(1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L), .Label = c(AKT, CKT), class = factor), val1 = c(2, 3, 2, 2, 2, 5, 3, 8, 2), val2. = c(4, 5, 4, 8, 4, 8, 4, 7, 4), val3 = c(5, 6, 5, 9, 5, 9, 5, 9, 5)), .Names =

[R] How to count combinations

2012-10-08 Thread Nico Met
Dear all, Need a help. I would like to count combination of two columns: structure(list(V1 = structure(c(4L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 3L, 3L, 3L, 3L, 3L, 3L, 3L), .Label = c(23, 55, 67, Env), class = factor), V2 = structure(c(9L, 7L, 7L, 7L, 2L, 1L, 11L, 11L, 11L,

Re: [R] t-test

2012-10-05 Thread Nico Met
#0.86330310 0.32706859 0.02023357 A.K. - Original Message - From: Nico Met nicome...@gmail.com To: Rui Barradas ruipbarra...@sapo.pt Cc: r-help@r-project.org; r-help r-h...@stat.math.ethz.ch Sent: Thursday, October 4, 2012 6:37 AM Subject: Re: [R] t-test Dear Rui, Many

[R] t-test

2012-10-04 Thread Nico Met
Dear Group, I want to do a t-test calculation on a large data set. I am pasting some part of it structure(list(Name = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L), .Label = c(CTK100, CTK103, CTK121), class = factor), Score =

Re: [R] t-test

2012-10-04 Thread Nico Met
in the means, so maybe you'll have to look there for what you want. Hope this helps, Rui Barradas Em 04-10-2012 10:34, Nico Met escreveu: Dear Group, I want to do a t-test calculation on a large data set. I am pasting some part of it structure(list(Name = structure(c(1L, 1L, 1L, 1L, 1L, 1L

[R] Sorting of columns of a matrix

2012-08-29 Thread Nico Met
Dear all, Please suggest me how can I do it. I have a matrix which look like following: x1 x2 x3 t1 .01 0.3 0 t2 0 0.1 0.01 t3 0 .01 .01 t4 0 0 t5 5 0 0 t6 0 0 0 t7 0 0 0 t8 0 0 0 t9 0.6 0 0 t10 0 0 0.66 t11 0 0.6 0.11 t12 0 0.4 0 I want to sort decreasing order in each column

Re: [R] Sorting of columns of a matrix

2012-08-29 Thread Nico Met
Hello john, thanks for the suggestion. Please find an example: X-matrix(rnorm(5*10),nrow=5) dim(X) [1] 5 10 X [,1] [,2][,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10] [1,] 1.2774431 -1.2427735 0.81933548 -2.1098586 -1.6726799

Re: [R] Sorting of columns of a matrix

2012-08-29 Thread Nico Met
, 0.567403253424482, 0.583187653435685, -1.30679883346442), .Dim = c(5L, 10L)) On Wed, Aug 29, 2012 at 4:16 PM, Berend Hasselman b...@xs4all.nl wrote: On 29-08-2012, at 16:08, Nico Met wrote: Hello john, thanks for the suggestion. Please find an example: X-matrix(rnorm(5*10),nrow=5) dim(X) [1

Re: [R] Sorting of columns of a matrix

2012-08-29 Thread Nico Met
column shall have different sequence of row names? ** ** Send also your responses to r-help as somebody could have better answer for you. ** ** Regards Petr ** ** ** ** ** ** *From:* Nico Met [mailto:nicome...@gmail.com] *Sent:* Wednesday, August 29, 2012 4:56 PM

[R] elasticnet iteration problem

2012-08-21 Thread Nico Met
Dear all, I am trying to iterate an elastic net regression method on a matrix 1) Each column of the matrix ( nxp) will act as a response (y) and rest of the variables (columns) which means p-1 will act as predictor set 2) i want to store selected variables as matrix I wrote a code. Please help