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 1st row

new_row1= c(ID= 6,Name="Mike", Age=27, Score= 70)
exam_score= rbind(exam_score,new_row1)
exam_score

Add 2nd row

new_row2= c(7,"Jack",32,85 )
exam_score= rbind(exam_score, new_row2)
exam_score

Add column

Income= c(15000,30000,45000,42000,32000,20000,25000)
exam_score= cbind(exam_score, Income)
exam_score
mode(Income)
[1] "numeric"
exam_score[ ,c(3,4,5)]
exam_score$Age= as.numeric(exam_score$Age)
exam_score$Score= as.numeric(exam_score$Score)
exam_score

Simple stat of age

max(exam_score$Age)
[1] 32
min(exam_score$Age)
[1] 18
median(exam_score$Age)
[1] 25
sum(exam_score$Age)
[1] 174
mean(exam_score$Age)
[1] 24.85714
sd(exam_score$Age)
[1] 5.177791
var(exam_score$Age)
[1] 26.80952
quantile(exam_score$Age)
  0%  25%  50%  75% 100% 
18.0 21.0 25.0 28.5 32.0 

Simple stat of score

max(exam_score$Score)
[1] 100
min(exam_score$Score)
[1] 55
median(exam_score$Score)
[1] 81
sum(exam_score$Score)
[1] 559
mean(exam_score$Score)
[1] 79.85714
sd(exam_score$Score)
[1] 14.46177
var(exam_score$Score)
[1] 209.1429
quantile(exam_score$Score)
   0%   25%   50%   75%  100% 
 55.0  74.0  81.0  87.5 100.0 

Simple stat of income

max(Income)
[1] 45000
min(Income)
[1] 15000
median(Income)
[1] 30000
sum(Income)
[1] 209000
mean(Income)
[1] 29857.14
sd(Income)
[1] 10976.16
var(Income)
[1] 120476190
quantile(Income)
   0%   25%   50%   75%  100% 
15000 22500 30000 37000 45000 

Correlation

#cor(exam_score$Age, exam_score$Score)
exam_score

Select rows where the score is greater than or equal to 80

exam_score[exam_score$Score>=80, ]

Select rows with the age range of 20 to 30

