[R] Filtering Cases with != NA

[jim holtman]

use the 'is.na' function:

new_dataset <- subset(dataset, subset = !is.na(Turnover))


Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.

On Thu, Dec 17, 2015 at 7:50 AM, <G.Maubach at weinwolf.de> wrote:

> Dear All,
>
> I am new to "R" and search for a solution to exclude cases if a certain
> variable contains NA for a case.
>
> Example
>
> No Name Turnover
> 1 Smith 1500
> 2 Mayor 200
> 3 Miller
> 4 Batic 750
>
> I would like to create a subset excluding case 3 Miller NA.
>
> I tried to following:
>
> new_dataset <- subset(dataset, subset = Turnover != NA)
>
> This does not work. The new_dataset contains all variables but not cases
> are left. R responds "Variables with all observations missing".
>
> How could I do it right?
>
> Kind regards
>
> Georg
>
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at 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.
>

	[[alternative HTML version deleted]]