An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111116/2bcdc27c/attachment.pl>
read.table : fill missing entry with "unAvailable" [edit]
3 messages · Mary Kindall, R. Michael Weylandt
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111116/47304740/attachment.pl>
It's going to depend on how the data missing-ness is represented in the table. If you have a csv like 1,2,3 1,,3 4,5,6 You automatically get an NA after using read.csv() -- this can be omitted with the na.omit() command if desired. If missingness is somehow encoded other than an empty spot, it may be a bit harder. Michael
On Wed, Nov 16, 2011 at 4:26 PM, Mary Kindall <mary.kindall at gmail.com> wrote:
I am very sorry for multiple mails. Hi R users, I try to read a data file (tab delimited format) in which some of the entries in a particular field are missing. Is it possible to fill the unavailable data with 'UnAvailable' string while performing read.table() Something like df = read.table(DataFile, header=FALSE, ?fill_missing_entry = 'unAvailable') Or remove the the complete row in which the missing entry appear. thanks -- ------------- Mary Kindall Yorktown Heights, NY USA -- ------------- Mary Kindall Yorktown Heights, NY USA ? ? ? ?[[alternative HTML version deleted]]
______________________________________________ R-help at 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.