exam_score[exam_score$Age>=20 & exam_score$Age <= 30, ]
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6DQogIGh0bWxfbm90ZWJvb2s6IGRlZmF1bHQNCiAgaHRtbF9kb2N1bWVudDoNCiAgICBkZl9wcmludDogcGFnZWQNCiAgcGRmX2RvY3VtZW50OiBkZWZhdWx0DQotLS0NCg0KYGBge3J9DQpleGFtX3Njb3JlPSBkYXRhLmZyYW1lKA0KICBJRD0gYygxLDIsMyw0LDUpLA0KICBOYW1lPWMoIkFsaWNlIiwiQm9iIiwiRGF2aWQiLCJKb2huIiwiSmVubnkiKSwNCiAgQWdlPSBjKDIwLCAyNSwgMzAsIDIyLCAxOCksDQogIFNjb3JlPWMoMTAwLCA3OCwgOTAsIDU1LCA4MSkNCikNCmBgYA0KDQpgYGB7cn0NCmV4YW1fc2NvcmUNCmBgYA0KDQojIyBhZGQgMXN0IHJvdw0KYGBge3J9DQpuZXdfcm93MT0gYyhJRD0gNixOYW1lPSJNaWtlIiwgQWdlPTI3LCBTY29yZT0gNzApDQpleGFtX3Njb3JlPSByYmluZChleGFtX3Njb3JlLG5ld19yb3cxKQ0KZXhhbV9zY29yZQ0KYGBgDQojIyBBZGQgMm5kIHJvdw0KYGBge3J9DQpuZXdfcm93Mj0gYyg3LCJKYWNrIiwzMiw4NSApDQpleGFtX3Njb3JlPSByYmluZChleGFtX3Njb3JlLCBuZXdfcm93MikNCmV4YW1fc2NvcmUNCmBgYA0KDQojIyBBZGQgY29sdW1uDQpgYGB7cn0NCkluY29tZT0gYygxNTAwMCwzMDAwMCw0NTAwMCw0MjAwMCwzMjAwMCwyMDAwMCwyNTAwMCkNCmV4YW1fc2NvcmU9IGNiaW5kKGV4YW1fc2NvcmUsIEluY29tZSkNCmBgYA0KDQpgYGB7cn0NCmV4YW1fc2NvcmUNCmBgYA0KYGBge3J9DQptb2RlKEluY29tZSkNCmBgYA0KDQpgYGB7cn0NCmV4YW1fc2NvcmVbICxjKDMsNCw1KV0NCmBgYA0KDQpgYGB7cn0NCmV4YW1fc2NvcmUkQWdlPSBhcy5udW1lcmljKGV4YW1fc2NvcmUkQWdlKQ0KZXhhbV9zY29yZSRTY29yZT0gYXMubnVtZXJpYyhleGFtX3Njb3JlJFNjb3JlKQ0KZXhhbV9zY29yZQ0KYGBgDQoNCg0KIyMgU2ltcGxlIHN0YXQgb2YgYWdlDQpgYGB7cn0NCm1heChleGFtX3Njb3JlJEFnZSkNCm1pbihleGFtX3Njb3JlJEFnZSkNCm1lZGlhbihleGFtX3Njb3JlJEFnZSkNCnN1bShleGFtX3Njb3JlJEFnZSkNCm1lYW4oZXhhbV9zY29yZSRBZ2UpDQpzZChleGFtX3Njb3JlJEFnZSkNCnZhcihleGFtX3Njb3JlJEFnZSkNCnF1YW50aWxlKGV4YW1fc2NvcmUkQWdlKQ0KYGBgDQoNCiMjIFNpbXBsZSBzdGF0IG9mIHNjb3JlDQpgYGB7cn0NCm1heChleGFtX3Njb3JlJFNjb3JlKQ0KbWluKGV4YW1fc2NvcmUkU2NvcmUpDQptZWRpYW4oZXhhbV9zY29yZSRTY29yZSkNCnN1bShleGFtX3Njb3JlJFNjb3JlKQ0KbWVhbihleGFtX3Njb3JlJFNjb3JlKQ0Kc2QoZXhhbV9zY29yZSRTY29yZSkNCnZhcihleGFtX3Njb3JlJFNjb3JlKQ0KcXVhbnRpbGUoZXhhbV9zY29yZSRTY29yZSkNCmBgYA0KDQoNCiMjIFNpbXBsZSBzdGF0IG9mIGluY29tZQ0KYGBge3J9DQptYXgoSW5jb21lKQ0KbWluKEluY29tZSkNCm1lZGlhbihJbmNvbWUpDQpzdW0oSW5jb21lKQ0KbWVhbihJbmNvbWUpDQpzZChJbmNvbWUpDQp2YXIoSW5jb21lKQ0KcXVhbnRpbGUoSW5jb21lKQ0KYGBgDQoNCg0KIyMgQ29ycmVsYXRpb24NCmBgYHtyfQ0KI2NvcihleGFtX3Njb3JlJEFnZSwgZXhhbV9zY29yZSRTY29yZSkNCmBgYA0KDQpgYGB7cn0NCmV4YW1fc2NvcmUNCmBgYA0KDQoNCiMjIFNlbGVjdCByb3dzIHdoZXJlIHRoZSBzY29yZSBpcyBncmVhdGVyIHRoYW4gb3IgZXF1YWwgdG8gODANCg0KYGBge3J9DQpleGFtX3Njb3JlW2V4YW1fc2NvcmUkU2NvcmU+PTgwLCBdDQpgYGANCg0KIyMgU2VsZWN0IHJvd3Mgd2l0aCB0aGUgYWdlIHJhbmdlIG9mIDIwIHRvIDMwICANCmBgYHtyfQ0KZXhhbV9zY29yZVtleGFtX3Njb3JlJEFnZT49MjAgJiBleGFtX3Njb3JlJEFnZSA8PSAzMCwgXQ0KYGBgDQo=