Re: [R] read.csv.sql() to select from a large csv file

e sql statement with paste(). Name <- "Bobby" sqlstatement <- paste("select * from file where ID = '", Name, "'", sep = "") read.csv.sql("filename", sql = sqlstatement) Note the opening and closing quotes around the name. Hope

[R] read.csv.sql() to select from a large csv file

eone can kindly point out how to do this correctly or offer an alternative solution ? Thank you very much and happy Friday, Juliane Dr. Juliane Struve Fisheries and Aquatic Sciences 7922 NW 71st Street, Gainesville, FL 32653 352-273-3632 (tel) 352-392-3672 (fax) email:ma

[R] adehabitatLT -- movement based kernel density

Dear list,   I am intersted in estimating movement based kernel densities for fish that were relocated at fixed receivers positioned along the coast. These data tend to display both a drift movment between receivers and a random movement component that can be estimated from the mean and the vari

[R] Plotting multiple age distributions with histogram()

Dear list,   I would like to plot several age distributions that are influenced by a factor (called group in the data example below). I would like to use historam() in the lattice package, but I can't figure out how to set up the data. Could someone give me a hint how to do it  for the example b

[R] evolution of Nelder-Mead process

-with-output-of-simplex-vertices-tp25838572p25869383.html   Dr. Juliane Struve Environmental Scientist 10, Lynwood Crescent Sunningdale SL5 0BL 01344 620811 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https

[R] aggregate data into an array

Dear list,   I would like to aggregate CVTimeDiff by Fish_ID and Trip and put the result into myarray,i.e. for the example below Trip 1,9 and Fish_ID 1646 I would like to obtain mean= (0.8104876+1.3676631)/2 and put it into myarray[1] .   mydataframe   Trip Fish_ID CVTimeDiff 1    1,9 1

Re: [R] aggregate() - error message

Dear Jorge, thank you very much for your help. So with() was missing. Tripstatistics=with(TripsData,aggregate(TripsData[,3:4],by=list(Trip=Tripmatch),FUN="mean")) works. Best wishes, Juliane  Dr. Juliane Struve Environmental Scientist 10, Lynwood Crescent Sunningdale SL5 0BL 01

Re: [R] aggregate() - error message

thanks, Juliane  Dr. Juliane Struve Environmental Scientist 10, Lynwood Crescent Sunningdale SL5 0BL 01344 620811 - Original Message From: Paul Emberson To: Juliane Struve Cc: r-help@r-project.org Sent: Thursday, 24 September, 2009 12:27:00 Subject: Re: [R] aggregate() - error message

[R] aggregate() - error message

Dear list,   would anybody be able to tell me why the statement   Tripstatistics=aggregate(TripsData[2:3],by=list(Trip=Tripmatch),FUN="mean")   seems to work well with TripsData 1 but not with TripsData 2 ?   With TripsData 2 it yields   Error in FUN(X[[1L]], ...) : arguments must have same lengt

Re: [R] matching pairs regardless of order,multiple matches

e values I am looking for. Sorry for the confusion and many thanks for all help ! Juliane   - Original Message From: David Winsemius To: Juliane Struve Cc: jim holtman ; Henrique Dallazuanna ; r-help@r-project.org Sent: Tuesday, 22 September, 2009 13:19:31 Subject: Re: [R] matc

Re: [R] matching pairs regardless of order,multiple matches

o apply it for this example.   mean(DF$Data[match(trips,listoftrips)]) gives the mean for all trips, so that's not right. How can I get means for all trips in "trips" ???   Many thanks for any suggestions.     Juliane              Dr. Juliane Struve Environmental Scientist 10,

[R] matching pairs regardless of order

Dear list,   I am using match() to match pairs of locations, e.g. trip="loc1,loc2" from a list of such pairs, e.g. list=("loc1,loc2", "loc1,loc3", "loc2,loc3","loc2,loc1").   In this example match() will match "trip" with the first element of "list", but not the 4th, because the order is revers

[R] trimming observations

Dear list,   the trim argument in mean(x,trim=0.1) can be used to exclude a fraction of the observations when calculating the mean. There does not seem to be a trim argument for sd(), is there some other way of excluding observations when calculating the standard deviation ?   Many thanks for h

Re: [R] matching more than two vectors (?)- Resolved

g for !). Thank you for your time. Regards, Juliane  Dr. Juliane Struve Environmental Scientist 10, Lynwood Crescent Sunningdale SL5 0BL 01344 620811 - Original Message From: Juliet Hannah To: Juliane Struve Sent: Tuesday, 20 January, 2009 3:30:16 Subject: Re: [R] matching m

[R] matching more than two vectors (?)

Dear listmembers,   I am trying to obtain values for pointdistance from another dataframe by matching UTMX and UTMY coordinates, but I am not sure how to introduce the second coordinate.   PointDF$pointdistance=DistanceDF$distance[match(PointDF$UTMX,DistanceDF$UTMX & PointDF$UTMY,DistanceDF$UTM

[R] Movement within a circle

,add=T) symbols(0,0,circles=radius-2,inches=F,add=T) } circularspace  Dr. Juliane Struve Environmental Scientist 10, Lynwood Crescent Sunningdale SL5 0BL 01344 620811 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help P

Re: [R] sampling from a list of values while excluding one

This works great, thank you for your help ! Dr. Juliane Struve Environmental Scientist 10, Lynwood Crescent Sunningdale SL5 0BL 01344 620811 --- On Mon, 21/7/08, jim holtman <[EMAIL PROTECTED]> wrote: > From: jim holtman <[EMAIL PROTECTED]> > Subject: Re: [R] sampling fro

[R] sampling from a list of values while excluding one

the syntax ? anglenumber=sample(1:10, exclude = "number",size=1,replace=TRUE) Thank you very much for a hint. Regards, Juliane Dr. Juliane Struve Environmental Scientist 10, Lynwood Crescent Sunningdale SL5 0BL 01344 620811 _

[R] Reading an ArcGIS raster file

stuck with this now. I am new to this list and also to R, so any help would be much appreciated. Many thanks and best wishes, Juliane Dr. Juliane Struve Adjunct Environmental Scientist Mote Marine Laboratory Center for Fisheries Enhancement 1600 Ken Thomson Parkway Sarasota, Florida, 34236