Displaying 20 results from an estimated 10000 matches similar to: "aggregate function"
2011 Jun 13
3
combine the data frames into comma separated list.
Hi R users,
I am new to R and am trying to merge data frames in the following way.
Suppose I have n data frames each with two fields. Field 1 is common among
data frames but may have different entries. Field 2 is different.
Data frame 1:
Src Target1
1 aaa
1 bbb
1 ccc
2 aaa
3 ddd
Data frame 2:
Src Target2
2 aaaa
3 dddd
4 bbbb
4
2011 Aug 19
3
installing packages systemwide
I installed some downloaded packages in R. I always do
$sudo R CMD INSTALL <anRpackage.tar.gz>
By default it is storing these packages into my directory
/home/mary/R/x86_64-pc-linux-gnu-library/2.13/.
However I want them to be systemwide into /usr/local/lib/R/site-library/
folder.
I tried
$sudo R
R> install.packages("anRpackage", dep=TRUE)
I did not succeed into getting
2011 Aug 19
3
installing packages systemwide
I installed some downloaded packages in R. I always do
$sudo R CMD INSTALL <anRpackage.tar.gz>
By default it is storing these packages into my directory
/home/mary/R/x86_64-pc-linux-gnu-library/2.13/.
However I want them to be systemwide into /usr/local/lib/R/site-library/
folder.
I tried
$sudo R
R> install.packages("anRpackage", dep=TRUE)
I did not succeed into getting
2012 Jul 22
4
pvalue calculate
I have a value
a=300
observation (x) = sample(1:50)
How to find a p-value from this. I need to show that "a" is different fom
mean(x).
Thanks
--
-------------
Mary Kindall
Yorktown Heights, NY
USA
[[alternative HTML version deleted]]
2011 Nov 16
1
read.table : fill missing entry with "unAvailable" [edit]
Hi R users,
I try to read a data file (tab delimited format) in which some of the
entries in a particular field are missing. Is it possible to fill the
unavailable data with 'UnAvailable' string while performing read.table()
Something like
df = read.table(DataFile, header=FALSE, fill_missing_entry = 'unAvailable')
1
thanks
--
-------------
Mary Kindall
Yorktown Heights,
2012 Jan 06
6
cbind alternate
I have two one dimensional list of elements and want to perform cbind and
then write into a file. The number of entries are more than a million in
both lists. R is taking a lot of time performing this operation.
Is there any alternate way to perform cbind?
x = table1[1:1000000,1]
y = table2[1:1000000,5]
z = cbind(x,y) //hanging the machine
write.table(z,'out.txt)
--
-------------
2012 Jan 06
1
(Edited) cbind alternate for data frames
>
> I have two dataframes and want to perform cbind and then write into a
> file. The number of entries are more than a million in both frames. R is
> taking a lot of time performing this operation.
>
> Is there any alternate way to perform cbind?
>
> x = table1[1:1000000,1:4]
> y = table2[1:1000000,3:6]
>
> z = cbind(x,y) //hanging the machine
>
>
2012 Jan 08
1
mode of frequency distribution table
In a frequency distribution table (bell shaped), how can we find the most
frequent range?
for example:
x = c(1,2, 4,4,4,4, 5,5,5,6,6,5,5,5,5,5,6,6,6,13, 17,17,30,100,300)
barplot(table(x))
In the code above, which function do we use to find that the most
frequent value range from 4 to 6.
Thanks.
--
-------------
Mary Kindall
Yorktown Heights, NY
USA
[[alternative HTML version deleted]]
2011 Nov 08
2
download.file
I am downloading say 100 files from ucsc website and storing it into dest
folder.
download.file function create a file in destination folder even if the file
is not present which is something I dont want.
So I wrote if condition to remove the file if the download function has non
zero value.
Now it exits when there is an error or file not present. How can I use
"try" and "if"
2011 Jun 14
1
[Resolved] combine the data frames into comma separated list.
Hi
Thanks Gabor for your suggestion. I am posting the code that worked for me.
dataframe1 = data.frame(cbind(Src = c(1,1,1,2,3), Target1 =
c('aaa','bbb','ccc','aaa','ddd'))); #must be data frame
dataframe2 = data.frame(cbind(Src = c(2,3,4,4,4), Target2 =
c('aaaa','dddd','bbbb','eeee','ffff')));
dataframe3 =
2011 Sep 16
1
download files using ftp: avoid error
I am planning to download a large number of files from some website. I am
using the following script.
files2down = c('aaa', 'bbb', ................)
for (i in 1: len)
{
print(paste('downloading file', i, ' of total ', len));
url = paste(urlPrefix, files2down[i], sep='')
destfile = paste (dest, 'inDir', files2down[i], sep='/' )
2012 Jan 12
1
relative frequency plot using ggplot or other function
Hi
I have a data frame in the following form. There are two groups and for
each 'width' relative frequency for group1 and group2 is given. How to plot
this in R using ggplot or other package.
Width relativeFrequency1 relativeFrequency2
1 100 0.0006388783 0.02265428
2 200 0.0022677303 0.02948625
3 300 0.0061182673 0.01739936
4 400 0.0152237225 0.02569902
5 500
2011 Jun 19
1
save and load in R
I have a list of txt files that I want to convert into .rdata R data
object.
filenames
1. "./file1.txt"
2. "./file2.txt"
3. "./file3.txt"
4. "./file4.txt"
5. "./file5.txt"
6. "./file6.txt"
7. "./file7.txt"
8. "./file8.txt"
9. "./file9.txt"
10. "./file10.txt"
I saved these files as
for ( i in
2011 Nov 11
1
list.dir() function
Hi
I have an organism directory that contains two folders galGal3 and hg19 and
many other files.
orgDir = '/home/mary/org'
When I try to use list.dir() function, it gives me the same answer, no
matter what is the value of full.names argument.
> list.dirs(path = indexDir, full.names = FALSE)[1] "/home/mary/org"
[2] "/home/mary/org/galGal3"
[3]
2012 Jan 16
1
ggplot- using geom_point and geom_line at the same time
Hi
I am plotting line chart using ggplot and want to use geom_line and
geom_point simultaneously.
I get the plot but now I have two legends. None of the legend is
representing the true values. I need the legend with shape and color both.
Thanks
> con = textConnection("inputs var1 var2 var3+ 100 10 5 2+ 1000 20 10 4+ 5000 30 15 8+ 10000 40 20 16+ 30000 50 25 32")> data =
2006 Oct 31
1
Fw: domU network problem , 10/30 progress
Hao Yu
Commercial Scale Out
IBM T.J. Watson Research Center
1101 Kitchawan Rd/Route 134, Rm 36-019
Yorktown Heights, NY 10598-0218
914-945-1854, Email: yuh@us.ibm.com
----- Forwarded by Hao Yu/Watson/IBM on 10/31/2006 09:52 AM -----
Jimi
2006 Oct 31
1
Fw: domU network problem , 10/30 progress
Hao Yu
Commercial Scale Out
IBM T.J. Watson Research Center
1101 Kitchawan Rd/Route 134, Rm 36-019
Yorktown Heights, NY 10598-0218
914-945-1854, Email: yuh@us.ibm.com
----- Forwarded by Hao Yu/Watson/IBM on 10/31/2006 09:52 AM -----
Jimi
2010 Jan 31
2
Reshaping matrix of vectors as dataframe
Dear R people,
I have to deal with the output of a function which comes as a matrix of
vectors.
You can reproduce the structure as given below:
x <- list(c(1,2,4),c(1,3,5),c(0,1,0),
c(1,3,6,5),c(3,4,4,4),c(0,1,0,1),
c(3,7),c(1,2),c(0,1))
data <- matrix(x,byrow=TRUE,nrow=3)
colnames(data) <- c("First", "Length", "Value")
rownames(data)
2008 Jun 23
1
problem in R for Linear mixed model~
Dear R users:
I just got confused some R code used in linear mixed model~
example,two factors,A, B,C,A is fixed ,B,C are random,and B is nested in
C,if I wannt to use linear mixed model,are the following code correct for
each case?
case1:want to know random effect of B,
case1<-lme(y~A*B*C,random=~B|C) where "B|C" stand for what?,mean B is
nested in C?
case2: how to wirte
2010 Oct 07
3
aggregate text column by a few rows
Hi, R function aggregate can only take summary stats functions, can I
aggregate text columns? For example, for the dataframe below,
> a <- rbind(data.frame(id=1, name='Tom',
hobby='fishing'),data.frame(id=1, name='Tom',
hobby='reading'),data.frame(id=2, name='Mary',
hobby='reading'),data.frame(id=3, name='John',