[R] pie chart

2011-09-08 Thread Mohan L
draw pie chart for the above data. How to split rawdata into : con <- c("US","UK","Ind","Germany","France"); total <- (10,12,4,14,8) Any help will be appreciate. Thanks & Rg Mohan L __ R-he

[R] help to merge two data frame if name matches

2010-11-09 Thread Mohan L
mount1200 80 0 00.0000.00 If in case the name in the "main" data frame does not there in the "other" data frame, simple I want to add zero to ip,bsent,breceived value. I hope this can be done with R. Any help will appricated. Thanks for you

[R] help to add a new column filled with value 1

2010-11-09 Thread Mohan L
Dear All, I have a data frame with 5 column and 201 row data. I want to add one more column between column 1 and 2 with value of 1. So the new column has to be the second column filled with 1. Any help will be appreciated. Thanks for your time. Thanks & Rg Moh

[R] help to sum up data frame

2010-11-07 Thread Mohan L
want to sum up the similar name into one row, like : name ip Bsent Breceived a62.43 20.83 b9 28.40 26.72 c d I need help to sum up. Thanks for your time. Thanks & Rg Mohan L __ R-he

[R] using variable in rmysql query

2010-11-07 Thread Mohan L
I am trying to replace the string some this like, but it not working: > id <- dbGetQuery(con1,"SELECT id FROM tenants WHERE name LIKE '%str%'") I need help to replace the value of str . Any help will really appreciated . Thanks for your time. Mohan L ___

[R] Help required to remove \\N

2010-11-06 Thread Mohan L
Demo ROOT admin Stopped The first column contain the \\n up to 19 row. I need to replace the \\N value to "Blankspace" . Any help will really appreciated. Thanks for your time. Thanks & Rg Mohan L __ R-help@r-project.org m

Re: [R] setting the current working directory to the location of the source file

2010-06-10 Thread Mohan L
there a better, cleaner way? > > Hi, I am using some thing like this to setup working directory: ##set working directory pwd <- getwd() if (!is.null(pwd)) { setwd(pwd) } else { print("Directory not found&qu

[R] Re :help to aggregate data

