Creating Data Frames
kids <- c("Mark","John")
ages <- c(9,12)
ka <- data.frame(kids,ages,stringsAsFactors=FALSE)
ka
Accessing Data Frame and exploring it. Getting the fist row in three
different ways
ka[[1]]
[1] "Mark" "John"
ka$kids
[1] "Mark" "John"
ka[,1]
[1] "Mark" "John"
Getting the structure of ka with str()
str(ka)
'data.frame': 2 obs. of 2 variables:
$ kids: chr "Mark" "John"
$ ages: num 9 12
Regression Analysis of Exam Grades Continued
getwd()
[1] "C:/Users/f0874999/Downloads"
Importing the data frame
examsquiz <- read.csv("ExamsQuiz.csv",sep=",",header=TRUE)
Getting the first 7 rows
Other Matrix-Like Operations
Getting to show row 2 to 5 in all columns
Getting to show row 2 to 5 of columns 2
examsquiz[2:5,2]
[1] 3.2 2.0 4.0 2.0
Getting the class of an spesific part of a data frame
class(examsquiz[2:5,2])
[1] "numeric"
“cutting” a part of the data frame
examsquiz[2:5,2,drop=FALSE]
Getting the class of the data frame
class(examsquiz[2:5,2,drop=FALSE])
[1] "data.frame"
Extractig the sub frame of all students whose second exam score was
at least 3.8:
examsquiz[examsquiz$Exam2 >= 3.8,]
More on Treatment of NA Values
Getting a NA mean bc the vector has a NA value
k <- c(9,5,NA)
mean(k)
[1] NA
Removing th Na value with na.rm=True function
mean(k,na.rm=TRUE)
[1] 7
Other way of getting all students whose second exam score was at
least 3.8:
examsquiz[examsquiz$Exam2 >= 3.8,]
Other way of getting all students whose second exam score was at
least 3.8:
subset(examsquiz,Exam2 >= 3.8)
NA
NA
LS0tDQp0aXRsZTogIkluIGNsYXNzIEFjdGl2aXR5IDkiDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KDQoNCg0KDQpDcmVhdGluZyBEYXRhIEZyYW1lcw0KDQoNCmBgYHtyfQ0Ka2lkcyA8LSBjKCJNYXJrIiwiSm9obiIpDQphZ2VzIDwtIGMoOSwxMikNCmthIDwtIGRhdGEuZnJhbWUoa2lkcyxhZ2VzLHN0cmluZ3NBc0ZhY3RvcnM9RkFMU0UpDQprYSANCmBgYA0KDQoNCg0KQWNjZXNzaW5nIERhdGEgRnJhbWUgYW5kIGV4cGxvcmluZyBpdC4gR2V0dGluZyB0aGUgZmlzdCByb3cgaW4gdGhyZWUgZGlmZmVyZW50IHdheXMgDQoNCmBgYHtyfQ0Ka2FbWzFdXQ0Ka2Eka2lkcw0Ka2FbLDFdDQpgYGANCg0KR2V0dGluZyB0aGUgc3RydWN0dXJlIG9mIGthIHdpdGggc3RyKCkNCmBgYHtyfQ0Kc3RyKGthKQ0KYGBgDQoNCg0KKipSZWdyZXNzaW9uIEFuYWx5c2lzIG9mIEV4YW0gR3JhZGVzIENvbnRpbnVlZCoqDQoNCmBgYHtyfQ0KZ2V0d2QoKQ0KYGBgDQoNCkltcG9ydGluZyB0aGUgZGF0YSBmcmFtZQ0KYGBge3J9DQpleGFtc3F1aXogPC0gcmVhZC5jc3YoIkV4YW1zUXVpei5jc3YiLHNlcD0iLCIsaGVhZGVyPVRSVUUpDQpgYGANCg0KR2V0dGluZyB0aGUgZmlyc3QgNyByb3dzDQpgYGB7cn0NCmhlYWQoZXhhbXNxdWl6KQ0KYGBgDQoNCioqT3RoZXIgTWF0cml4LUxpa2UgT3BlcmF0aW9ucyoqDQoNCg0KR2V0dGluZyB0byBzaG93IHJvdyAyIHRvIDUgaW4gYWxsIGNvbHVtbnMNCmBgYHtyfQ0KZXhhbXNxdWl6WzI6NSxdDQpgYGANCg0KDQoNCkdldHRpbmcgdG8gc2hvdyByb3cgMiB0byA1IG9mIGNvbHVtbnMgMg0KDQpgYGB7cn0NCmV4YW1zcXVpelsyOjUsMl0NCmBgYA0KR2V0dGluZyB0aGUgY2xhc3Mgb2YgYW4gc3Blc2lmaWMgcGFydCBvZiBhIGRhdGEgZnJhbWUNCmBgYHtyfQ0KY2xhc3MoZXhhbXNxdWl6WzI6NSwyXSkNCmBgYA0KImN1dHRpbmciIGEgcGFydCBvZiB0aGUgZGF0YSBmcmFtZQ0KYGBge3J9DQpleGFtc3F1aXpbMjo1LDIsZHJvcD1GQUxTRV0NCmBgYA0KDQpHZXR0aW5nIHRoZSBjbGFzcyBvZiB0aGUgZGF0YSBmcmFtZQ0KYGBge3J9DQpjbGFzcyhleGFtc3F1aXpbMjo1LDIsZHJvcD1GQUxTRV0pDQpgYGANCg0KDQpFeHRyYWN0aWcgdGhlIHN1YiBmcmFtZSBvZiBhbGwgc3R1ZGVudHMgd2hvc2Ugc2Vjb25kIGV4YW0gc2NvcmUgd2FzIGF0IGxlYXN0IDMuODoNCmBgYHtyfQ0KZXhhbXNxdWl6W2V4YW1zcXVpeiRFeGFtMiA+PSAzLjgsXQ0KYGBgDQoNCg0KKipNb3JlIG9uIFRyZWF0bWVudCBvZiBOQSBWYWx1ZXMqKg0KDQoNCkdldHRpbmcgYSBOQSBtZWFuIGJjIHRoZSB2ZWN0b3IgaGFzIGEgTkEgdmFsdWUNCmBgYHtyfQ0KayA8LSBjKDksNSxOQSkNCm1lYW4oaykNCmBgYA0KDQpSZW1vdmluZyB0aCBOYSB2YWx1ZSB3aXRoIG5hLnJtPVRydWUgZnVuY3Rpb24NCmBgYHtyfQ0KbWVhbihrLG5hLnJtPVRSVUUpDQpgYGANCg0KDQpPdGhlciB3YXkgb2YgZ2V0dGluZyBhbGwgc3R1ZGVudHMgd2hvc2Ugc2Vjb25kIGV4YW0gc2NvcmUgd2FzIGF0IGxlYXN0IDMuODoNCmBgYHtyfQ0KZXhhbXNxdWl6W2V4YW1zcXVpeiRFeGFtMiA+PSAzLjgsXQ0KYGBgDQoNCg0KT3RoZXIgd2F5IG9mIGdldHRpbmcgYWxsIHN0dWRlbnRzIHdob3NlIHNlY29uZCBleGFtIHNjb3JlIHdhcyBhdCBsZWFzdCAzLjg6DQpgYGB7cn0NCnN1YnNldChleGFtc3F1aXosRXhhbTIgPj0gMy44KQ0KDQoNCmBgYA0KDQoNCg0KDQo=