Re: [R] Missing Values in Table Statement

2015-06-16 Thread PIKAL Petr
nsole. It will create object named temp as you can easily check. Cheers Petr > -Original Message- > From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Shivi82 > Sent: Tuesday, June 16, 2015 8:20 AM > To: r-help@r-project.org > Subject: Re: [R] Missing Values i

Re: [R] Missing Values in Table Statement

2015-06-15 Thread Shivi82
HI Petr,There is no reason for holding back the data from dput format. The reason for not supplying is that i tried multiple times but it the output what comes is not really user friendly is what i think.Not sure if i am missing a trick somewhere as i tried both the dput and dget options. Though as

Re: [R] Missing Values in Table Statement

2015-06-15 Thread PIKAL Petr
; table(is.na(test)) FALSE TRUE 7 3 test[5:7]<-"" str(test) chr [1:10] "b" "a" "d" "e" "" "" "" "d" "d" "c" table(is.na(test)) FALSE 10 Cheers Petr > -----Origina

Re: [R] Missing Values in Table Statement

2015-06-12 Thread Shivi82
HI Don, This is the exact result i need. However in my case i am not getting any value under TRUE whereas FALSE captures total observations in each variable. Please find the syntax and output from the code: table(test$ORIGIN_NAME,is.na(test$SCH_TIME)) Output FALSE

Re: [R] Missing Values in Table Statement

2015-06-12 Thread MacQueen, Don
Maybe it will help if I create some fake data to illustrate what I think you want: set.seed(25) tmp <- data.frame(origin=sample( letters[1:3], 25, replace=TRUE), schd= sample( 1:5, 25, replace=TRUE) ) tmp$schd[ c(5,7,18,22) ] <- NA print(tmp) table( tmp$origi

Re: [R] Missing Values in Table Statement

2015-06-12 Thread John Kane
If possible always supply data in dput() form. John Kane Kingston ON Canada > Kindly let me know if i need to supply dput data. Thank you!!! FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!

Re: [R] Missing Values in Table Statement

2015-06-12 Thread Shivi82
Hi Petr, Please see the output from dget as follows. ORIGIN ORIGIN_NAME DESTINATION DESTINATION_NM RPS_NO VENDOR_NAME CR_DT SCHD_MRKT VHL_NO vhl_cap 1 DLI11DELHI-11 NDA50NOIDA-50 1350760

Re: [R] Missing Values in Table Statement

2015-06-11 Thread PIKAL Petr
Hi > -Original Message- > From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Shivi82 > Sent: Friday, June 12, 2015 8:28 AM > To: r-help@r-project.org > Subject: Re: [R] Missing Values in Table Statement > > Hi Petr, > > Probably i did not explain my

Re: [R] Missing Values in Table Statement

2015-06-11 Thread Shivi82
Hi Petr, Probably i did not explain my scenario clearly. table(test$ORIGIN_NAME,is.na(test$SCH_TIME)) is the syntax with which i am trying to find per destination wise how many instances are there where system failed to enter the scheduled delivery time & there are multiple cases of these. I am e

Re: [R] Missing Values in Table Statement

2015-06-11 Thread PIKAL Petr
Hi > -Original Message- > From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Shivi82 > Sent: Friday, June 12, 2015 7:41 AM > To: r-help@r-project.org > Subject: [R] Missing Values in Table Statement > > HI All, > > I need help on 2 issues as highlighted below" > > A)I have 2 v