[R] Packaged exe and Shiny
Hey Everyone, I do not know if this topic has been covered, I'm sure it must have, but is there a good environment for packaging R code into a distributed exe. (which includes all of the required libraries, etc.)? I have seen that Shiny is a good GUI / Web library for sharing R programs, but I have never used it. What is the groups input on this? My goal is to create some basic tools (with interfaces) at work for analyzing .csv files and generating basic graphs and output csv files. These tools would be distributed to team members to have on their desktops. I considered doing this in Java, but I am more well versed in R so it would be quicker for me to whip up the varying tools in R than re-learning Java. Thank you! -Kevin __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] read.xlsx function crashing R Studio
Hey everyone, I have used read.xlsx in the past rather than XLConnect for importing Excel data to R. However, I have been finding now that the read.xlsx function has been causing my R studio to Time out. I thought it might be because the R studio I had was out of date so I installed R studio X64 3.3.1 and reinstalled the xlsx package but it is still failing. I have been trying to use XLConnect in it's place which has been working, excpet that I am running into memory error: Error: OutOfMemoryError (Java): GC overhead limit exceeded I did some online searching and found an option to increase memory: "options(java.parameters = "-Xmx4g" ) but it resulted in this new memory Error: Error: OutOfMemoryError (Java): Java heap space Can anyone provide me with some help on getting the read.xlsx function working? -Kevin __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] String Matching
Hey everyone, I have been having an issue trying to find a specific string of text in a log of system messages. I have tried to use pmatch, match, and some regular expressions but all to no avail. I have a matrix / data.frame (either one, the file outputs a tens of thousands of rows with a single column) of strings in the following format with different items after INFO: "09:11:57.259 - Assay File Processing Thread - INFO - SolenoidCycleMessage: Addr = 0x03 " as an example I would like to match "SolenoidCycleMessage" searchString<-"SolenoidCycleMessage" matchString<-"09:11:57.259 - Assay File Processing Thread - INFO - SolenoidCycleMessage: Addr = 0x03" pmatch(searchString, matchString) [1] NA match(searchString, matchString) [1] NA match(matchString, searchString) [1] NA grep(searchString, matchString, ignore.case=FALSE) [1] 1 df<-as.data.frame(c(matchString, string1, string2)) df c(matchString, string1, string2) 1 09:11:57.259 - Assay File Processing Thread - INFO - SolenoidCycleMessage: Addr = 0x03 2 23:12:43.22 - Test 3 test grep(searchString, df, ignore.case=FALSE) integer(0) grep(searchString, c(matchString, string1, string2), ignore.case=FALSE) [1] 1 Doe anyone have some input that could help? Thanks, Kevin __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] Exporting from R to Excel or .csv
Hello, Does anyone have some insight on how to; or where I can find better information on how to, export multiple data.frames of different dimensions to the same .csv or excel file? -Kevin __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] for loop incorrect row count
Hey, I am having an issue with a for loop that is intended to read index values by row and column so that it can pull out the valuable information. My issue is that I am using a data.frame(which(df==1, arr.ind=TRUE)) to find the index of the values in my data frame that are equal to 1. This outputs a data frame of 71 rows which is confirmed by the "nrows" function. However, when I try to break up the rows and columns using the code below I am producing two vectors of 75 values, even though there are only 71 and the for loop is from 1 to the value of 71. Am I making this task more complicated than it needs to be? if(countRaw > 0){ index_R_df<-rbind(index_R_df,data.frame(which(sapply(data2[0:24,], match, INDString, nomatch=0)==1, arr.ind=TRUE))) index_lengthR<-nrow(index_R_df) for (j in 1:index_lengthR){ index_rowsR<-c(index_rowsR, index_R_df[j,1]) index_colsR<-c(index_colsR, index_R_df[j,2]) #rowsPass_R<-c(unique(index_rowsR)) #collect_rows<-c(collect_rows, rowsPass_R) } I'm sorry if this seems very novice, I'm new to R. -Kevin __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Finding index of specific values in a data.frame
Oh I see, I'm sorry I just plopped it in GitHub for ease of help, I didn't notice I put it under coursera work. This task is not related to coursera, I will separate it out. -Kevin Sent from my iPhone > On Jun 10, 2015, at 3:21 PM, David Winsemius wrote: > > >> On Jun 10, 2015, at 9:41 AM, Kevin Kowitski wrote: >> >> Hey everyone, >> >> I am new to R and I am trying to find the index of all of the values in a >> data.frame. I have a .csv file that outputs pass, fail, error, and >> indeterminate readings. I have passed the data from the .csv to a >> data.frame, have performed the proper matching criteria to generate a >> data.frame of 0's and 1's, and am outputting the total 1's (therefore >> matches) found. I would also like to find the index of these values so that >> I can output a matrix containing the date and data point which has produced >> that match. Can anyone help set me in the right direction? >> >> here is a github link to the code I have already generated for more clarity >> on the project: >> >> https://github.com/KevinKowitski/datasciencecoursera/blob/master/ErrorCount.R > > I think the coursera homework assignments are supposed to be discussed in a > course-provided web-mediated mailing list. > > It's unclear from the presentation why the `which` and `%in%` do not provide > a solution. >> >> Thank you, >> Kevin >> __ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. > > David Winsemius > Alameda, CA, USA > > __ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Finding index of specific values in a data.frame
I did not realize that there is a coursers assignment similar to this. I am running this for data analysis at work, not for coursers. However I will look through the link you provided and see if it is applicable. Thanks, Kevin Sent from my iPhone > On Jun 10, 2015, at 3:21 PM, David Winsemius wrote: > > >> On Jun 10, 2015, at 9:41 AM, Kevin Kowitski wrote: >> >> Hey everyone, >> >> I am new to R and I am trying to find the index of all of the values in a >> data.frame. I have a .csv file that outputs pass, fail, error, and >> indeterminate readings. I have passed the data from the .csv to a >> data.frame, have performed the proper matching criteria to generate a >> data.frame of 0's and 1's, and am outputting the total 1's (therefore >> matches) found. I would also like to find the index of these values so that >> I can output a matrix containing the date and data point which has produced >> that match. Can anyone help set me in the right direction? >> >> here is a github link to the code I have already generated for more clarity >> on the project: >> >> https://github.com/KevinKowitski/datasciencecoursera/blob/master/ErrorCount.R > > I think the coursera homework assignments are supposed to be discussed in a > course-provided web-mediated mailing list. > > It's unclear from the presentation why the `which` and `%in%` do not provide > a solution. >> >> Thank you, >> Kevin >> __ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. > > David Winsemius > Alameda, CA, USA > > __ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] Finding index of specific values in a data.frame
Hey everyone, I am new to R and I am trying to find the index of all of the values in a data.frame. I have a .csv file that outputs pass, fail, error, and indeterminate readings. I have passed the data from the .csv to a data.frame, have performed the proper matching criteria to generate a data.frame of 0's and 1's, and am outputting the total 1's (therefore matches) found. I would also like to find the index of these values so that I can output a matrix containing the date and data point which has produced that match. Can anyone help set me in the right direction? here is a github link to the code I have already generated for more clarity on the project: https://github.com/KevinKowitski/datasciencecoursera/blob/master/ErrorCount.R Thank you, Kevin __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.