Re: [R] melt, remove rows with common id if NA encountered in value

try this: > x <- read.table(textConnection("SP variable value + 425 CoolidgeLoad 6.044483e+07 + 425 CoolidgeLoad 5.314102e+07 + 425 CoolidgeLoad 5.287761e+07 + 425 CoolidgeLoad 4.592003e+07 + 425 CoolidgeLoad 4.314002e+07 + 425 CoolidgeLoad NA + 425 CoolidgeLoad NA

[R] melt, remove rows with common id if NA encountered in value

forum, After melting a data.frame I get some 18,000+ rows (some rows below). I want to filter/remove all rows that have an "SP" & "variable" value in common with a row containing "NA" in the value column. So in the example rows below, all rows with SP=425 & variable=CoolidgeLoad would be remove