■
> install.packages("dplyr")
Installing package into ‘M:/Documents/R/win-library/3.3’
(as ‘lib’ is unspecified)
--- Please select a CRAN mirror for use in this session ---
trying URL 'https://cran.ism.ac.jp/bin/windows/contrib/3.3/dplyr_0.5.0.zip'
Content type 'application/zip' length 2557234 bytes (2.4 MB)
downloaded 2.4 MB
package ‘dplyr’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\a0155441\AppData\Local\Temp\RtmpekFbx7\downloaded_packages
> library(dplyr)
Attaching package: ‘dplyr’
The following objects are masked from ‘package:stats’:
filter, lag
The following objects are masked from ‘package:base’:
intersect, setdiff, setequal, union
Warning message:
package ‘dplyr’ was built under R version 3.3.3
> pass<-dplyr::filter(d,grade!="D")
Error in filter_(.data, .dots = lazyeval::lazy_dots(...)) :
object 'd' not found
Error in file(file, "rt") : cannot open the connection
In addition: Warning message:
In file(file, "rt") :
cannot open file 'dataa1.csv': No such file or directory
> d
id class gender score1 score2 grade
1 a001 A female 50 59 C
2 a002 A female 53 70 A
3 a003 A male 46 57 C
4 a004 A female 59 67 A
5 a005 A male 51 66 B
6 a006 A male 47 64 B
7 a007 A male 55 53 C
8 a008 A male 66 66 A
9 a009 A male 54 68 B
10 a010 A female 54 67 B
11 a011 A male 59 69 A
12 a012 A male 60 75 A
13 a013 A female 60 68 A
14 a014 A female 61 71 A
15 a015 A female 32 42 D
16 a016 A male 74 70 A
17 a017 A female 48 57 C
18 a018 A male 52 60 B
19 a019 A female 60 73 A
20 a020 A female 52 59 B
21 a021 A female 39 52 D
22 a022 A male 58 67 A
23 a023 A male 48 55 C
24 a024 A male 68 78 A
25 a025 A female 69 76 A
26 a026 A female 61 72 A
27 a027 A female 53 62 B
28 a028 A female 52 68 B
29 a029 A male 35 48 D
30 a030 A female 41 47 D
31 a031 A female 44 51 D
32 a032 A male 47 54 C
33 a033 A male 55 57 B
34 a034 A female 43 61 C
35 a035 A female 48 56 C
36 a036 A male 56 72 A
37 a037 A female 54 63 B
38 a038 A female 65 66 A
39 a039 A male 37 58 D
40 a040 A female 49 55 C
41 a041 A female 59 69 A
42 a042 A male 47 59 C
43 a043 A male 38 49 D
44 a044 A male 31 49 D
45 a045 A female 56 67 A
46 a046 A male 49 55 C
47 a047 A male 52 55 C
48 a048 A male 31 56 D
49 a049 A female 51 55 C
50 a050 A female 49 60 C
51 a051 A male 54 63 B
52 a052 A female 28 36 D
53 a053 A female 53 51 C
54 a054 A female 69 72 A
55 a055 A female 45 55 C
56 a056 A female 51 64 B
57 a057 A male 53 58 B
58 a058 A female 46 56 C
59 a059 A male 55 73 A
60 a060 A female 32 53 D
61 a061 A male 52 50 C
62 a062 A female 53 64 B
63 a063 A male 42 57 D
64 a064 A male 37 44 D
65 a065 A male 34 51 D
66 a066 A male 46 58 C
67 a067 A female 45 54 D
68 a068 A male 35 45 D
69 a069 A female 42 56 D
70 a070 A male 55 68 A
71 a071 A male 30 48 D
72 a072 A male 55 62 B
73 a073 A male 61 61 B
74 a074 A female 42 47 D
75 a075 A male 58 68 A
76 a076 A female 59 69 A
77 a077 A male 43 54 D
78 a078 A female 56 53 C
79 a079 A female 55 66 B
80 a080 A female 56 71 A
81 a081 A female 60 82 A
82 a082 A female 45 57 C
83 a083 A male 30 37 D
84 a084 A female 35 40 D
85 a085 A male 39 51 D
86 a086 A male 38 50 D
87 a087 A male 51 48 D
88 a088 A male 50 59 C
89 a089 A female 48 43 D
90 a090 A male 37 47 D
91 a091 A male 75 71 A
92 a092 A male 53 64 B
93 a093 A female 43 48 D
94 a094 A female 54 60 B
95 a095 A male 56 62 B
96 a096 A female 62 74 A
97 a097 A female 34 49 D
98 a098 A female 49 57 C
99 a099 A female 51 57 C
100 a100 A male 47 59 C
101 b001 B female 58 29 D
102 b002 B male 64 40 C
103 b003 B female 54 51 C
104 b004 B female 50 57 C
105 b005 B male 60 55 B
106 b006 B female 48 38 D
107 b007 B male 55 71 A
108 b008 B male 68 49 B
109 b009 B male 52 52 C
110 b010 B female 72 58 A
111 b011 B male 72 59 A
112 b012 B male 65 49 B
113 b013 B female 59 43 C
114 b014 B male 39 52 D
115 b015 B female 57 49 C
116 b016 B male 63 59 B
117 b017 B male 52 37 D
118 b018 B female 55 64 B
119 b019 B male 50 48 D
120 b020 B male 54 32 D
121 b021 B male 55 57 B
122 b022 B male 61 57 B
123 b023 B female 67 66 A
124 b024 B male 67 54 B
125 b025 B female 48 50 D
126 b026 B female 68 45 B
127 b027 B male 66 45 B
128 b028 B female 63 52 B
129 b029 B male 63 52 B
130 b030 B female 52 55 C
131 b031 B female 70 57 A
132 b032 B male 65 48 B
133 b033 B female 55 41 D
134 b034 B female 49 48 D
135 b035 B male 72 31 C
136 b036 B female 55 36 D
137 b037 B female 75 61 A
138 b038 B female 48 50 D
139 b039 B male 82 64 A
140 b040 B female 60 41 C
141 b041 B male 47 43 D
142 b042 B female 61 53 B
143 b043 B male 59 59 B
144 b044 B male 75 53 A
145 b045 B female 47 46 D
146 b046 B male 53 43 D
147 b047 B male 54 59 B
148 b048 B female 70 52 B
149 b049 B female 65 44 C
150 b050 B female 47 58 C
151 b051 B male 28 32 D
152 b052 B female 47 43 D
153 b053 B female 57 55 B
154 b054 B female 60 57 B
155 b055 B female 58 63 B
156 b056 B male 63 52 B
157 b057 B male 72 54 A
158 b058 B female 61 63 A
159 b059 B female 71 59 A
160 b060 B female 79 30 C
161 b061 B male 67 58 A
162 b062 B female 61 47 C
163 b063 B female 57 46 C
164 b064 B female 70 34 C
165 b065 B male 57 66 A
166 b066 B female 63 56 B
167 b067 B male 59 34 D
168 b068 B male 46 51 D
169 b069 B female 64 53 B
170 b070 B female 70 59 A
171 b071 B female 64 53 B
172 b072 B female 74 51 A
173 b073 B female 45 57 C
174 b074 B male 64 48 B
175 b075 B male 68 48 B
176 b076 B male 69 35 C
177 b077 B male 48 62 B
178 b078 B male 73 56 A
179 b079 B male 72 60 A
180 b080 B male 52 41 D
181 b081 B female 56 43 D
182 b082 B female 78 44 B
183 b083 B male 58 43 C
184 b084 B female 70 35 C
185 b085 B male 58 66 A
186 b086 B female 60 62 B
187 b087 B female 39 49 D
188 b088 B male 47 41 D
189 b089 B male 59 58 B
190 b090 B male 57 46 C
191 b091 B male 53 47 C
192 b092 B female 66 65 A
193 b093 B female 57 46 C
194 b094 B male 66 57 A
195 b095 B female 63 41 C
196 b096 B male 64 73 A
197 b097 B male 47 65 B
198 b098 B male 65 44 C
199 b099 B male 61 62 A
200 b100 B male 67 78 A
> pass<-dplyr::filter(d,grade!="D")
> pass
id class gender score1 score2 grade
1 a001 A female 50 59 C
2 a002 A female 53 70 A
3 a003 A male 46 57 C
4 a004 A female 59 67 A
5 a005 A male 51 66 B
6 a006 A male 47 64 B
7 a007 A male 55 53 C
8 a008 A male 66 66 A
9 a009 A male 54 68 B
10 a010 A female 54 67 B
11 a011 A male 59 69 A
12 a012 A male 60 75 A
13 a013 A female 60 68 A
14 a014 A female 61 71 A
15 a016 A male 74 70 A
16 a017 A female 48 57 C
17 a018 A male 52 60 B
18 a019 A female 60 73 A
19 a020 A female 52 59 B
20 a022 A male 58 67 A
21 a023 A male 48 55 C
22 a024 A male 68 78 A
23 a025 A female 69 76 A
24 a026 A female 61 72 A
25 a027 A female 53 62 B
26 a028 A female 52 68 B
27 a032 A male 47 54 C
28 a033 A male 55 57 B
29 a034 A female 43 61 C
30 a035 A female 48 56 C
31 a036 A male 56 72 A
32 a037 A female 54 63 B
33 a038 A female 65 66 A
34 a040 A female 49 55 C
35 a041 A female 59 69 A
36 a042 A male 47 59 C
37 a045 A female 56 67 A
38 a046 A male 49 55 C
39 a047 A male 52 55 C
40 a049 A female 51 55 C
41 a050 A female 49 60 C
42 a051 A male 54 63 B
43 a053 A female 53 51 C
44 a054 A female 69 72 A
45 a055 A female 45 55 C
46 a056 A female 51 64 B
47 a057 A male 53 58 B
48 a058 A female 46 56 C
49 a059 A male 55 73 A
50 a061 A male 52 50 C
51 a062 A female 53 64 B
52 a066 A male 46 58 C
53 a070 A male 55 68 A
54 a072 A male 55 62 B
55 a073 A male 61 61 B
56 a075 A male 58 68 A
57 a076 A female 59 69 A
58 a078 A female 56 53 C
59 a079 A female 55 66 B
60 a080 A female 56 71 A
61 a081 A female 60 82 A
62 a082 A female 45 57 C
63 a088 A male 50 59 C
64 a091 A male 75 71 A
65 a092 A male 53 64 B
66 a094 A female 54 60 B
67 a095 A male 56 62 B
68 a096 A female 62 74 A
69 a098 A female 49 57 C
70 a099 A female 51 57 C
71 a100 A male 47 59 C
72 b002 B male 64 40 C
73 b003 B female 54 51 C
74 b004 B female 50 57 C
75 b005 B male 60 55 B
76 b007 B male 55 71 A
77 b008 B male 68 49 B
78 b009 B male 52 52 C
79 b010 B female 72 58 A
80 b011 B male 72 59 A
81 b012 B male 65 49 B
82 b013 B female 59 43 C
83 b015 B female 57 49 C
84 b016 B male 63 59 B
85 b018 B female 55 64 B
86 b021 B male 55 57 B
87 b022 B male 61 57 B
88 b023 B female 67 66 A
89 b024 B male 67 54 B
90 b026 B female 68 45 B
91 b027 B male 66 45 B
92 b028 B female 63 52 B
93 b029 B male 63 52 B
94 b030 B female 52 55 C
95 b031 B female 70 57 A
96 b032 B male 65 48 B
97 b035 B male 72 31 C
98 b037 B female 75 61 A
99 b039 B male 82 64 A
100 b040 B female 60 41 C
101 b042 B female 61 53 B
102 b043 B male 59 59 B
103 b044 B male 75 53 A
104 b047 B male 54 59 B
105 b048 B female 70 52 B
106 b049 B female 65 44 C
107 b050 B female 47 58 C
108 b053 B female 57 55 B
109 b054 B female 60 57 B
110 b055 B female 58 63 B
111 b056 B male 63 52 B
112 b057 B male 72 54 A
113 b058 B female 61 63 A
114 b059 B female 71 59 A
115 b060 B female 79 30 C
116 b061 B male 67 58 A
117 b062 B female 61 47 C
118 b063 B female 57 46 C
119 b064 B female 70 34 C
120 b065 B male 57 66 A
121 b066 B female 63 56 B
122 b069 B female 64 53 B
123 b070 B female 70 59 A
124 b071 B female 64 53 B
125 b072 B female 74 51 A
126 b073 B female 45 57 C
127 b074 B male 64 48 B
128 b075 B male 68 48 B
129 b076 B male 69 35 C
130 b077 B male 48 62 B
131 b078 B male 73 56 A
132 b079 B male 72 60 A
133 b082 B female 78 44 B
134 b083 B male 58 43 C
135 b084 B female 70 35 C
136 b085 B male 58 66 A
137 b086 B female 60 62 B
138 b089 B male 59 58 B
139 b090 B male 57 46 C
140 b091 B male 53 47 C
141 b092 B female 66 65 A
142 b093 B female 57 46 C
143 b094 B male 66 57 A
144 b095 B female 63 41 C
145 b096 B male 64 73 A
146 b097 B male 47 65 B
147 b098 B male 65 44 C
148 b099 B male 61 62 A
149 b100 B male 67 78 A
> pass_g<-grop_by(pass,class,gender)
Error: could not find function "grop_by"
> pass_g<-group_by(pass,class,gender)
> pass_s2<-summarize(pass_g,n=n(),mean=mean(score2),sd=sd(score2))
> pass_s2
Source: local data frame [4 x 5]
Groups: class [?]
class gender n mean sd
<fctr> <fctr> <int> <dbl> <dbl>
1 A female 38 63.92105 7.316703
2 A male 33 62.90909 6.929843
3 B female 38 52.15789 8.918630
4 B male 40 54.77500 9.754650