[R] How to delete only those rows in a dataframe in which all records are missing

[R. Michael Weylandt]

Good morning Peter,

No, I don't think complete cases gets what the OP wants. He wants to
only throw out those rows that are entirely NA while complete.cases()
gets rows with any NA's.

Best,

Michael

2011/11/7 Petr PIKAL <petr.pikal at precheza.cz>:
>>
>> 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.Iparraguirre at 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.Iparraguirre at ageuk.org.uk<mailto:Jose.Iparraguirre at 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 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.
>> >
>> >
>>
>> ______________________________________________
>> 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.
>
>