Assignment 2 ## vector
ID =c(1,2,3,4,5)
Name = c("Alice","Bob","David","John","Jenny")
Age=c(20, 25, 30, 22, 18)
Score=c(100, 78, 90, 55, 81)
Data frame
exam_score=data.frame(
ID =c(1,2,3,4,5),
Name = c("Alice","Bob","David","John","Jenny"),
Age=c(20, 25, 30, 22, 18),
Score=c(100, 78, 90, 55, 81)
)
exam_score
Adding 2 row
exam_score_1=data.frame(
ID =c(1,2,3,4,5,6,7),
Name = c("Alice","Bob","David","John","Jenny","Joey","Rob"),
Age=c(20, 25, 30, 22, 18,35,32),
Score=c(100, 78, 90, 55, 81,85,60)
)
exam_score_1
Adding a new column
Income=c(50000,100000,60000,55000,70000,80000,67000)
exam_score_1 = cbind(exam_score_1,Income)
exam_score_1
max(Age)
Error: object 'Age' not found
Finding max of columns Age, Score,Income
``
Age=c(20, 25, 30, 22, 18,35,32)
max(Age)
[1] 35
Score=c(100, 78, 90, 55, 81,85,60)
max(Score)
[1] 100
Income=c(50000,100000,60000,55000,70000,80000,67000)
max(Income)
[1] 1e+05
min(Age)
[1] 18
min(Score)
[1] 55
min(Income)
[1] 50000
Finding sum of columns Age, Score, and Income
Age=c(20, 25, 30, 22, 18,35,32)
Score=c(100, 78, 90, 55, 81,85,60)
Income=c(50000,100000,60000,55000,70000,80000,67000)
sum(Age)
[1] 182
sum(Score)
[1] 549
sum(Income)
[1] 482000
Finding standard deviation of columns Age, Score, and Income
sd(Age)
[1] 6.454972
sd(Score)
[1] 16.00893
sd(Income)
[1] 16955.12
Finding variance of columns Age, Score, and Income
var(Age)
[1] 41.66667
var(Score)
[1] 256.2857
var(Income)
[1] 287476190
Finding quantiles of columns Age, Score, and Income
quantile(Age)
0% 25% 50% 75% 100%
18 21 25 31 35
quantile(Score)
0% 25% 50% 75% 100%
55.0 69.0 81.0 87.5 100.0
quantile(Income)
0% 25% 50% 75% 100%
50000 57500 67000 75000 100000
#Correlation
cor(Age,Score)
[1] -0.09838344
cor(Age,Income)
[1] 0.2771563
cor(Score,Income)
[1] -0.05377099
#Selecteing rows where the score is greater than or equal to 80
exam_score_1[exam_score_1$Score>=80, c(1,2,3,4,5)]
#Selecting rows with the age range of 20 to 30
exam_score_1[exam_score_1$Age>=20 & exam_score_1$Age<=30, c(1,2,3,4,5)]
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KQXNzaWdubWVudCAyDQojIyB2ZWN0b3INCmBgYHtyfQ0KSUQgPWMoMSwyLDMsNCw1KQ0KTmFtZSA9IGMoIkFsaWNlIiwiQm9iIiwiRGF2aWQiLCJKb2huIiwiSmVubnkiKQ0KQWdlPWMoMjAsIDI1LCAzMCwgMjIsIDE4KQ0KU2NvcmU9YygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KYGBgDQojIyBEYXRhIGZyYW1lDQpgYGB7cn0NCmV4YW1fc2NvcmU9ZGF0YS5mcmFtZSgNCklEID1jKDEsMiwzLDQsNSksDQpOYW1lID0gYygiQWxpY2UiLCJCb2IiLCJEYXZpZCIsIkpvaG4iLCJKZW5ueSIpLA0KQWdlPWMoMjAsIDI1LCAzMCwgMjIsIDE4KSwNClNjb3JlPWMoMTAwLCA3OCwgOTAsIDU1LCA4MSkNCikNCmV4YW1fc2NvcmUNCmBgYA0KIyMgQWRkaW5nIDIgcm93DQpgYGB7cn0NCmV4YW1fc2NvcmVfMT1kYXRhLmZyYW1lKA0KSUQgPWMoMSwyLDMsNCw1LDYsNyksDQpOYW1lID0gYygiQWxpY2UiLCJCb2IiLCJEYXZpZCIsIkpvaG4iLCJKZW5ueSIsIkpvZXkiLCJSb2IiKSwNCkFnZT1jKDIwLCAyNSwgMzAsIDIyLCAxOCwzNSwzMiksDQpTY29yZT1jKDEwMCwgNzgsIDkwLCA1NSwgODEsODUsNjApDQopDQpleGFtX3Njb3JlXzENCmBgYA0KIyMgQWRkaW5nIGEgbmV3IGNvbHVtbg0KYGBge3J9DQpJbmNvbWU9Yyg1MDAwMCwxMDAwMDAsNjAwMDAsNTUwMDAsNzAwMDAsODAwMDAsNjcwMDApDQpleGFtX3Njb3JlXzEgPSBjYmluZChleGFtX3Njb3JlXzEsSW5jb21lKQ0KZXhhbV9zY29yZV8xDQoNCmBgYA0KIyBGaW5kaW5nIG1heCBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsSW5jb21lDQpgYA0KYGBge3J9DQpBZ2U9YygyMCwgMjUsIDMwLCAyMiwgMTgsMzUsMzIpDQptYXgoQWdlKQ0KU2NvcmU9YygxMDAsIDc4LCA5MCwgNTUsIDgxLDg1LDYwKQ0KbWF4KFNjb3JlKQ0KSW5jb21lPWMoNTAwMDAsMTAwMDAwLDYwMDAwLDU1MDAwLDcwMDAwLDgwMDAwLDY3MDAwKQ0KbWF4KEluY29tZSkNCm1pbihBZ2UpDQptaW4oU2NvcmUpDQptaW4oSW5jb21lKQ0KYGBgDQoNCiMjIEZpbmRpbmcgbWVkaWFuIG9mIGNvbHVtbnMgQWdlLCBTY29yZSwgYW5kIEluY29tZQ0KYGBge3J9DQpBZ2U9YygyMCwgMjUsIDMwLCAyMiwgMTgsMzUsMzIpDQpTY29yZT1jKDEwMCwgNzgsIDkwLCA1NSwgODEsODUsNjApDQpJbmNvbWU9Yyg1MDAwMCwxMDAwMDAsNjAwMDAsNTUwMDAsNzAwMDAsODAwMDAsNjcwMDApDQptZWRpYW4oQWdlKQ0KbWVkaWFuKFNjb3JlKQ0KbWVkaWFuKEluY29tZSkNCg0KDQpgYGANCiMgRmluZGluZyBzdW0gb2YgY29sdW1ucyBBZ2UsIFNjb3JlLCBhbmQgSW5jb21lDQpgYGB7cn0NCkFnZT1jKDIwLCAyNSwgMzAsIDIyLCAxOCwzNSwzMikNClNjb3JlPWMoMTAwLCA3OCwgOTAsIDU1LCA4MSw4NSw2MCkNCkluY29tZT1jKDUwMDAwLDEwMDAwMCw2MDAwMCw1NTAwMCw3MDAwMCw4MDAwMCw2NzAwMCkNCg0KDQpzdW0oQWdlKQ0Kc3VtKFNjb3JlKQ0Kc3VtKEluY29tZSkNCmBgYA0KIyBGaW5kaW5nIHN0YW5kYXJkIGRldmlhdGlvbiBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUNCmBgYHtyfQ0Kc2QoQWdlKQ0Kc2QoU2NvcmUpDQpzZChJbmNvbWUpDQpgYGANCiMgRmluZGluZyB2YXJpYW5jZSBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUNCmBgYHtyfQ0KdmFyKEFnZSkNCnZhcihTY29yZSkNCnZhcihJbmNvbWUpDQpgYGANCiMgRmluZGluZyBxdWFudGlsZXMgb2YgY29sdW1ucyBBZ2UsIFNjb3JlLCBhbmQgSW5jb21lDQpgYGB7cn0NCnF1YW50aWxlKEFnZSkNCmBgYA0KYGBge3J9DQpxdWFudGlsZShTY29yZSkNCmBgYA0KYGBge3J9DQpxdWFudGlsZShJbmNvbWUpDQpgYGANCiNDb3JyZWxhdGlvbiANCmBgYHtyfQ0KY29yKEFnZSxTY29yZSkNCmNvcihBZ2UsSW5jb21lKQ0KY29yKFNjb3JlLEluY29tZSkNCmBgYA0KI1NlbGVjdGVpbmcgcm93cyB3aGVyZSB0aGUgc2NvcmUgaXMgZ3JlYXRlciB0aGFuIG9yIGVxdWFsIHRvIDgwDQpgYGB7cn0NCmV4YW1fc2NvcmVfMVtleGFtX3Njb3JlXzEkU2NvcmU+PTgwLCBjKDEsMiwzLDQsNSldDQpgYGANCg0KI1NlbGVjdGluZyByb3dzIHdpdGggdGhlIGFnZSByYW5nZSBvZiAyMCB0byAzMA0KYGBge3J9DQpleGFtX3Njb3JlXzFbZXhhbV9zY29yZV8xJEFnZT49MjAgJiBleGFtX3Njb3JlXzEkQWdlPD0zMCwgYygxLDIsMyw0LDUpXQ0KYGBgDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0K