2010-06-09 Thread Mohan L
need like this : Domaindesc05/01/10 05/02/10 05/03/10 xxx 5793 29 yyy 8746 122 zzz Any help will be greatly appreciated. Thanks for your time. Mohan L [[alt

[R] Re : help to replace variable value

2010-05-28 Thread Mohan L
Dear All, I have a data frame "data" with Jan , Feb as column. I using like this data$Jan to take Jan column. I have the Jan in another variable var1 <- "Jan" data$var1 I need to replace the variable value there . Any help will be greatly appreciate

Re: [R] Factor to Numeric

2010-05-26 Thread Mohan L
function to total . Any help. Thanks & Rg Mohan L [[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-

[R] Factor to Numeric

2010-05-26 Thread Mohan L
;122",..: 1 13 1 1 1 12 8 2 1 4 ... $ June : Factor w/ 18 levels "0","1","10","119",..: 1 14 1 1 9 10 9 2 1 4 ... $ May : Factor w/ 20 levels "0","1","10","111",..: 2 19 1 1 10 15 1 1 1 5 ... $ September: Factor

Re: [R] help required to melt a data frame

2010-05-25 Thread Mohan L
s for your help. Thanks & Rg Mohan L [[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

Re: [R] help required to melt a data frame

2010-05-25 Thread Mohan L
ll = 0, fun = length) It show some thing like this : Using Months as value column. Use the value argument to cast to override this choice Error in `[.data.frame`(data, , variables, drop = FALSE) : undefined columns selected Thanks Mohan L [[alternative HTML version deleted]] __

Re: [R] help required to melt a data frame

2010-05-25 Thread Mohan L
> zzz 10 > > What do those numbers represent? > > Hadley > > The raw data is real estate & property portal data. the numbers represent how many 1 Bedroom house has registered in xxx state on particular months. Then we will normalize the data and plot the graph for trend

[R] help required to melt a data frame

2010-05-25 Thread Mohan L
Feb 18 zzz 3 Months Feb I trying to get a new data frame for 1 bedroom using cast. But I am not able to get the below data for 1 Bedroom using cost. State Jan Feb xxx 20 yyy 22 zzz 10 I not able to understand how to cost it. any help will be greatly appreciated.

[R] rounding up to nearest integer

2010-05-24 Thread Mohan L
ay to round up the nearest integer. any help will be greatly appropriated. Thanks & Rg Mohan L [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posti

Re: [R] help required state wise count

2010-05-24 Thread Mohan L
>> >> Hi Mohan, > Try this: > > table(dummy$State,dummy$Months) > > Jim > > Thanks for your time. table(dummy$State,dummy$Months) in this case the state column becomes the row index. I want the state name as the first column. There may be a w

[R] help required state wise count

2010-05-24 Thread Mohan L
nks & Rg Mohan L [[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, minima

[R] Re : Indexing array to 1000

2010-05-22 Thread Mohan L
1 1000. [2,]2 1387.5911 [3,]3 944.6275 [4,] 4 811.7034 [5,]5 815.4471 [6,]6 675.0524 [7,]7 635.1702 [8,]8 782.6195 [9,]9 855.2461 any help will be greatly appreciated. Thanks & Rg Mohan L [[alternative HTML version deleted]] ___

Re: [R] help to indexing data frame

2010-05-20 Thread Mohan L
On Fri, May 21, 2010 at 11:27 AM, Mohan L wrote: > > Dear All, > > I have data some thing like this: > > > sample > StateJan Feb Mar > A 1 1 1 > B1298 12931294 > C00 0 > D5

[R] help to indexing data frame

2010-05-20 Thread Mohan L
se for me . Any help will be greatly appreciated. Thanks & Rg Mohan L [[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-proj

[R] Re : Manipulating Data Frames

2010-05-20 Thread Mohan L
ar[1]-Jan[1])*weightage[1])+Jan[1]) 2 BBB 1298 (((Feb[2]-Jan[2])*weightage[2])+Jan[2]) (((Mar[2]-Jan[1])*weightage[2])+Ja[1]) 3 CCC 0 4 DDD5 5 EEE 18 6 FFF 68 I am struggling with this . I have framed a logic using for loop. But it seems me very bad logic. Any help will be

Re: [R] Re : Adding column sum to new row in data frame

2010-05-19 Thread Mohan L
fferent methods for > rbind and what its behavior will be if it is using the default > method). This may not be an issue, but it would hamper any subsequent > calculations you may wish to perform on your data. > Thanks for your great help. Mohan L [[alternative HTML versio

Re: [R] Re : Adding column sum to new row in data frame

2010-05-19 Thread Mohan L
1212 1244 1158 845 3 CCC 00012 1 4 DDD5 11 17 15 10 9 5 EEE 18 28 27 23 23 16 6 FFF 68 152 184 135 111 86 7 Total 1390 1387 1440 1420 1306 957 I think I am doing right. If I miss understood anything. Please guide me I am beginer to R.

Re: [R] Re : Adding column sum to new row in data frame

2010-05-19 Thread Mohan L
135 111 86 7 1390 1387 1440 1420 1306 957 How to safely avoid this warning massage? Now I have instead of "Total" in last row State column. How to I replace it as "Total"? Thanks & Rg Mohan L [[alternative HTML version deleted]]

[R] Re : Adding column sum to new row in data frame

2010-05-19 Thread Mohan L
apply(x,sum,na.rm=T) > Total Jan Feb Mar Apr May Jun 1390 1387 1440 1420 1306 957 I hope there may be alternative way. Any help will be appreciated. Thanks & Rg Mohan L [[alternative HTML version deleted]] __ R-help@r-proj

[R] Re : append new line in existing graph

2010-05-17 Thread Mohan L
not exist, my script has to create the file. If the bmtrend.pdf file is already exist, I want to append new line in existing file. any help would be greatly appreciated. Thanks for you time. Mohan L [[alternative HTML version deleted]] __ R-

Re: [R] extract required data from already read data

2010-05-06 Thread Mohan L
want to know how to pass the argument to my sample.R, some this like > source(sample.R, xxx,FeMale) Is it possible? any link will greatly appreciated. Thanks & Rg Mohan L [[alternative HTML version deleted]] __ R-help@r-project.or

[R] extract required data from already read data

2010-05-06 Thread Mohan L
the calculation , eg : # if both are true if(Domain == xxx && sex==FeMale) I need the data in another variable, like this 1 01/11/09xxx FeMale 25 2 2 01/11/09xxx FeMale 35 4 3 02/11/09xxx FeMale 29 1 I have failed to achieve it . any help would grea

[R] make a column from the row names

2010-05-04 Thread Mohan L
Index 119.759.75*100 224.504.50*100 334.504.50*100 448.678.67*100 How to achieve it? Any help will be appreciated. Thanks & Rg Mohan L [[alternative HTML version deleted]] _

Re: [R] Re :argument is not numeric or logical

2010-05-02 Thread Mohan L
65358 15.84970 16.58600 16.20743 07/11/09 00:00 18.52379 But still it will not work : > avglog <- with(assame,tapply(as.numeric(levels(Login)[as.integer(Login)]),stdate,mean)) Error in tapply(as.numeric(levels(Login)[as.integer(Login)]), stdate, :

Re: [R] Re :argument is not numeric or logical

2010-05-02 Thread Mohan L
/11/09 00:00 05/11/09 00:00 145.0176 135.5207 133.0390 131.1457 132.3732 06/11/09 00:00 07/11/09 00:00 129.6357 133.4521 Am I right ? Thanks & Rg Mohan L [[alternative HTML version deleted]] __ R-

Re: [R] Re :argument is not numeric or logical

2010-05-02 Thread Mohan L
tdate, mean)) Warning message: In tapply(as.numeric(as.character(sample$Login)), stdate, mean) : NAs introduced by coercion > avglog 01/11/09 00:00 02/11/09 00:00 03/11/09 00:00 04/11/09 00:00 05/11/09 00:00 22.04866 16.65358 NA 15.84970 16.58600 06/11/09 00:00 07/11/

Re: [R] Re :argument is not numeric or logical

2010-05-02 Thread Mohan L
the average Login for first day(1/11/2009) , from this average I have to calculate index divisor(ID). Then I have to calculate the average Login for all 7 days and need to multiple each day Login average with index divisor(ID), like this stdate LoginAverage Index 1/11/2009

[R] Re :argument is not numeric or logical

2010-05-02 Thread Mohan L
NA NA How to fix this issue? Thanks & Rg Mohan L [[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-

[R] Average Login based on date

2010-05-01 Thread Mohan L
Male 31 1 30 04/11/09yyy FeMale 29 0 I need to fine the average login on 01/11/09 and 02/11/09 etc... like below stdate AverageLogin 01/11/09 9.75 02/11/09 . 03/11/09 ... How do I find the average Login based on date?

Re: [R] Re :reading large file

2010-04-30 Thread Mohan L
On Sat, May 1, 2010 at 11:55 AM, Tal Galili wrote: > Hi Mohan, > Check: > > dim(bmtrend) > > If the output is like the dimension of your data, then it would appear you > succeeded in reading in the data :) > Yes . You are right. It reads all the data

[R] Re :

2010-04-30 Thread Mohan L
",head=TRUE,sep=",") > bmtrend will display something in the middle of display [ reached get Option("max.print") -- omitted 30061 rows ]] It will not show the full list of data. please suggest me best way to read large file? Thanks & Rg Mohan L

[R] Re :reading large file

2010-04-30 Thread Mohan L
On Sat, May 1, 2010 at 11:02 AM, Mohan L wrote: > Hi All, > > I am new to R and the mailing list. > > I have a data file (.xls) format with little bit large (16 column,35000 > rows ) data file. I am trying to read this file for calculation. I have > converted the file into