Remove #NA values from list of pairs of values

Questions
1

Hi
I have a list like below, I want to delete all entries in this list which have a second argument = “#NA”
I tried DeleteCases function but some how its not working.
Please help.
Thanks,
Nalina

data={{{2020, 1, 2, 0, 0, 0}, 2.48462802932}, {{2020, 1, 3, 0, 0, 0}, 
  2.47743873665}, {{2020, 1, 4, 0, 0, 0}, 
  "#NA"}, {{2020, 1, 5, 0, 0, 0}, "#NA"}, {{2020, 1, 6, 0, 0, 0}, 
  2.32779025386}, {{2020, 1, 7, 0, 0, 0}, 
  3.18982131454}, {{2020, 1, 8, 0, 0, 0}, 
  2.77782163231}, {{2020, 1, 9, 0, 0, 0}, 
  2.50983191849}, {{2020, 1, 10, 0, 0, 0}, 
  2.34758487156}, {{2020, 1, 11, 0, 0, 0}, "#NA"}}
2

data // Select[Last@# != “#NA” &]

data // DeleteCases[#, {_, "#NA"}] &
3

Hi Nalina, try this way:

DeleteCases[data, {_, "#NA"}]

6107im1.png

(Oops, I didn’t see that Rohit had already answered you … sorry ^^)

4

Thanks, Rohit.
Yes, this works.

Nalina

5

Hi Claudio.
Yes, this works.

Thanks,
Nalina