Hi,
Is there a function I can use on my dataframe to give me a concise summary of
variables that are NA,blank,etc? Basically all Null values, Empty strings,
white space, blank values. Ideally it would look something like the below:
# it should only includes the fields with NAs, blanks, etc. Added bonus would
be to include column Index.
#Valid Records = records that are not NA, blank,etc
#ColIndex - what place is column in the original dataframe...1,2,3, ...xth
Valid Records Null (NA?) Empty String White
Space Blank Value ColIndex
Var1 52 8
2
Var2 40 20
10 10 3
Var3 58
2
20
..
I now there is summary() but I am not sure if that always displays NAs and
blanks especially with factor variables that have several levels (lumps them in
'Other' when I run the entire dataframe). In these instances I can run the
individual field separately and see all levels but that would be inefficient to
do for a dataframe with over 50 variables.
Dan
[[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, minimal, self-contained, reproducible code.
