1.Create this 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
2.Add 2 new rows
new_row1 = c("6","Max","23","85")
new_row2 = c("7","Alex","28","80")
exam_score = rbind(exam_score,new_row1,new_row2)
exam_score
3.Add a new column called “Income”. This column should be
numerical.
Income = c("5000","5870","6000","6564","7000","9800","6500")
exam_score = cbind(exam_score, Income)
exam_score
5.Find correlation between
(a)Age and score
(b)Age and income
(c)Score and income
cor(exam_score$Age,exam_score$Score)
[1] 0.05532898
cor(exam_score$Age,exam_score$Income)
[1] -0.09527187
cor(exam_score$Score,exam_score$Income)
[1] -0.1584965
6.Select rows where the score is greater than or equal to 80
exam_score[exam_score$Score >=80, ]
7.Select rows with the age range of 20 to 30
exam_score[exam_score$Age >=20 & exam_score$Age<=30, ]
8.Select rows with age 22, 25, and 30.
exam_score[exam_score$Age ==22 | exam_score$Age ==25 | exam_score$Age ==30, ]
LS0tDQp0aXRsZTogIkFzc2lnbm1lbnQgMihBZG5hbiBaYWhpZCBSaW9uKSINCm91dHB1dDogaHRtbF9ub3RlYm9vaw0KLS0tDQojIyAxLkNyZWF0ZSB0aGlzIGRhdGEgZnJhbWUuIA0KDQpgYGB7cn0NCmV4YW1fc2NvcmUgPSBkYXRhLmZyYW1lKA0KICBJRCA9IGMoMSwgMiwgMywgNCwgNSksDQogIE5hbWUgPSBjKCJBbGljZSIsICJCb2IiLCAiRGF2aWQiLCAiSm9obiIsICJKZW5ueSIpLA0KICBBZ2UgPSBjKDIwLCAyNSwgMzAsIDIyLCAxOCksDQogIFNjb3JlID0gYygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KKQ0KZXhhbV9zY29yZQ0KYGBgDQoNCiMjIDIuQWRkIDIgbmV3IHJvd3MNCg0KYGBge3J9DQpuZXdfcm93MSA9IGMoIjYiLCJNYXgiLCIyMyIsIjg1IikNCm5ld19yb3cyID0gYygiNyIsIkFsZXgiLCIyOCIsIjgwIikNCmV4YW1fc2NvcmUgPSByYmluZChleGFtX3Njb3JlLG5ld19yb3cxLG5ld19yb3cyKQ0KZXhhbV9zY29yZQ0KYGBgDQoNCiMjIDMuQWRkIGEgbmV3IGNvbHVtbiBjYWxsZWQg4oCcSW5jb21l4oCdLiBUaGlzIGNvbHVtbiBzaG91bGQgYmUgbnVtZXJpY2FsLiANCg0KYGBge3J9DQpJbmNvbWUgPSBjKCI1MDAwIiwiNTg3MCIsIjYwMDAiLCI2NTY0IiwiNzAwMCIsIjk4MDAiLCI2NTAwIikNCmV4YW1fc2NvcmUgPSBjYmluZChleGFtX3Njb3JlLCBJbmNvbWUpDQpleGFtX3Njb3JlDQpgYGANCg0KIyMgNC5GaW5kIG1heCwgbWluLCBtZWRpYW4sIHN1bSwgbWVhbiwgc3RhbmRhcmQgZGV2aWF0aW9uLCB2YXJpYW5jZSwgYW5kIHF1YW50aWxlcyBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUuIA0KDQpgYGB7cn0NCm1heChleGFtX3Njb3JlJEFnZSkNCm1pbihleGFtX3Njb3JlJEFnZSkNCm1lZGlhbihleGFtX3Njb3JlJEFnZSkNCmV4YW1fc2NvcmUkQWdlIDwtIGFzLm51bWVyaWMoYXMuY2hhcmFjdGVyKGV4YW1fc2NvcmUkQWdlKSkNCnN1bShleGFtX3Njb3JlJEFnZSkNCnNkKGV4YW1fc2NvcmUkQWdlKQ0KdmFyKGV4YW1fc2NvcmUkQWdlKQ0KcXVhbnRpbGUoZXhhbV9zY29yZSRBZ2UpDQoNCmBgYA0KDQpgYGB7cn0NCm1heChleGFtX3Njb3JlJFNjb3JlKQ0KbWluKGV4YW1fc2NvcmUkU2NvcmUpDQptZWRpYW4oZXhhbV9zY29yZSRTY29yZSkNCmV4YW1fc2NvcmUkU2NvcmUgPC0gYXMubnVtZXJpYyhhcy5jaGFyYWN0ZXIoZXhhbV9zY29yZSRTY29yZSkpDQpzdW0oZXhhbV9zY29yZSRTY29yZSkNCnNkKGV4YW1fc2NvcmUkU2NvcmUpDQp2YXIoZXhhbV9zY29yZSRTY29yZSkNCnF1YW50aWxlKGV4YW1fc2NvcmUkU2NvcmUpDQpgYGANCg0KYGBge3J9DQptYXgoZXhhbV9zY29yZSRJbmNvbWUpDQptaW4oZXhhbV9zY29yZSRJbmNvbWUpDQptZWRpYW4oZXhhbV9zY29yZSRJbmNvbWUpDQpleGFtX3Njb3JlJEluY29tZSA8LSBhcy5udW1lcmljKGFzLmNoYXJhY3RlcihleGFtX3Njb3JlJEluY29tZSkpDQpzdW0oZXhhbV9zY29yZSRJbmNvbWUpDQpzZChleGFtX3Njb3JlJEluY29tZSkNCnZhcihleGFtX3Njb3JlJEluY29tZSkNCnF1YW50aWxlKGV4YW1fc2NvcmUkSW5jb21lKQ0KYGBgDQoNCiMjIDUuRmluZCBjb3JyZWxhdGlvbiBiZXR3ZWVuIA0KIyMjIChhKUFnZSBhbmQgc2NvcmUgDQojIyMgKGIpQWdlIGFuZCBpbmNvbWUNCiMjIyAoYylTY29yZSBhbmQgaW5jb21lDQoNCmBgYHtyfQ0KY29yKGV4YW1fc2NvcmUkQWdlLGV4YW1fc2NvcmUkU2NvcmUpDQpgYGANCmBgYHtyfQ0KY29yKGV4YW1fc2NvcmUkQWdlLGV4YW1fc2NvcmUkSW5jb21lKQ0KYGBgDQpgYGB7cn0NCmNvcihleGFtX3Njb3JlJFNjb3JlLGV4YW1fc2NvcmUkSW5jb21lKQ0KYGBgDQojIyA2LlNlbGVjdCByb3dzIHdoZXJlIHRoZSBzY29yZSBpcyBncmVhdGVyIHRoYW4gb3IgZXF1YWwgdG8gODANCg0KYGBge3J9DQpleGFtX3Njb3JlW2V4YW1fc2NvcmUkU2NvcmUgPj04MCwgXQ0KYGBgDQojIyA3LlNlbGVjdCByb3dzIHdpdGggdGhlIGFnZSByYW5nZSBvZiAyMCB0byAzMA0KDQpgYGB7cn0NCmV4YW1fc2NvcmVbZXhhbV9zY29yZSRBZ2UgPj0yMCAmIGV4YW1fc2NvcmUkQWdlPD0zMCwgXQ0KYGBgDQojIyA4LlNlbGVjdCByb3dzIHdpdGggYWdlIDIyLCAyNSwgYW5kIDMwLg0KDQpgYGB7cn0NCmV4YW1fc2NvcmVbZXhhbV9zY29yZSRBZ2UgPT0yMiB8IGV4YW1fc2NvcmUkQWdlID09MjUgfCBleGFtX3Njb3JlJEFnZSA9PTMwLCBdDQpgYGANCg0K