Question 01: Given a data frame as following:
- 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))Create the data frame. Add 2 new rows.
- Add a new column called “Income”. This column should be numerical.
Find max, min, median, sum, mean, standard deviation, variance, and
quantiles of columns Age, Score, and Income.
Question 02: Find correlation between
- Age and score
- Age and income
- Score and income
- Select rows where the score is greater than or equal to 80
- Select rows with the age range of 20 to 30
Q1 Answer:
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
# Add 2 rows
new_row = data.frame(
ID = c(6,7),
Name = c("Zarraf","Tajwar"),
Age = c(28,33),
Score= c(85,95)
)
updated_examscore = rbind(exam_score,new_row)
updated_examscore
NA
NA
#Add a new column called “Income”. This column should be numerical.
Income= c(5000,5500,6000,6500,7000,7500,8000)
New_scoredata=cbind(updated_examscore,Income)
New_scoredata
NA
NA
NA
Question 02: Find correlation between
- Age and score
- Age and income
- Score and income
- Select rows where the score is greater than or equal to 80
- Select rows with the age range of 20 to 30
Q2 Answer:
# Correlation between Age and Score
Correlation= cor(New_scoredata$Age, New_scoredata$Score)
Correlation
[1] 0.3087388
# Correlation between Age and Income
Correlation= cor(New_scoredata$Age, New_scoredata$Income)
Correlation
[1] 0.463732
# Correlation between Score and Income
Correlation= cor(New_scoredata$Score, New_scoredata$Income)
Correlation
[1] -0.05246038
# Select rows where the score is greater than or equal to 80
New_scoredata[New_scoredata$Score>=80, ]
NA
# Select rows with the age range of 20 to 30
New_scoredata[New_scoredata$Age>=20 & New_scoredata$Age<=30, ]
NA
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KDQojIyMjIFF1ZXN0aW9uIDAxOiBHaXZlbiBhIGRhdGEgZnJhbWUgYXMgZm9sbG93aW5nOiANCiAgKiBleGFtX3Njb3JlID0gZGF0YS5mcmFtZSggSUQgPSBjKDEsIDIsIDMsIDQsIDUpLCAgTmFtZSA9IGMoIkFsaWNlIiwgIkJvYiIsICJEYXZpZCIsICJKb2huIiwgIkplbm55IiksICBBZ2UgPSBjKDIwLCAyNSwgMzAsIDIyLCAxOCksICBTY29yZSA9IGMoMTAwLCA3OCwgOTAsIDU1LCA4MSkpQ3JlYXRlIHRoZSBkYXRhIGZyYW1lLiBBZGQgMiBuZXcgcm93cy4gDQogICogQWRkIGEgbmV3IGNvbHVtbiBjYWxsZWQg4oCcSW5jb21l4oCdLiBUaGlzIGNvbHVtbiBzaG91bGQgYmUgbnVtZXJpY2FsLiBGaW5kIG1heCwgbWluLCBtZWRpYW4sIHN1bSwgbWVhbiwgc3RhbmRhcmQgZGV2aWF0aW9uLCB2YXJpYW5jZSwgYW5kIHF1YW50aWxlcyBvZiBjb2x1bW5zIEFnZSwgU2NvcmUsIGFuZCBJbmNvbWUuIA0KDQojIyMjIFF1ZXN0aW9uIDAyOiBGaW5kIGNvcnJlbGF0aW9uIGJldHdlZW4gDQogICogQWdlIGFuZCBzY29yZSANCiAgKiBBZ2UgYW5kIGluY29tZQ0KICAqIFNjb3JlIGFuZCBpbmNvbWUNCiAgKiBTZWxlY3Qgcm93cyB3aGVyZSB0aGUgc2NvcmUgaXMgZ3JlYXRlciB0aGFuIG9yIGVxdWFsIHRvIDgwDQogICogU2VsZWN0IHJvd3Mgd2l0aCB0aGUgYWdlIHJhbmdlIG9mIDIwIHRvIDMwICANCg0KIyMjIyBRMSBBbnN3ZXI6DQpgYGB7cn0NCiMgQ3JlYXRpbmcgZGF0YSBmcmFtZToJDQoNCmV4YW1fc2NvcmUgPSBkYXRhLmZyYW1lKA0KICBJRCA9IGMoMSwgMiwgMywgNCwgNSksDQogIE5hbWUgPSBjKCJBbGljZSIsICJCb2IiLCAiRGF2aWQiLCAiSm9obiIsICJKZW5ueSIpLA0KICBBZ2UgPSBjKDIwLCAyNSwgMzAsIDIyLCAxOCksDQogIFNjb3JlID0gYygxMDAsIDc4LCA5MCwgNTUsIDgxKQ0KKQ0KZXhhbV9zY29yZQ0KDQpgYGANCg0KYGBge3J9DQojIEFkZCAyIHJvd3MNCg0KbmV3X3JvdyA9IGRhdGEuZnJhbWUoDQogIElEID0gYyg2LDcpLA0KICBOYW1lID0gYygiWmFycmFmIiwiVGFqd2FyIiksDQogIEFnZSA9IGMoMjgsMzMpLA0KICBTY29yZT0gYyg4NSw5NSkNCikNCnVwZGF0ZWRfZXhhbXNjb3JlID0gcmJpbmQoZXhhbV9zY29yZSxuZXdfcm93KQ0KDQp1cGRhdGVkX2V4YW1zY29yZQ0KDQoNCmBgYA0KYGBge3J9DQojQWRkIGEgbmV3IGNvbHVtbiBjYWxsZWQg4oCcSW5jb21l4oCdLiBUaGlzIGNvbHVtbiBzaG91bGQgYmUgbnVtZXJpY2FsLg0KDQpJbmNvbWU9IGMoNTAwMCw1NTAwLDYwMDAsNjUwMCw3MDAwLDc1MDAsODAwMCkNCg0KTmV3X3Njb3JlZGF0YT1jYmluZCh1cGRhdGVkX2V4YW1zY29yZSxJbmNvbWUpDQoNCk5ld19zY29yZWRhdGENCg0KYGBgDQoNCiMjIyMgUXVlc3Rpb24gMDI6IEZpbmQgY29ycmVsYXRpb24gYmV0d2VlbiANCiAgKiBBZ2UgYW5kIHNjb3JlIA0KICAqIEFnZSBhbmQgaW5jb21lDQogICogU2NvcmUgYW5kIGluY29tZQ0KICAqIFNlbGVjdCByb3dzIHdoZXJlIHRoZSBzY29yZSBpcyBncmVhdGVyIHRoYW4gb3IgZXF1YWwgdG8gODANCiAgKiBTZWxlY3Qgcm93cyB3aXRoIHRoZSBhZ2UgcmFuZ2Ugb2YgMjAgdG8gMzAgIA0KICANCiMjIyMgUTIgQW5zd2VyOg0KDQpgYGB7cn0NCiMgQ29ycmVsYXRpb24gYmV0d2VlbiBBZ2UgYW5kIFNjb3JlDQoNCkNvcnJlbGF0aW9uPSBjb3IoTmV3X3Njb3JlZGF0YSRBZ2UsIE5ld19zY29yZWRhdGEkU2NvcmUpDQpDb3JyZWxhdGlvbg0KDQojIENvcnJlbGF0aW9uIGJldHdlZW4gQWdlIGFuZCBJbmNvbWUNCg0KQ29ycmVsYXRpb249IGNvcihOZXdfc2NvcmVkYXRhJEFnZSwgTmV3X3Njb3JlZGF0YSRJbmNvbWUpDQpDb3JyZWxhdGlvbg0KDQojIENvcnJlbGF0aW9uIGJldHdlZW4gU2NvcmUgYW5kIEluY29tZQ0KDQpDb3JyZWxhdGlvbj0gY29yKE5ld19zY29yZWRhdGEkU2NvcmUsIE5ld19zY29yZWRhdGEkSW5jb21lKQ0KQ29ycmVsYXRpb24NCg0KYGBgDQpgYGB7cn0NCiMgU2VsZWN0IHJvd3Mgd2hlcmUgdGhlIHNjb3JlIGlzIGdyZWF0ZXIgdGhhbiBvciBlcXVhbCB0byA4MA0KDQpOZXdfc2NvcmVkYXRhW05ld19zY29yZWRhdGEkU2NvcmU+PTgwLCBdDQoNCmBgYA0KYGBge3J9DQojIFNlbGVjdCByb3dzIHdpdGggdGhlIGFnZSByYW5nZSBvZiAyMCB0byAzMA0KTmV3X3Njb3JlZGF0YVtOZXdfc2NvcmVkYXRhJEFnZT49MjAgJiBOZXdfc2NvcmVkYXRhJEFnZTw9MzAsIF0NCg0KYGBgDQo=