Displaying 20 results from an estimated 30000 matches similar to: "count value changes in a column"
2011 Mar 21
2
string interpolation
Is there a way to do this in R? I have data in the form:
57_input 57_output 58_input 58_output etc.
can i use a for loop (i in 57:n) that plots only the outputs? I want
this to be robust so im not specifying a column id but rather
something like c++ code,
%s_input, i
is that doable in R?
Thanks,
justin
2011 Jun 17
3
rle on large data . . . without a for loop!
I think need to do something like this:
dat<-data.frame(state=sample(id=rep(1:5,each=200),1:3, 1000,
replace=T,prob=c(0.7,0.05,0.25)),V1=runif(1,10,1000),V2=rnorm(1000))
rle.dat<-rle(dat$state)
temp<-1
out<-data.frame(id=1:length(rle.dat$length))
for(i in 1:length(rle.dat$length)){
temp2<-temp+rle.dat$length[[i]]
out$V1[i]<-mean(dat$V1[temp:temp2])
2011 Apr 27
3
MASS fitdistr with plyr or data.table?
I am trying to extract the shape and scale parameters of a wind speed
distribution for different sites. I can do this in a clunky way, but
I was hoping to find a way using data.table or plyr. However, when I
try I am met with the following:
set.seed(144)
weib.dist<-rweibull(10000,shape=3,scale=8)
weib.test<-data.table(cbind(1:10,weib.dist))
2011 Jul 08
1
binary conversion list to data.frame with plyr... AND NO LOOPS!
Happy weekend helpeRs!
As usual, I'm stumped by R...
My plan was to take an integer number, convert it to binary and wind
up with a data.frame where each column is either 1 or 0 so I can see
which bits are changing:
bb<-function(i) ifelse(i, paste(bb(i %/% 2), i %% 2, sep=""), "")
my.dat<-c(36,40,10,4)
my.binary.dat<-bb(my.dat)
2011 Aug 30
1
lubridate and intervals
Hiya,
maybe there is a native R function for this and if so please let me know!
I have 2 data.frames with start and end dates, they read in as strings and I
am converting to POSIXct. How can I check for overlap?
The end result ideally will be a single data.frame containing all the
columns of the other two with rows where there were date overlaps.
2012 Apr 16
1
system command to a specific shell (bash)
I need to run a bash command, but when you call system() the default shell
is sh (see my sessionInfo below).
I found the shell command (
http://www.stat.ucl.ac.be/ISdidactique/Rhelp/library/base/html/shell.html)
but it seems to be disappeared in current versions of R?
I am running all this from R CMD BATCH with "system" calls to other R
scripts.
For a little more info, I'm
2011 Oct 27
1
preceding X. and X
Hello,
Why do I get preceding "X." (that is a and X followed by a period) for
negative numbers and an "X" for positive numbers when I read a csv file? Am
I stuck with this? If so, how do I convert it to normal numbers?
dat=read.csv(file_path)
> dat
[1] X0.0 X.0.240432350374 X0.355468069625
X.0.211469972378 X1.1812797415 X.0.227975150826
2011 Aug 10
1
Sequential Naming of ggplot .pngs using plyr
If I have data:
dat<-data.frame(a=rnorm(20),b=rnorm(20),c=rnorm(20),d=rnorm(20),site=rep(letters[5:8],each=5))
And want to plot like this:
ctr<-1
for(i in c('a','b','c','d')){
png(file=paste('/tmp/plot_number_',ctr,'.png',sep=''),height=8.5,
width=11,units='in',pointsize=9,res=300)
print(ggplot(dat[,names(dat) %in%
2011 Sep 12
1
plot 3 lines with ggplot2
Hi,
I am trying to learn to use ggplot2 for what I had hoped would be a
fairly simple task. I have a relatively small data.frame (100 by 4).
The first column contains symbols. The 2nd, 3rd and 4th columns
represent percentage weightings for each symbol using 3 different
methodologies. For example:
sym <- make.unique(replicate(100, paste(sample(LETTERS, 3, replace =
TRUE), collapse =
2011 Aug 15
1
ggplot in a function confusion!
Whats going on here?
df<-data.frame(x=1:10,y=1:10)
ggplot()+geom_point(data=df,aes(x=x,y=y)) ## this is the normal usage
right?
ggplot()+geom_point(data=df,aes(x=df[,1],y=df[,2])) ## but I can also feed
it column indices
ggplot()+geom_point(aes(x=df[,'x'],y=df[,'y'])) ## or column names.
## but if i wrap it in a function...
plot.func.one<-function(dff,x.var,y.var){
2011 Nov 22
4
Data Frame Search Slow
Hey All,
So - I promise to write a blog post on this topic and post it somewhere on
the internet once I get to the bottom of this. Basically, the set-up to the
problem is like this:
1. I have a data frame with dim (2547290, 4)
2. I need to make SQL like lookups on the dataframe. I have been using the
following sort of syntax:
a.dataframe[a.dataframe[[column_index]] %in% some_value, ]
3.
2011 May 11
3
ddply with mean and max...
I'm trying to use ddply to compute summary statistics for many variables
splitting on the variable site. however, it seems to work fine for mean() but
if i use max() or min() things fall apart. whats going on?
test.set<-data.frame(site=1:10,x=.Random.seed[1:100],y=rnorm(100))
means<-ddply(test.set,.(site),mean)
means
site x y
1 1 -97459496 -0.14826303
2
2011 Nov 02
1
mysterious warning message regarding bytecode...
While running a long script which source()s other scripts I get the
following warning:
Warning message:
In t(object$S[[1]]) : bytecode version mismatch; using eval
I cannot replicate it if I run the sourced files line by line though...
What is that error? And do I care about it? It doesn't seem to
affect my output as far as I can tell.
Thanks!
Justin
> sessionInfo()
R version
2011 Mar 16
1
linear regression in a data.frame using recast
I have a very large dataset with columns of id number, actual value,
predicted value. This used to be a time series but I have dropped the
time component. So I now have a data.frame where the id number is
repeated but each value in the actual and predicted columns are
unique.
I assume I need to use recast somehow but I'm at a loss... how can I
perform a simple linear regression (using
2003 Aug 13
4
Levene test of homogeneity of variance
Has the Levene test of homogeneity of variance been implemented in any
library in R?
Thanks,
Maurice Haynes
National Institute of Child Health and Human Development
Child and Family Research Section
6705 Rockledge Drive
Bethesda, MD 20892
Voice: 301-496-8180
Fax: 301-496-2766
E-Mail: mh192j at nih.gov
2002 Nov 27
2
Error message: missing value where logical needed
Dear all,
I often import data sets from other programs that contain user defined
missing values. As an example consider a variable MXPLOCO with a user
defined missing value of as -9.
> summary(MXPLOCO)
Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
-9.000 4.750 5.000 5.349 6.000 8.500 2.000
The following command successfully converts the value -9 to NA. However,
2010 Jul 20
2
make fails with samba-3.5.4 Solaris 9
Hi,
I am having a problem getting a Makefile after I run configure as follows:
./configure --prefix=/opt/samba-3.5.4 --with-ads --with-krb5=/opt/samba-3.5.4/include/ --with-shared-mod
ules=idmap_rid --with-ldap=/opt/samba-3.5.4/include/ldap.h
There is no Makefile generated. Configure runs successfully. The error I get is:
# /usr/local/bin/make
make: *** No targets specified and no makefile
2006 Jun 14
5
display formatted date
Hi,
In my form I have date field set as ''datetime_select'' which is fine as I
wanted it in the same format. But while displaying (list action) it
displays date in long format i.e. ''Tue May 30 15:39:00 Central Daylight
Time 2006''. How can I format it so that it will just be diaplyed as
''dd/mm/yyyy'' format?
Thanks
--
Posted via
2012 Feb 04
1
GGPLOT2: Distance of discrete values of from each end of x-axis
Hi Group,
I have been working with the code below. Everything seems to work
okay, except that the discrete values on the x-axis are far from each
end of the graph. I've tried several things including changing the
discrete values and playing with the limits, but can't get it to work.
I tested this on simulated data and do not have the same problem, so I
guessing it is how I'm
2005 Apr 20
5
ActionMailer: Net::SMTPSyntaxError (502 unimplemented (#5.5.1) error
Quick ActionMailer Question:
I''m trying to send a test email message using ActionMailer and I get a
Net::SMTPSyntaxError (502 unimplemented (#5.5.1) error.
I''m attempting to access a remote smtp server and have setup my
settings in the environment.rb file according to the "how to" article.
My test controller:
class MailTestController < ApplicationController