[R] Subtracting TimeStamps

2011-06-23 Thread sumit gupta
Hi All,, I am new to R and having a problem dealing with timestamps. I have 2 columns in my table . Both of these have timestamps value in format 06/22/11 05:34 PM . I want to calculate the difference in these 2 columns ( in minutes) and save it as a 3rd column. Can anyone help ? Thanks Sumit

[R] Number of cluster

2010-05-06 Thread sumit gupta
Hi, Can anyone tell me how to find number of cluster for a data set. I have a data set in following format Group var1 var2 var3 A 1 2 3 A 1 2 3 A 1 2 3 B... B... C C

[R] Importing large data set from teradata

2010-04-08 Thread sumit gupta
Hi, I want to import data from teradata.Data set is very large in size , it has around 1 million rows and 40 columns. Could anyone tell me an efficient and fast way to import data sets with this size. Thanks. Sumit [[alternative HTML version deleted]]

[R] Exporting data to .xlsx file

2010-04-07 Thread sumit gupta
I imported data from teradata to R data frames.Now i want to export this data to .xlsx file ( not .xls since it doesn't support large data set). I have tried dataframes2xls package but it needs python/perl which I don't have on my computer. Could any one help me resolve this issue. Thanks

[R] How to import data from teradata

2010-04-06 Thread sumit gupta
Hello All, I am very new to the R and i want to know how to connect to the teradata in R and import data from there. Currently I am using SAS to import data and i use the following syntax to connect to teradata. *Proc Sql; connect to odbc (dsn=teradata username = '**' password =

[R] 3D histogram

2008-06-20 Thread sumit gupta
Hii.. Could anyone please tell me how to draw 3D histogram in R I have a 20X3 matirx. Now I want 2 of the variable on X and Y axis .And Height of the bar should denote the value of third variable. Thanx Sumit [[alternative HTML version deleted]]

[R] Problem in Binning of a data set

2008-06-18 Thread sumit gupta
Hello, I am having problem with binning the data. I have a 50X3 matrix and I binned the data for all the 3 columns. Using table command I got the total no. of elements in a particular bin. Could you please tell me how to see that what all elements are there in a particular bin and then create a

[R] Fwd: Hello

2008-06-11 Thread sumit gupta
depicting the average monetary value of that box. Hope this clears the problem I am facing. Thank you. Regards, Sumit On 6/11/08, Petr PIKAL [EMAIL PROTECTED] wrote: sumit gupta [EMAIL PROTECTED] napsal dne 11.06.2008 07:53:54: Hello thanx for the info.. I still have tthe doubt regarding

[R] Hello

2008-06-10 Thread sumit gupta
Hello, I am facing a problem in drawing heat map using R. I have a 70X3 matrix and I want to draw a heat map with 1 coloumn on X axis another on Y axis and want to show the value of 3rd coloumn using heat colours. Could you please help me with this . Thank you . Regards, Sumit