> > Perhaps something like this will work. > > df[!(rowSums(is.na(df))==NCOL(df)),]
Or df[complete.cases(df),] Regards Petr > > Michael > > On Fri, Nov 4, 2011 at 9:27 AM, Jose Iparraguirre > <jose.iparragui...@ageuk.org.uk> wrote: > > Hi, > > > > Imagine I have the following data frame: > > > >> a <- c(1,NA,3) > >> b <- c(2,NA,NA) > >> c <- data.frame(cbind(a,b)) > >> c > > a b > > 1 1 2 > > 2 NA NA > > 3 3 NA > > > > I want to delete the second row. If I use na.omit, that would also > affect the third row. I tried to use a loop and an ifelse clause with > is.na to get R identify that row in which all records are missing, as > opposed to the first row in which no records are missing or the third one, > in which only one record is missing. How can I get R identify the row in > which all records are missing? Or, how can I get R delete/omit only this row? > > Thanks in advance, > > > > José > > > > > > José Iparraguirre > > Chief Economist > > Age UK > > > > T 020 303 31482 > > E jose.iparragui...@ageuk.org.uk<mailto:jose.iparragui...@ageuk.org.uk > > > > > Tavis House, 1- 6 Tavistock Square > > London, WC1H 9NB > > www.ageuk.org.uk<http://www.ageuk.org.uk> | ageukblog.org.uk<http:// > ageukblog.org.uk/> | @AgeUKPA<http://twitter.com/ageukpa> > > > > > > Age UK Improving later life > > > > www.ageuk.org.uk > > > > > > > > > > > > ------------------------------- > > > > Age UK is a registered charity and company limited by guarantee, > (registered charity number 1128267, registered company number 6825798). > Registered office: Tavis House, 1-6 Tavistock Square, London WC1H 9NA. > > > > For the purposes of promoting Age UK Insurance, Age UK is an Appointed > Representative of Age UK Enterprises Limited, Age UK is an Introducer > Appointed Representative of JLT Benefit Solutions Limited and Simplyhealth > Access for the purposes of introducing potential annuity and health cash > plans customers respectively. Age UK Enterprises Limited, JLT Benefit > Solutions Limited and Simplyhealth Access are all authorised and regulated > by the Financial Services Authority. > > > > > > > > > > > > ------------------------------ > > > > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they are > addressed. If you receive a message in error, please advise the sender and > delete immediately. > > > > > > > > Except where this email is sent in the usual course of our business, any > opinions expressed in this email are those of the author and do not > necessarily reflect the opinions of Age UK or its subsidiaries and > associated companies. Age UK monitors all e-mail transmissions passing > through its network and may block or modify mails which are deemed to be unsuitable. > > > > > > > > > > > > Age Concern England (charity number 261794) and Help the Aged (charity > number 272786) and their trading and other associated companies merged on > 1st April 2009. Together they have formed the Age UK Group, dedicated to > improving the lives of people in later life. The three national Age > Concerns in Scotland, Northern Ireland and Wales have also merged with > Help the Aged in these nations to form three registered charities: Age > Scotland, Age NI, Age Cymru. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [[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. > > > > > > ______________________________________________ > 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. ______________________________________________ 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.
