Re: [R] Read .xlsx and convert date-column value into Dataframe
Hi Ivan, This way i would've tried but i am using R 2.15 - ReadXL package will support R =3 versions. Thanks, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Read-xlsx-and-convert-date-column-value-into-Dataframe-tp4710192p4710232.html Sent from the R help mailing list archive at Nabble.com. __ 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] Read .xlsx and convert date-column value into Dataframe
Hi Jim, My requirement is simple. I have to read date-values from the excel file into dataframe, that's all. and i tried using the way you mentioned and it works. Thank you very much ! -- View this message in context: http://r.789695.n4.nabble.com/Read-xlsx-and-convert-date-column-value-into-Dataframe-tp4710192p4710233.html Sent from the R help mailing list archive at Nabble.com. __ 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 and convert date-column value into Dataframe
Hi, Here i am having a .xlsx file and it contains various columns including date-column[mm/dd/yy]-but it is not in the date format. I have to read this excel[.xlsx] file and need to get in dataframe. So i used xlsx-liabrary and it was fine to read data. But the problem is, values in the date column is converting to some other value. for eg:- FF DATE --- 3/31/2016 2/26/2016 -- 1/2/2016 [Values like -- will come in the column to indicate that there is no date mentioned ] and i getting result like this, FF DATE --- 42460 42426 42125 this is the code i am using for it, theData-data.frame(read.xlsx2(InputFilePath, sheetIndex, sheetName=Workflow_Report, startRow=3,colIndex=NULL, endRow=NULL, as.data.frame=TRUE, header=TRUE)) Aim :- I have to get actual date-column values in dataframe from xlsx file. I tried many ways, Could someone please help ? Thanks in advance, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Read-xlsx-and-convert-date-column-value-into-Dataframe-tp4710192.html Sent from the R help mailing list archive at Nabble.com. __ 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] Execute Excel-Macro using R
Hi, How to execute ms-Excel Macro(*.xlsm) using R function ? I tried but not get. There are method to call from R function from Excel macro, but i need Excel macro to execute from R. Is it possible ? I am using Excel-2010 macro. Thanks in advance, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Execute-Excel-Macro-using-R-tp4682533.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Filter Dataframe for Alarm for particular column(s).
What will be the code, if we required all the row number ? Thanks, Antony. From: arun kirshna [via R] [mailto:ml-node+s789695n467097...@n4.nabble.com] Sent: Saturday, July 06, 2013 12:54 AM To: Akkara, Antony (GE Power Water, Non-GE) Subject: Re: Filter Dataframe for Alarm for particular column(s). Hi, May be this helps: If you had showed your solution, it would be easier to compare. res-data.frame(lapply(sapply(MyDF[,c(2,4)],function(x) {x1-which(c(0,diff(x))0);x1[length(x1)==0]-0;x1}),`[`,1)) res # TNH BIX #1 3 9 #Speed set.seed(24) MyDFNew- data.frame(TNH=sample(0:1,1e6,replace=TRUE),BIX=sample(0:1,1e6,replace=TRUE)) system.time(res1-data.frame(lapply(sapply(MyDFNew,function(x) {x1-which(c(0,diff(x))0);x1[length(x1)==0]-0;x1}),`[`,1))) # user system elapsed # 0.364 0.000 0.363 res1 # TNH BIX #1 7 2 MyDFNew[1:10,] # TNH BIX #10 1 #20 0 #31 1 #41 1 #51 0 #61 0 #70 1 #81 1 #91 1 #10 0 0 A.K. Hi, Hi here i have a dataframe called MyDF. a-c(1,1,1,1,1,0,0,0,1,1) b-c(1,1,0,1,1,0,0,0,1,1) c-c(1,1,1,1,1,1,1,0,1,1) d-c(1,1,1,1,1,1,1,1,0,1) MyDF-data.frame(DWATT=a,TNH=b,CSGV=c,BIX=d) My requirement is, here i need a function - to get for a particular row number(s), when particular column(s) value change from one-to-zero (for the first change). Suppose there is no change is happening then it should return Zero For example, Using MyDF, DWATT TNH CSGV BIX 1 11 1 1 11 1 1 01 1 1 11 1 1 11 1 0 01 1 0 01 1 0 00 1 1 11 0 1 11 1 Here i want to know, the row number where TNH-column and BIX-column values change happening from one-to-zero for the first time. Note:- Suppose there is no change is happening then it should return Zero Answer should be a dataframe with single row. So here answer should return a dataframe like this. TNH BIX -- 3 9 i used some ways to get a solution using loops. But there is a bulk files with bulk rows to process. So performace is most important. Could someone please suggest better ideas ? Thanks, Antony. __ [hidden email] mailing list 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. If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/Filter-Dataframe-for-Alarm-for-particular-column-s-tp4670950p4670970.html To unsubscribe from Filter Dataframe for Alarm for particular column(s)., click here http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4670950code=YW50b255LmFra2FyYUBnZS5jb218NDY3MDk1MHwxNTUxOTQzMDI5 . NAML http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://r.789695.n4.nabble.com/Filter-Dataframe-for-Alarm-for-particular-column-s-tp4670950p4674211.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list 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] Filter Dataframe for Alarm for particular column(s).
Ok. I got it. From: Akkara, Antony (GE Energy, Non-GE) Sent: Wednesday, August 21, 2013 3:52 PM To: 'arun kirshna [via R]' Subject: RE: Filter Dataframe for Alarm for particular column(s). What will be the code, if we required all the row number ? Thanks, Antony. From: arun kirshna [via R] [mailto:ml-node+s789695n467097...@n4.nabble.com] Sent: Saturday, July 06, 2013 12:54 AM To: Akkara, Antony (GE Power Water, Non-GE) Subject: Re: Filter Dataframe for Alarm for particular column(s). Hi, May be this helps: If you had showed your solution, it would be easier to compare. res-data.frame(lapply(sapply(MyDF[,c(2,4)],function(x) {x1-which(c(0,diff(x))0);x1[length(x1)==0]-0;x1}),`[`,1)) res # TNH BIX #1 3 9 #Speed set.seed(24) MyDFNew- data.frame(TNH=sample(0:1,1e6,replace=TRUE),BIX=sample(0:1,1e6,replace=TRUE)) system.time(res1-data.frame(lapply(sapply(MyDFNew,function(x) {x1-which(c(0,diff(x))0);x1[length(x1)==0]-0;x1}),`[`,1))) # user system elapsed # 0.364 0.000 0.363 res1 # TNH BIX #1 7 2 MyDFNew[1:10,] # TNH BIX #10 1 #20 0 #31 1 #41 1 #51 0 #61 0 #70 1 #81 1 #91 1 #10 0 0 A.K. Hi, Hi here i have a dataframe called MyDF. a-c(1,1,1,1,1,0,0,0,1,1) b-c(1,1,0,1,1,0,0,0,1,1) c-c(1,1,1,1,1,1,1,0,1,1) d-c(1,1,1,1,1,1,1,1,0,1) MyDF-data.frame(DWATT=a,TNH=b,CSGV=c,BIX=d) My requirement is, here i need a function - to get for a particular row number(s), when particular column(s) value change from one-to-zero (for the first change). Suppose there is no change is happening then it should return Zero For example, Using MyDF, DWATT TNH CSGV BIX 1 11 1 1 11 1 1 01 1 1 11 1 1 11 1 0 01 1 0 01 1 0 00 1 1 11 0 1 11 1 Here i want to know, the row number where TNH-column and BIX-column values change happening from one-to-zero for the first time. Note:- Suppose there is no change is happening then it should return Zero Answer should be a dataframe with single row. So here answer should return a dataframe like this. TNH BIX -- 3 9 i used some ways to get a solution using loops. But there is a bulk files with bulk rows to process. So performace is most important. Could someone please suggest better ideas ? Thanks, Antony. __ [hidden email] mailing list 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. If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/Filter-Dataframe-for-Alarm-for-particular-column-s-tp4670950p4670970.html To unsubscribe from Filter Dataframe for Alarm for particular column(s)., click here http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4670950code=YW50b255LmFra2FyYUBnZS5jb218NDY3MDk1MHwxNTUxOTQzMDI5 . NAML http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://r.789695.n4.nabble.com/Filter-Dataframe-for-Alarm-for-particular-column-s-tp4670950p4674212.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list 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] Select csv files by choosing datetime
Hi, how can we read particular files from a path ? - i mean, i need to read csv files which is created between two date and time. Here i need to get filename along with path. Thanks, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Select-csv-files-by-choosing-datetime-tp4672023.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Filter Dataframe for Alarm for particular column(s).
Hi Arun, Thanks for the solution it really works !. But how can we avoid even lappy() and sappy(). Actually any way to do with ts() ? Thanks, Antony. From: arun kirshna [via R] [mailto:ml-node+s789695n467097...@n4.nabble.com] Sent: Saturday, July 06, 2013 12:54 AM To: Akkara, Antony (GE Power Water, Non-GE) Subject: Re: Filter Dataframe for Alarm for particular column(s). Hi, May be this helps: If you had showed your solution, it would be easier to compare. res-data.frame(lapply(sapply(MyDF[,c(2,4)],function(x) {x1-which(c(0,diff(x))0);x1[length(x1)==0]-0;x1}),`[`,1)) res # TNH BIX #1 3 9 #Speed set.seed(24) MyDFNew- data.frame(TNH=sample(0:1,1e6,replace=TRUE),BIX=sample(0:1,1e6,replace=TRUE)) system.time(res1-data.frame(lapply(sapply(MyDFNew,function(x) {x1-which(c(0,diff(x))0);x1[length(x1)==0]-0;x1}),`[`,1))) # user system elapsed # 0.364 0.000 0.363 res1 # TNH BIX #1 7 2 MyDFNew[1:10,] # TNH BIX #10 1 #20 0 #31 1 #41 1 #51 0 #61 0 #70 1 #81 1 #91 1 #10 0 0 A.K. Hi, Hi here i have a dataframe called MyDF. a-c(1,1,1,1,1,0,0,0,1,1) b-c(1,1,0,1,1,0,0,0,1,1) c-c(1,1,1,1,1,1,1,0,1,1) d-c(1,1,1,1,1,1,1,1,0,1) MyDF-data.frame(DWATT=a,TNH=b,CSGV=c,BIX=d) My requirement is, here i need a function - to get for a particular row number(s), when particular column(s) value change from one-to-zero (for the first change). Suppose there is no change is happening then it should return Zero For example, Using MyDF, DWATT TNH CSGV BIX 1 11 1 1 11 1 1 01 1 1 11 1 1 11 1 0 01 1 0 01 1 0 00 1 1 11 0 1 11 1 Here i want to know, the row number where TNH-column and BIX-column values change happening from one-to-zero for the first time. Note:- Suppose there is no change is happening then it should return Zero Answer should be a dataframe with single row. So here answer should return a dataframe like this. TNH BIX -- 3 9 i used some ways to get a solution using loops. But there is a bulk files with bulk rows to process. So performace is most important. Could someone please suggest better ideas ? Thanks, Antony. __ [hidden email] mailing list 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. If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/Filter-Dataframe-for-Alarm-for-particular-column-s-tp4670950p4670970.html To unsubscribe from Filter Dataframe for Alarm for particular column(s)., click here http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4670950code=YW50b255LmFra2FyYUBnZS5jb218NDY3MDk1MHwxNTUxOTQzMDI5 . NAML http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://r.789695.n4.nabble.com/Filter-Dataframe-for-Alarm-for-particular-column-s-tp4670950p4671203.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list 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] Filter Dataframe for Alarm for each column.
Hi here i have a dataframe called MyDF. a-c(1,1,1,1,1,0,0,0,1,1) b-c(1,1,0,1,1,0,0,0,1,1) c-c(1,1,1,1,1,1,1,0,1,1) d-c(1,1,1,1,1,1,1,1,0,1) MyDF-data.frame(DWATT=a,TNH=b,CSGV=c,BIX=d) My requirement is, here i need a function - to get for a particular row number(s), when particular column(s) value change from zero to one (for the first change). For example, Using MyDF, DWATT TNH CSGV BIX 1 11 1 1 11 1 1 01 1 1 11 1 1 11 1 0 01 1 0 01 1 0 00 1 1 11 0 1 11 1 Here i want to know, the row number where TNH-column and BIX-column values change happening from one-to-zero for the first time. Answer should be a dataframe with single row. So here answer should return a dataframe like this. TNH BIX -- 3 9 i used some ways to get a solution using loops. But there is a bulk files with bulk rows to process. So performace is most important. Could someone please suggest better ideas ? Thanks, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Filter-Dataframe-for-Alarm-for-each-column-tp4670950.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Search for Matching word in a Dataframe
Hi Here i have a dataframe called MyDat. MyDat- data.frame(NAME = c(ANTONY001, ARUN002, AKBAR003, JONATHAN004, PETER005, AVATAR006, YULIJIE007, RAM008, DESILVA009), COL_A = c(0, 0, 0, 1, 0, 1, 2, 3, 1), COL_B = c(0, 3, 0, 3, 3, 1, 0, 1, 2), COL_C = c(1, 2, 3, 1, 2, 3, 1, 2, 3), stringsAsFactors=FALSE) and here my requirement what is, i need to get the row number, where the NAME column matches with selection criteria. For eg:- If i give NAME = ARUN, It should select row no: 2 where ARUN002 comes. i tried with this way nRow-which(ARUN==MyDat[,1]) - But here, the row number will select only the NAME column value match exactly, otherwise it wont select. My requirment is, it should select the row number(s), where the searching word should match atleast. Exact match is not compulsory. - Thanks in Advance. Antony. -- View this message in context: http://r.789695.n4.nabble.com/Search-for-Matching-word-in-a-Dataframe-tp4669426.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Get count by day for particular coulmn
here i have a dataframe for eg:- DATETIMECOL_A COL_B COL_C COL_D 1/1/2007 0:01 0 3 0 0 1/1/2007 0:02 0 0 3 0 1/1/2007 0:03 0 3 0 0 ... . ... ... 1/2/20070 0 3 0 1/2/2007 0:01 0 3 4 0 1/2/2007 0:02 0 3 0 0 ... . ... ... 1/3/20070 0 0 0 1/3/2007 0:01 0 0 4 0 1/3/2007 0:02 0 3 0 0 ... . ... ... My requirement what is, i have to get the count for each day where COL_B = 3 For eg:- here i need to get like DATETIME COUNT(COL_B=3) 1/1/2007 2 1/2/2007 3 1/3/2007 1 = = and this way i tried to get, MyDF[MyDF[DATETIME]==1/2/2007] --- here this only select the row where DATETIME - column coming as 1/2/2007 - date and not selecting other rows where same date is coming (eg:- 1/1/2007 0:01). And here i need to get the complete records for that particular day, when i give date without giving timestamp. - Could anyone give a help ASAP ? - Thanks Antony. -- View this message in context: http://r.789695.n4.nabble.com/Get-count-by-day-for-particular-coulmn-tp4668915.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Read Content from URL to XML format
Hi John , I tried this code == library(RCurl) library(XML) script - getURL(www.r-bloggers.com) and now getting an error like , âError in function (type, msg, asError = TRUE) : couldn't connect to hostâ From: John Kane [via R] [mailto:ml-node+s789695n4660616...@n4.nabble.com] Sent: Thursday, March 07, 2013 8:53 PM To: Akkara, Antony (GE Power Water, Non-GE) Subject: Re: Read Content from URL to XML format Perhaps http://stackoverflow.com/questions/1395528/scraping-html-tables-into-r-data-frames-using-the-xml-package may be of help John Kane Kingston ON Canada -Original Message- From: [hidden email] Sent: Wed, 6 Mar 2013 19:23:24 -0800 (PST) To: [hidden email] Subject: [R] Read Content from URL to XML format Hi, i want to know how to read a table values from a URL and get it as XML content. Could anyone please help me out ASAP ? Thanks, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Read-Content-from-URL-to-XML-format-tp4660561.html Sent from the R help mailing list archive at Nabble.com. __ [hidden email] mailing list 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. TRY FREE IM TOOLPACK at http://www.imtoolpack.com/default.aspx?rc=if5 Capture screenshots, upload images, edit and send them to your friends through IMs, post on Twitter®, Facebook®, MySpaceâ¢, LinkedIn® â FAST! __ [hidden email] mailing list 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. If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/Read-Table-Content-from-URL-to-XML-format-tp4660561p4660616.html To unsubscribe from Read Table Content from URL to XML format, click here http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4660561code=YW50b255LmFra2FyYUBnZS5jb218NDY2MDU2MXwxNTUxOTQzMDI5 . NAML http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://r.789695.n4.nabble.com/Read-Table-Content-from-URL-to-XML-format-tp4660561p4660687.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list 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 Content from URL to XML format
Hi, i want to know how to read a table values from a URL and get it as XML content. Could anyone please help me out ASAP ? Thanks, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Read-Content-from-URL-to-XML-format-tp4660561.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Access data from URL
Hi all, i need a small help that i want to access data from a url. i tried with read.table(URL,header=TRUE) - but getting errors. actually no idea that how can be done. I am in new in this function as well as in R. Could anyone please help me out, how we can do it without installing any packages ? - Thanks Antony. -- View this message in context: http://r.789695.n4.nabble.com/Access-data-from-URL-tp4656154.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Connect R with SQLSERVER
Hi, Here im not able to connect with MS-SQLSERVER database with *.R-File. Previously i was able to do in R in different machine and configuration was R Ver-2.11.1 Package Installed : RODBC_1.3-2 And now where im doinig now there the same code im trying to execute but its not connecting. configuration is, R Ver-2.12 Package Installed : RODBC_1.3-2 - here iam trying to install (RODBC_1.3-6) which will support for R 2.12. But getting error while do installation. ERROR I GETTING== C:\Documents and Settings\mduserR CMD INSTALL C:\Program Files\R\R-2.12.0\bin\ RODBC_1.3-6.tar.gz * installing to library 'C:/PROGRA~1/R/R-212~1.0/library' * installing *source* package 'RODBC' ... ** libs gcc -IC:/PROGRA~1/R/R-212~1.0/include -I.-O3 -Wall -std=gnu99 -c RODB C.c -o RODBC.o gcc: not found make: *** [RODBC.o] Error 127 ERROR: compilation failed for package 'RODBC' * removing 'C:/PROGRA~1/R/R-212~1.0/library/RODBC' == - Could anyone please help me ? Thanks Antony -- View this message in context: http://r.789695.n4.nabble.com/Connect-R-with-SQLSERVER-tp4650822.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Create BATCH file
Hi, I have a .R file written many functions into that. My requirement what is, i need to create a batch file for this. No idea, how to create it. Tried it many other ways, but no result !. Could anyone please help me out ? Thanks. Antony. -- View this message in context: http://r.789695.n4.nabble.com/Create-BATCH-file-tp4650277.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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] Send Email from R
THE ERROR WAS : ERROR: compilation failed for package 'base64' Problem is with version. Any idea, how can we do this without any packages ? - Thanks Antony. -- View this message in context: http://r.789695.n4.nabble.com/Send-Email-from-R-tp4645565p4649585.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list 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.