similar to: SQLDF syntax

Displaying 6 results from an estimated 6 matches similar to: "SQLDF syntax"

2012 May 13
1
Help writing function in R....
I need help writing function that takes three categorical inputs and returns a vector of summary statistics based on these inputs. The data set contains information on retail goods that can be specified by their retail segment, brand name, and type of good along with its retail price and what it actually sold for. I need to write a function that will take these inputs and average, count, and
2012 May 30
2
Sorting a data set
I am a novice user of R and am stumbling on how to order a dataset produced during my session. I have a 1863 row X 14 column dataset that I want to put out to a file. I want the output sorted by the first column and then by the second column both in ascending order. The first column is character and the second is numeric (I hope). I used an "as.numeric" function to assign that
2013 Apr 13
2
Comparison of Date format
Hi, ?In the example you provided, it looks like the dates in Date2 happens first.? So, I changed it a bit.? DataA<- read.table(text=" ID,Status,Date1,Date2 ??? ??? ?????? 1,A,3-Feb-01,15-May-01 ??? ??? 1,B,15-May-01,16-May-01 ??? ??? 1,A,16-May-01,3-Sep-01 ??? ??? ??? ??? ??? 1,B,3-Sep-01,13-Sep-01 ??? ??? ??? ??? ??? 1,C,13-Sep-01,26-Feb-04 ??? ??? ??? ??? ???
2013 Dec 13
2
how do I separete coloumns by comma?
Hi every one, I have a text file like this: 1    4   4    1    6    23 1   4    2    2    3    28 1    4    5    1    2    24 1    2    3    1    1    24 1   2    3    1    2     40 1   2   3    1    4      22 I want to separate columns by comma, like this: 1,4,4,1,6,23 1,4,2,2,3,28 1,4,5,1,2,24 1,2,3,1,1,24 1,2,3,1,2,40 1,2,3,1,4,22   I used this code:
2009 Oct 26
2
help with linear model
Dear list, I have been searching for a week to fit a simple linear model to my data. I have looked into the previous posts but I haven't found anything relevant to my problem. I guess it is something simple...I just cannot see it. I have the following data frame, named "data", which is a subset of a microarray experiment. The columns are the samples and the rows are the probes. I
2010 Nov 17
3
stacking consecutive columns
I have a file, each column of which is a separate year, and each row of each column is mean precipitation for that month. Looks like this (except it goes back to 1964). month X2000 X2001 X2002 X2003 X2004 X2005 X2006 X2007 X2008 X2009 1 1.600 1.010 4.320 2.110 0.925 3.275 3.460 0.675 1.315 2.920 2 2.960 3.905 3.230 2.380 2.720 1.880 2.430 1.380