Re: [R] Comparing Variables and Writing a New Column

and found that the medians were all set to .28, and naturally nearly all the lab results were too high. Now I have to figure out what I did wrong in the previous steps when I set up the tables. Thanks for your help. Jerry Floren Minnesota Department of Agriculture -- View this message in cont

Re: [R] Comparing Variables and Writing a New Column

numeric( c(-Inf,.x[17:20],Inf)) ), + "**L", "*L", " ", "*H", + "**H") ) Error in apply(df.soil, 1, function(.x) switch(findInterval(.x[3], as.numeric(c(-Inf, : ob

[R] Comparing Variables and Writing a New Column

s" variable with each of the four "__MAD" variables and then writing the appriate flag for Results exceeding -2.5 MAD to +2.5 MAD units from the median? Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context: http://n4.nabble.com/Comparing-Var

Re: [R] Writing Graphs to Files

Thank you so much Eik. This is what I used, and it genereated 530 files of triple graphs in less than a minute. dev.copy(win.metafile, file = paste(myV,"emf",sep="."), width = 7, height = 10, pointsize = 12) dev.off() Thanks again, Jerry Floren Minnesota Department of

[R] Writing Graphs to Files

emf" into the file name? dev.copy(win.metafile, file = "C:\\Documents and Settings\\jfloren\\My Documents\\TestRSoil\\Graphs.emf", width = 7, height = 10, pointsize = 12) dev.off() Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context: h

Re: [R] Help with subset

aster than Excel that I could live with the 40 minute processing time. This is another major improvement. What will really save me the most time is the" if (nrow(rsubset) > 8)" statement. Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context

Re: [R] Help with subset

Thank you very much Peter. I'm off until Monday, but now I have an interesting project to think about over the weekend. It looks pretty simple, and it sure will beat over 2,000 pages of code to cut and paste. Thanks again, Jerry Floren Minnesota Department of Agriculture -- View this me

Re: [R] Help with subset

I am not clear what you mean by, "for (myV in myVars)" ? Is myV the name of one of the unique variables that has at least 9 Results? Is myVars the entire column of "Anlysis_Soil" ? I am not sure if this is any clearer. Thanks, Jerry Floren Minnesota Department of Agriculture

Re: [R] Yet another question about importing Excel *.xls files

to get that done today, but need to get approval before it can be installed. I am using Windows XP, but it looks like Strawberry Perl should work. I also use R version 2.9.2 (2009-08-24). Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context: http://n4.nabb

[R] Help with subset

of labs running a particular test is less than nine? Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context: http://n4.nabble.com/Help-with-subset-tp1049883p1049883.html Sent from the R help mailing list archive at Nabble.com. _

Re: [R] Yet another question about importing Excel *.xls files

e = "C:/Documents and Settings/jfloren/My Documents/Test_R/Test_Import_xls.txt", append = TRUE, quote = TRUE, sep = "\t", eol = "\n", na = "NA", dec = ".", row.names = FALSE, col.names = TRUE, qmethod = c("escape", "double")) odbcC

Re: [R] Yet another question about importing Excel *.xls files

Hi David, Thanks for your response, and I should warn you that both my programming and statistical experience is very limited. I am pretty sure Perl is not installed. I'll take care of that first thing. Thank you so much. Jerry Floren Minnesota Department of Agriculture -- View this me

Re: [R] Yet another question about importing Excel *.xls files

o removed all the worksheets except the one with the data I needed. I renamed that one Sheet1 instead of "Paste Special". With these changes, I simplified the expression, but I am still getting the same error messages. > DF <- read.xls("C:/TestR", as.is = TRUE) Converting xls f

Re: [R] Yet another question about importing Excel *.xls files

_R", > pattern = "Paste Special", as.is = TRUE) Converting xls file to csv file... Error in system(cmd, intern = !verbose) : perl not found Error in file.exists(tfn) : invalid 'file' argument > > ls() character(0) > ## End of error messages ## Thanks for all o

Re: [R] Yet another question about importing Excel *.xls files

Thanks a million Gabor. I was able to quickly import 21 test files. This will save me hours, and should eliminate some errors. Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context: http://n4.nabble.com/Yet-another-question-about-importing-Excel-xls-files

Re: [R] Yet another question about importing Excel *.xls files

ed-data-types/. " I'm going to play around with this and see if I can get it to work for my data. Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context: http://n4.nabble.com/Yet-another-question-about-importing-Excel-xls-files-tp1018699p1018

[R] Yet another question about importing Excel *.xls files

, could you please share some tips and examples to get me started. Thanks, Jerry Floren Minnesota Department of Agriculture -- View this message in context: http://n4.nabble.com/Yet-another-question-about-importing-Excel-xls-files-tp1018699p1018699.html Sent from the R help mailing list archive at

Re: [R] Identifying outliers in non-normally distributed data

Thank you Kevin. I'm looking forward to trying your function when I get back to the office. Jerry Floren Minnesota Department of Agriculture Kevin Wright-5 wrote: > > Here is a simple function I use. It uses Median +/- 5.2 * MAD. If I > recall, this flags about 1/2000 of valu

Re: [R] mean for subset

seful reports. Thanks for your suggestions; I am sure they will help improve my R skill set. Jerry Floren Minnesota Department of Agriculture Matthew Dowle-3 wrote: > > > Did you really say you're using Word's mail merge to construct "hundreds" > of > page

Re: [R] Identifying outliers in non-normally distributed data

the data collected. Thanks Steve for the link to, "The International Harmonized Protocol for the Proficiency Testing of Analytical Chemistry Laboratories." I have found some great ideas in that publication. Thank you both, Jerry Floren Minnesota Department of Agriculture S Ell

Re: [R] mean for subset

w laptop computer, and now I have an occassional problem with Word's "pretty print quotes," but if you know about that problem, it is easy to fix. Jerry Floren Minnesota Department of Agriculture Matthew Dowle-3 wrote: > > > As can data.table (i.e. do 'having

Re: [R] Identifying outliers in non-normally distributed data

methods. Yours, Jerry Floren Brian G. Peterson wrote: > > John wrote: >> Hello, >> >> I've been searching for a method for identify outliers for quite some >> time now. The complication is that I cannot assume that my data is >> normally distributed nor s