R语言使用subset筛选指定日期数据时出现缺失值问题求助

Hey there! Let's figure out why you're getting those weird alternating missing rows and fix this up quickly.

The root of the problem is using == with a vector (id_list) in your subset call. When you use == against a vector that's shorter than your data frame, R does something called "recycling"—it repeats the shorter vector to match the length of the longer one. Since your df has way more rows than your 2-element id_list, it's checking row 1 against 20180101, row 2 against 20180102, row 3 against 20180101 again, row 4 against 20180102, and so on. That's why you're seeing every other row get filtered out (or marked as NA)—it's only keeping rows where the recycled value happens to line up, which isn't what you want at all.

Fix 1: Use %in% instead of == #

This is the simplest and most direct fix. %in% checks if each element in df$Dates exists anywhere in your id_list, which is exactly the logic you need:

id_list <- c(20180101, 20180102)
df_filtered <- subset(df, Dates %in% id_list)

Fix 2: Base R bracket indexing (alternative to subset) #

If you prefer using bracket notation instead of the subset() function, this works just as well:

df_filtered <- df[df$Dates %in% id_list, ]

Fix 3: Tidyverse approach with dplyr #

If you're using the tidyverse ecosystem, the filter() function makes this clean and readable:

library(dplyr)
df_filtered <- df %>% filter(Dates %in% id_list)

A quick bonus tip: For long-term work with date data, it's a good idea to convert your Dates column to a proper Date type instead of keeping it as numeric. This avoids any accidental formatting issues later. Here's how you'd adjust the code for that:

# Convert numeric Dates to Date objects
df$Dates <- as.Date(as.character(df$Dates), format = "%Y%m%d")
# Update id_list to match Date type
id_list <- as.Date(c("2018-01-01", "2018-01-02"))
# Filter as before
df_filtered <- subset(df, Dates %in% id_list)

Any of these methods should give you all rows where Dates is either 20180101 or 20180102—no more random missing rows!

内容的提问来源于stack exchange，提问作者Rogan Josh Piotr