search for: lopez235

Hi, How do you subset a dataframe so that you only have columns: 1. that contain one or more NAs? 2. that contain factors with greater than or equal to 32 levels? How do you remove from a dataframe columns** 3. with one or more NA's? 4. that contain factors with greater than or equal to 32 levels? ** I know how to remove columns at a basic level but I am trying

Hi, I want to get a clean succinct list of all levels for all my factor variables. I have a dataframe that's something like #1 below. This is just an example subset of my data and my actual dataset has 70 variables. I know how to narrow down my list of variables to just my factor variables by using #2 below (thanks to Bert Gunter). I can also get list of all levels for all my factor

Hi, I am using XML::readHTMLTable and getting the below error. Does anyone know why? Does this function not work with https? I didn't see anything in help about that. > library(XML) > wampage<-readHTMLTable('https://hr-workforce-analytics.llnl.gov/wf_pi_pop.html',1) Error in htmlParse(doc) : File https://hr-workforce-analytics.llnl.gov/wf_pi_pop.html does not exist Dan

Hi, Is anyone aware if there is a package that allows one to connect to Oracle Business Intelligence (aka OBIEE)? I want to be able to pull in a summary table contained in an "answer" (aka OBIEE "query"). Dan Lawrence Livermore National Lab WF Analyst [[alternative HTML version deleted]]

Hi, We have comment questions from a survey that we need to categorize. What package and functions can I use in R to help do this? Daniel Lopez Lawrence Livermore Labs SHRM [[alternative HTML version deleted]]

I have a two part question one about statistical theory and the other about implementations in R. Thank you for all help in advance. (1) Am I correct in understanding that Heteroscedasticity is a problem for Generalized Additive Models as it is for standard linear models? I am asking particularly about the GAMs as implemented in the mgcv package. Based upon my online search it seems that some

R Experts, I have a dataframe made up of character vectors--these are results from survey questions. I need to convert them to factors. I tried the following which did not work: scs2<-sapply(scs2,as.factor) also this didn't work: scs2<-sapply(scs2,function(x) as.factor(x)) After doing either of above I end up with >str(scs2) chr [1:10, 1:10] "very important" "very

Does anyone know if there are any special considerations with Random Forest and correlated fields or rather derived fields? For example if we are trying to predict who might leave our company to go work for another company some of the variables we may look at are below (in addition to others). Do we need to be cautious with comingling these especially since, for example with Age variable, all are

Hi, I am using the Random Forest package to classify observations into one of two classes. My data is unbalanced with the minority class accounting for 7% of total data set. I have heard the 10-Fold Cross validation can help me with improving classification. But being new at most of this it's not something I can do from scratch on my own. So I have spent all this morning trying to find a

Hi, Is there a way to write a dataframe or table to the clipboard as an image? I want to paste into an email. I use snagit or print screen to do this today but want to know if there is a way to do this through R. For example I know how to write to clipboard for copy and pasting into Excel: > write.table(df,"clipboard",sep="\t" But what's the equivalent for .png or

Hi R experts, I know how to send simple plain text message in body and how to send with attachments. This is thanks to stackoverflow reference below. But I don't know how to send dput() output in the body of the email (or attachment) using sendmailR. I more interested in figuring out how to include it as part of the body of the email. Does anybody have experience on how to do this?

Hi R Expert Community, I need your help in getting rggobi and ggobi to work. I tried running ggobi under Rattle's Explore tab and interactive option but got an error. I then tested library('rggobi')and noticed I get the same error. So it's not Rattle specific. I have GGOBI and rggobi installed on my machine. Below is the info. At first I got Error 'A' below. Then I

Hello, I have two Random Forest (RF) related questions. 1. How do I view the classifications for the detail data of my training data (aka trainset) that I used to build the model? I know there is an object called predicted which I believe is a vector. To view the detail for my testset I use the below-bind the columns together. I was trying to do something similar for my trainset but

Hi, Is there a function I can use on my dataframe to give me a concise summary of variables that are NA,blank,etc? Basically all Null values, Empty strings, white space, blank values. Ideally it would look something like the below: # it should only includes the fields with NAs, blanks, etc. Added bonus would be to include column Index. #Valid Records = records that are not NA, blank,etc

Hi, I have been trying to get the sub function to work but can't for the life of me figure it out. I tried looking at ?sub but I think there is something that I am just not understanding. Example failed attempts > sub("\\","/","G:\Compensation Audits_Reports\Step Audit\Steps off Step.accdb") Error: '\C' is an unrecognized escape in character string

Hi, I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010). I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here:

Hi, Can someone please offer me some guidance? I imported some data. One of the columns called "JOBTITLE" when imported was imported as a factor column with 416 levels. I subset the data in such a way that only 4 levels have data in "JOBTITLE" and tried running randomForest but it complained about "JOBTITLE" having more than 32 categories. I know that is the limit

Windows 7, R 2.15.1 64bit, RStudio 0.97.312, Rattle 2.6.26 Hi, Please help. I removed rattle then reinstalled then loaded then attempted to open rattle with rattle(). But each time I do that My R session in R studio aborts and restarts. remove.packages("rattle") install.packages("rattle") library(rattle) How can I fix this? I saw something in rattle-users but that applied

Hi, QUESTION TOPIC #1 I have some data I want to plot on a map. But what I have are home addresses: street, City, State, complete postal code--i.e 95377-1234. Is there a way to plot this data or do I need latitudinal and longitude coordinates? If so how do I convert them? Is there a package that will do the conversion in R? QUESTION TOPIC #2 I was trying to experiment with this code that I found

I noticed about a couple weeks ago that my R start up script starting showing the below errors, following the line "Type 'q()' to quit R" Not sure what I did different and so far it hasn't caused major problems but kind of fear that it will. Can you please help? I also posted my Rprofile below. Attempting to load the environment 'package:R.utils' R.methodsS3 v1.2.2