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-

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

[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 c

[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: h

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 kirsh

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 particula

[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-t

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, Anto

[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)

[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

[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 ... . ... ...

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+s789695n4660

[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 archi

[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 package

[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. configur

[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.

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 mail