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
BAHADURGARH 15
BAREILLY 44
BAWAL 34
DELHI-11 2446
DELHI-39 170
DELHI-40 86
DELHI NCR-12 1925
The data from str is attached:
data.frame': 10765 obs. of 18 variables:
$ ORIGIN : chr "DLI11" "DLI11" "NDA50" "NDA50" ...
$ ORIGIN_NAME : chr "DELHI-11" "DELHI-11" "NOIDA-50" "NOIDA-50" ...
$ DESTINATION : chr "NDA50" "NDA50" "DLI11" "NDA11" ...
$ DESTINATION_NM : chr "NOIDA-50" "NOIDA-50" "DELHI-11" "NOIDA-11" ...
$ RPS_NO : int 1350760 1366368 1352692 1354642 1354642 1349180
1349180 1356091 1348591 1348591 ...
$ VENDOR_NAME : chr "RAJIV GAUTAM" "RAJIV GAUTAM" "RAJIV GAUTAM" "RAJIV
GAUTAM" ...
$ CR_DT : chr "13-Mar-15" "31-Mar-15" "15-Mar-15" "17-Mar-15" ...
$ SCHD_MRKT : chr "SCHEDULE" "SCHEDULE" "SCHEDULE" "MARKET" ...
$ VHL_NO : chr "HR63A0931" "HR63A0931" "HR63A0931" "HR63A0931" ...
$ vhl_cap : int 8 8 8 8 8 8 8 8 8 8 ...
$ SCH_TIME : chr "6:00" "6:00" "21:30" "" ...
$ ACTUAL_DEP_DATE: chr "13/03/2015" "31/03/2015" "15/03/2015" "17/03/2015"
...
$ ACTUAL_DEP_TIME: chr "6:30" "4:05" "13:37" "20:15" ...
$ WAYBILLS : chr "-" "-" "-" "3" ...
$ TOTAL_PKG : int 0 0 0 40 256 6 0 0 16 427 ...
$ ACTUAL_WT : int 0 0 0 744 3419 65 0 0 193 7223 ...
$ CHG_WT : int 0 0 0 770 3730 70 0 0 210 7310 ...
$ RTE_CD : chr "DELHI-11-NOIDA-50(DLI11-NDA50)"
"DELHI-11-NOIDA-50(DLI11-NDA50)" "NOIDA-50-DELHI-11(NDA50-DLI11)"
"NOIDA-50-DELHI-11(NDA50-NDA11-DLI11)"
Scheduled time here is character, could this be the reason for the incorrect
result.
Thanks, Shivi
--
View this message in context:
http://r.789695.n4.nabble.com/Missing-Values-in-Table-Statement-tp4708534p4708593.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.
