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
NA
## 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
NA
NA
NA
## Adding a new column
Income=c(50000,100000,60000,55000,70000,80000,67000)
exam_score_1 = cbind(exam_score_1,Income)
exam_score_1
## Finding max of columns Age, Score, and Income
max(Age)
[1] 30
max(Score)
[1] 100
max(Income)
[1] 1e+05
## Finding min of columns Age, Score, and Income
min(Age)
[1] 18
min(Score)
[1] 55
min(Income)
[1] 50000
## Finding median of columns Age, Score, and Income
median(Age)
[1] 22
median(Score)
[1] 81
median(Income)
[1] 67000
## Finding sum of columns Age, Score, and Income
sum(Age)
[1] 115
sum(Score)
[1] 404
sum(Income)
[1] 482000
## Finding standard deviation of columns Age, Score,
and Income
sd(Age)
[1] 4.690416
sd(Score)
[1] 16.78392
sd(Income)
[1] 16955.12
## Finding variance of columns Age, Score, and Income
var(Age)
[1] 22
var(Score)
[1] 281.7
var(Income)
[1] 287476190
## Finding quantiles of columns Age, Score, and Income
quantile(Age)
0% 25% 50% 75% 100%
18 20 22 25 30
quantile(Score)
0% 25% 50% 75% 100%
55 78 81 90 100
quantile(Income)
0% 25% 50% 75%
50000 57500 67000 75000
100%
100000
##Correlation between Age and score
cor(Age,Score)
[1] 0.0825674
##Correlation between Age and income
cor(Age,Income)
Error in cor(Age, Income) : incompatible dimensions
##Correlation between Score and income
cor(Score,Income)
Error in cor(Score, Income) : incompatible dimensions
##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)]
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KIDxmb250IHNpemU9NyA+IEFzc2lnbm1lbnQgMjwvZm9udD5cDQo8Zm9udCBzaXplPTUgPiAjIyB2ZWN0b3I8L2ZvbnQ+ICAgICAgICANCmBgYHtyfQ0KSUQgPWMoMSwyLDMsNCw1KQ0KTmFtZSA9IGMoIkFsaWNlIiwiQm9iIiwiRGF2aWQiLCJKb2huIiwiSmVubnkiKQ0KQWdlPWMoMjAsIDI1LCAzMCwgMjIsIDE4KQ0KU2NvcmU9YygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KSW5jb21lPWMoNTAwMDAsMTAwMDAwLDYwMDAwLDU1MDAwLDcwMDAwLDgwMDAwLDY3MDAwKQ0KYGBgDQoNCg0KPGZvbnQgc2l6ZT01ID4gIyMgRGF0YSBmcmFtZTwvZm9udD4NCmBgYHtyfQ0KZXhhbV9zY29yZT1kYXRhLmZyYW1lKA0KSUQgPWMoMSwyLDMsNCw1KSwNCk5hbWUgPSBjKCJBbGljZSIsIkJvYiIsIkRhdmlkIiwiSm9obiIsIkplbm55IiksDQpBZ2U9YygyMCwgMjUsIDMwLCAyMiwgMTgpLA0KU2NvcmU9YygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KKQ0KZXhhbV9zY29yZQ0KDQpgYGANCjxmb250IHNpemU9NSA+ICMjIEFkZGluZyAyIHJvdzwvZm9udD4NCmBgYHtyfQ0KZXhhbV9zY29yZV8xPWRhdGEuZnJhbWUoDQpJRCA9YygxLDIsMyw0LDUsNiw3KSwNCk5hbWUgPSBjKCJBbGljZSIsIkJvYiIsIkRhdmlkIiwiSm9obiIsIkplbm55IiwiSm9leSIsIlJvYiIpLA0KQWdlPWMoMjAsIDI1LCAzMCwgMjIsIDE4LDM1LDMyKSwNClNjb3JlPWMoMTAwLCA3OCwgOTAsIDU1LCA4MSw4NSw2MCkNCikNCmV4YW1fc2NvcmVfMQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjIEFkZGluZyBhIG5ldyBjb2x1bW48L2ZvbnQ+DQpgYGB7cn0NCkluY29tZT1jKDUwMDAwLDEwMDAwMCw2MDAwMCw1NTAwMCw3MDAwMCw4MDAwMCw2NzAwMCkNCmV4YW1fc2NvcmVfMSA9IGNiaW5kKGV4YW1fc2NvcmVfMSxJbmNvbWUpDQpleGFtX3Njb3JlXzENCmBgYA0KDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgbWF4IG9mIGNvbHVtbnMgQWdlLCBTY29yZSwgYW5kIEluY29tZSA8L2ZvbnQ+DQpgYGB7cn0NCm1heChBZ2UpDQptYXgoU2NvcmUpDQptYXgoSW5jb21lKQ0KDQpgYGANCg0KDQo8Zm9udCBzaXplPTUgPiAjIyBGaW5kaW5nIG1pbiBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQptaW4oQWdlKQ0KbWluKFNjb3JlKQ0KbWluKEluY29tZSkNCmBgYA0KDQo8Zm9udCBzaXplPTUgPiAjIyBGaW5kaW5nIG1lZGlhbiBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQptZWRpYW4oQWdlKQ0KbWVkaWFuKFNjb3JlKQ0KbWVkaWFuKEluY29tZSkNCmBgYA0KDQo8Zm9udCBzaXplPTUgPiAjIyBGaW5kaW5nIHN1bSBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQpzdW0oQWdlKQ0Kc3VtKFNjb3JlKQ0Kc3VtKEluY29tZSkNCmBgYA0KDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgc3RhbmRhcmQgZGV2aWF0aW9uIG9mIGNvbHVtbnMgQWdlLCBTY29yZSwgYW5kIEluY29tZSA8L2ZvbnQ+DQpgYGB7cn0NCnNkKEFnZSkNCnNkKFNjb3JlKQ0Kc2QoSW5jb21lKQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgIHZhcmlhbmNlIG9mIGNvbHVtbnMgQWdlLCBTY29yZSwgYW5kIEluY29tZSA8L2ZvbnQ+DQpgYGB7cn0NCnZhcihBZ2UpDQp2YXIoU2NvcmUpDQp2YXIoSW5jb21lKQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjIEZpbmRpbmcgcXVhbnRpbGVzICBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUgPC9mb250Pg0KYGBge3J9DQpxdWFudGlsZShBZ2UpDQoNCnF1YW50aWxlKFNjb3JlKQ0KDQpxdWFudGlsZShJbmNvbWUpDQpgYGANCg0KPGZvbnQgc2l6ZT01ID4gIyNDb3JyZWxhdGlvbiBiZXR3ZWVuIEFnZSBhbmQgc2NvcmU8L2ZvbnQ+DQpgYGB7cn0NCmNvcihBZ2UsU2NvcmUpDQpgYGANCg0KPGZvbnQgc2l6ZT01ID4gIyNDb3JyZWxhdGlvbiBiZXR3ZWVuIEFnZSBhbmQgIGluY29tZTwvZm9udD4NCmBgYHtyfQ0KY29yKEFnZSxJbmNvbWUpDQpgYGANCg0KDQo8Zm9udCBzaXplPTUgPiAjI0NvcnJlbGF0aW9uIGJldHdlZW4gU2NvcmUgYW5kIGluY29tZQ0KPC9mb250Pg0KYGBge3J9DQpjb3IoU2NvcmUsSW5jb21lKQ0KYGBgDQoNCg0KPGZvbnQgc2l6ZT01ID4gIyNTZWxlY3RlaW5nIHJvd3Mgd2hlcmUgdGhlIHNjb3JlIGlzIGdyZWF0ZXIgdGhhbiBvciBlcXVhbCB0byA4MDwvZm9udD4NCg0KYGBge3J9DQpleGFtX3Njb3JlXzFbZXhhbV9zY29yZV8xJFNjb3JlPj04MCwgYygxLDIsMyw0LDUpXQ0KYGBgDQoNCjxmb250IHNpemU9NSA+ICMjU2VsZWN0aW5nIHJvd3Mgd2l0aCB0aGUgYWdlIHJhbmdlIG9mIDIwIHRvIDMwIDwvZm9udD4NCmBgYHtyfQ0KZXhhbV9zY29yZV8xW2V4YW1fc2NvcmVfMSRBZ2U+PTIwICYgZXhhbV9zY29yZV8xJEFnZTw9MzAsIGMoMSwyLDMsNCw1KV0NCmBgYA0KDQoNCg0K