删除数据框中的周末数据
问题描述：
从下面的数据框中可以看到，RBloomberg返回周末日期的NA。
As you can see from the dataframe below, RBloomberg returns NAs for weekend dates.
如果要在周末删除整行，我想删除整行。我该怎么做？
I want to remove the entire row if it falls on a weekend. How would I do this?
我不想使用 na.omit ，因为如果/当我在数据中获得NA时，这可能会删除工作日的行有正当理由。
I don't want to use the na.omit as this might remove weekday rows if/when I get an NA there in the data for a legitimate reason.
ticker date yld_ytm_mid
1 R206 2011-05-11 6.946
2 R206 2011-05-12 6.969
3 R206 2011-05-13 7.071
4 R206 2011-05-14 NA
5 R206 2011-05-15 NA
6 R201 2011-05-11 7.201
7 R201 2011-05-12 7.213
8 R201 2011-05-13 7.323
9 R201 2011-05-14 NA
10 R201 2011-05-15 NA
11 R157 2011-05-11 7.611
12 R157 2011-05-12 7.622
13 R157 2011-05-13 7.718
14 R157 2011-05-14 NA
15 R157 2011-05-15 NA
16 R203 2011-05-11 8.165
17 R203 2011-05-12 8.170
18 R203 2011-05-13 8.279
19 R203 2011-05-14 NA
20 R203 2011-05-15 NA
21 R204 2011-05-11 8.303
22 R204 2011-05-12 8.296
23 R204 2011-05-13 8.386
24 R204 2011-05-14 NA
25 R204 2011-05-15 NA
26 R207 2011-05-11 8.361
27 R207 2011-05-12 8.371
28 R207 2011-05-13 8.479
29 R207 2011-05-14 NA
30 R207 2011-05-15 NA
31 R208 2011-05-11 8.392
32 R208 2011-05-12 8.393
33 R208 2011-05-13 8.514
34 R208 2011-05-14 NA
35 R208 2011-05-15 NA
36 R186 2011-05-11 8.546
37 R186 2011-05-12 8.571
38 R186 2011-05-13 8.664
39 R186 2011-05-14 NA
40 R186 2011-05-15 NA
41 R213 2011-05-11 8.783
42 R213 2011-05-12 8.802
43 R213 2011-05-13 8.898
44 R213 2011-05-14 NA
45 R213 2011-05-15 NA
46 R209 2011-05-11 8.785
47 R209 2011-05-12 8.807
48 R209 2011-05-13 8.898
49 R209 2011-05-14 NA
50 R209 2011-05-15 NA
51 R214 2011-05-11 8.841
52 R214 2011-05-12 8.861
53 R214 2011-05-13 8.958
54 R214 2011-05-14 NA
55 R214 2011-05-15 NA
答
将日期列转换为POSIXlt，例如
Convert the date column to a POSIXlt ,eg
date <- as.POSIXlt(date,format="%Y-%m-%d")
然后您可以使用
date$wday
并适当地对框架进行子集
and subset the frame appropriately