This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.
When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:
library("pacman")
library("tidyverse")
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.3.6 ✔ purrr 0.3.4
## ✔ tibble 3.1.7 ✔ dplyr 1.0.9
## ✔ tidyr 1.2.0 ✔ stringr 1.4.0
## ✔ readr 2.1.2 ✔ forcats 0.5.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
Star <- read.csv("Star.csv")
summary(Star)
## X tmathssk treadssk classk
## Min. : 2 Min. :320.0 Min. :315.0 Length:5748
## 1st Qu.: 2885 1st Qu.:454.0 1st Qu.:414.0 Class :character
## Median : 5734 Median :484.0 Median :433.0 Mode :character
## Mean : 5753 Mean :485.6 Mean :436.7
## 3rd Qu.: 8624 3rd Qu.:513.0 3rd Qu.:453.0
## Max. :11598 Max. :626.0 Max. :627.0
## totexpk sex freelunk race
## Min. : 0.000 Length:5748 Length:5748 Length:5748
## 1st Qu.: 5.000 Class :character Class :character Class :character
## Median : 9.000 Mode :character Mode :character Mode :character
## Mean : 9.307
## 3rd Qu.:13.000
## Max. :27.000
## schidkn
## Min. : 1.00
## 1st Qu.:20.00
## Median :39.00
## Mean :39.84
## 3rd Qu.:60.00
## Max. :80.00
data(Star)
## Warning in data(Star): data set 'Star' not found
head(Star)
## X tmathssk treadssk classk totexpk sex freelunk race schidkn
## 1 2 473 447 small.class 7 girl no white 63
## 2 3 536 450 small.class 21 girl no black 20
## 3 5 463 439 regular.with.aide 0 boy yes black 19
## 4 11 559 448 regular 16 boy no white 69
## 5 12 489 447 small.class 5 boy yes white 79
## 6 13 454 431 regular 8 boy yes white 5
mean(Star$tmathssk)
## [1] 485.6481
median(Star$tmathssk)
## [1] 484
mean(Star$treadssk)
## [1] 436.7423
median(Star$treadssk)
## [1] 433
df.star <- data.frame(Star)
substar <- df.star[df.star$tmathssk >= 500 & df.star$treadssk >= 500, c("X", "tmathssk", "treadssk", "classk", "sex", "race")]
substar
## X tmathssk treadssk classk sex race
## 27 54 559 522 regular girl white
## 106 229 536 507 regular.with.aide boy white
## 151 324 547 565 regular.with.aide boy white
## 166 358 513 503 small.class boy white
## 176 377 559 605 regular.with.aide boy white
## 197 415 559 554 regular girl white
## 216 455 559 503 regular boy white
## 256 523 602 518 regular girl white
## 266 542 536 580 small.class girl black
## 281 566 626 510 small.class girl white
## 312 636 602 518 small.class boy black
## 325 653 626 580 regular.with.aide girl white
## 404 833 626 565 small.class boy white
## 406 838 513 538 regular boy white
## 411 844 559 510 regular.with.aide boy white
## 416 850 559 518 regular.with.aide boy black
## 560 1153 547 507 regular girl white
## 604 1242 602 503 small.class boy white
## 626 1282 513 532 regular.with.aide girl white
## 722 1450 576 538 regular.with.aide girl white
## 750 1507 626 538 small.class girl black
## 814 1618 528 500 regular.with.aide girl black
## 868 1739 500 580 small.class girl white
## 905 1817 576 545 small.class boy white
## 930 1860 602 538 small.class girl black
## 936 1871 506 514 regular boy white
## 943 1886 576 507 regular boy white
## 956 1916 576 503 small.class girl white
## 988 1970 576 538 small.class boy white
## 1048 2122 513 545 regular.with.aide girl white
## 1099 2213 520 518 regular.with.aide boy white
## 1158 2336 513 503 regular.with.aide boy white
## 1173 2360 506 507 regular girl white
## 1209 2435 536 522 small.class girl white
## 1277 2562 559 565 small.class boy white
## 1284 2573 576 627 regular.with.aide boy white
## 1359 2716 626 510 regular.with.aide boy black
## 1364 2732 626 518 small.class boy black
## 1379 2763 547 522 regular boy white
## 1431 2870 513 545 regular.with.aide boy white
## 1467 2946 626 554 regular girl white
## 1511 3028 576 580 regular.with.aide girl white
## 1525 3053 559 565 regular girl white
## 1571 3131 576 507 regular.with.aide boy white
## 1587 3156 506 527 regular.with.aide boy white
## 1597 3181 547 514 regular boy white
## 1600 3185 626 545 regular.with.aide girl white
## 1635 3245 626 580 regular girl white
## 1647 3273 513 503 regular girl black
## 1665 3311 520 532 small.class boy white
## 1676 3332 528 580 regular boy white
## 1677 3333 547 527 small.class boy white
## 1714 3424 576 605 regular girl white
## 1756 3510 547 503 small.class girl white
## 1770 3529 602 500 regular.with.aide girl black
## 1787 3566 559 532 regular girl white
## 1817 3624 559 500 small.class boy black
## 1831 3654 576 627 small.class boy white
## 1863 3724 626 518 regular.with.aide girl white
## 1871 3742 626 518 regular.with.aide girl black
## 1974 3927 528 514 small.class boy white
## 1979 3938 506 538 regular girl white
## 1982 3942 520 518 regular.with.aide girl white
## 2005 3986 602 507 regular girl white
## 2011 3997 576 580 small.class boy white
## 2034 4046 559 503 small.class boy white
## 2090 4155 602 514 regular boy white
## 2135 4233 506 514 regular.with.aide boy black
## 2160 4273 626 627 regular.with.aide girl black
## 2192 4323 513 554 small.class girl white
## 2195 4333 520 518 regular girl white
## 2237 4430 547 527 small.class boy white
## 2275 4508 547 510 regular.with.aide girl white
## 2296 4555 626 510 regular.with.aide girl white
## 2300 4559 626 580 small.class boy white
## 2311 4581 576 503 small.class girl black
## 2317 4588 576 518 small.class girl white
## 2320 4595 500 507 regular.with.aide boy white
## 2336 4632 559 507 regular girl white
## 2354 4665 576 532 regular.with.aide girl white
## 2359 4677 626 627 small.class girl white
## 2384 4736 602 503 small.class girl white
## 2389 4744 528 545 regular.with.aide boy black
## 2410 4799 602 538 regular.with.aide girl black
## 2414 4805 559 580 small.class girl white
## 2428 4828 528 500 small.class girl white
## 2443 4857 536 507 regular.with.aide girl white
## 2476 4937 559 510 regular girl white
## 2477 4938 626 538 regular girl black
## 2478 4939 559 507 regular.with.aide boy black
## 2496 4973 626 522 regular girl black
## 2528 5036 520 545 regular.with.aide girl white
## 2545 5062 559 580 regular.with.aide girl white
## 2563 5102 536 507 regular boy white
## 2568 5109 626 518 small.class boy white
## 2605 5191 506 500 regular.with.aide boy black
## 2620 5220 576 522 small.class girl white
## 2671 5313 547 500 small.class girl white
## 2672 5315 559 514 small.class boy white
## 2716 5394 602 554 regular girl white
## 2717 5396 602 503 regular.with.aide boy white
## 2729 5420 576 514 regular boy white
## 2731 5426 576 580 regular boy white
## 2772 5516 626 514 regular girl white
## 2773 5517 528 514 regular.with.aide girl white
## 2777 5526 602 554 regular.with.aide boy white
## 2882 5750 602 500 regular girl white
## 2898 5779 626 545 regular girl white
## 2957 5894 626 545 regular.with.aide boy white
## 2979 5924 576 507 small.class girl white
## 3047 6058 602 522 small.class girl black
## 3062 6084 506 518 regular girl white
## 3065 6087 576 605 regular.with.aide boy white
## 3104 6170 626 627 small.class boy white
## 3126 6199 559 514 small.class girl white
## 3139 6230 520 514 regular boy white
## 3141 6237 506 527 regular girl white
## 3166 6290 559 503 regular.with.aide girl black
## 3174 6304 602 627 regular girl white
## 3184 6327 528 503 regular boy white
## 3216 6401 536 538 regular.with.aide boy white
## 3218 6407 536 500 small.class girl black
## 3239 6454 500 500 regular boy white
## 3246 6467 626 507 small.class boy white
## 3247 6468 559 565 regular.with.aide girl white
## 3251 6472 547 554 regular girl white
## 3292 6547 626 538 small.class girl black
## 3306 6582 536 554 small.class girl white
## 3312 6593 520 510 small.class boy white
## 3374 6723 576 565 regular.with.aide boy white
## 3395 6766 602 518 regular girl white
## 3451 6881 536 605 regular.with.aide girl white
## 3465 6909 559 518 small.class girl black
## 3471 6921 559 503 regular girl white
## 3473 6933 576 605 small.class boy white
## 3543 7076 547 538 small.class girl white
## 3565 7116 602 545 regular.with.aide girl black
## 3575 7134 602 518 regular.with.aide girl white
## 3577 7138 559 503 small.class boy white
## 3580 7144 626 565 regular.with.aide boy white
## 3655 7293 626 545 regular.with.aide girl black
## 3665 7321 547 527 small.class boy white
## 3736 7462 576 532 regular girl white
## 3756 7502 576 580 regular.with.aide boy white
## 3801 7591 547 522 small.class girl white
## 3852 7694 547 518 regular.with.aide girl white
## 3876 7734 626 500 regular boy black
## 3899 7787 559 554 small.class girl white
## 3907 7806 602 554 regular.with.aide boy black
## 3959 7918 513 510 regular girl white
## 3975 7953 626 605 regular.with.aide girl white
## 4005 8021 520 503 small.class girl black
## 4035 8081 520 510 regular.with.aide boy white
## 4051 8135 520 554 regular girl white
## 4055 8140 626 580 regular.with.aide girl white
## 4106 8231 626 510 regular.with.aide boy white
## 4158 8327 536 527 small.class girl white
## 4189 8388 626 522 small.class girl white
## 4210 8421 602 503 small.class boy white
## 4218 8435 513 500 regular boy white
## 4242 8481 559 545 small.class boy white
## 4249 8497 602 500 small.class boy white
## 4307 8613 626 538 regular.with.aide boy white
## 4312 8625 602 518 regular boy black
## 4340 8683 602 503 regular boy white
## 4344 8694 536 545 regular girl white
## 4350 8706 520 510 small.class girl black
## 4351 8709 520 545 regular.with.aide girl white
## 4451 8931 513 500 regular.with.aide boy black
## 4465 8955 602 522 regular girl white
## 4480 8984 626 532 regular girl white
## 4512 9045 602 500 small.class girl white
## 4570 9170 576 510 regular.with.aide girl white
## 4643 9316 547 532 small.class girl white
## 4681 9397 536 522 regular boy white
## 4695 9423 528 565 regular.with.aide girl other
## 4710 9454 602 514 small.class girl white
## 4734 9505 602 565 regular.with.aide boy white
## 4768 9572 536 518 regular.with.aide girl white
## 4780 9588 602 538 regular.with.aide girl white
## 4816 9658 626 510 small.class boy white
## 4837 9698 559 507 regular.with.aide boy white
## 4877 9779 626 518 regular boy black
## 4905 9840 547 510 regular boy white
## 4941 9915 547 605 regular boy white
## 4981 9988 500 538 small.class boy white
## 4984 9991 576 503 regular boy white
## 4996 10011 559 500 regular girl white
## 4998 10014 528 503 small.class girl white
## 5009 10037 626 527 small.class girl black
## 5039 10105 559 500 small.class girl white
## 5043 10110 602 554 small.class girl white
## 5146 10329 576 554 regular girl black
## 5197 10429 528 538 small.class girl white
## 5238 10522 602 527 small.class boy white
## 5246 10535 547 532 small.class boy white
## 5277 10601 528 514 regular.with.aide boy black
## 5290 10629 626 545 regular girl white
## 5311 10665 547 503 regular girl white
## 5339 10721 576 518 small.class girl black
## 5403 10843 547 554 regular.with.aide girl black
## 5416 10864 576 503 regular.with.aide girl black
## 5486 11027 547 500 small.class boy white
## 5535 11138 559 545 regular.with.aide boy white
## 5537 11141 602 545 small.class girl white
## 5554 11183 536 522 regular.with.aide girl white
## 5581 11255 576 518 small.class girl white
## 5600 11284 576 510 small.class girl white
## 5617 11316 576 545 small.class girl white
## 5651 11388 559 510 regular boy white
## 5656 11399 513 500 small.class girl black
## 5709 11496 576 500 small.class girl white
## 5742 11586 528 605 small.class girl white
colnames(substar)
## [1] "X" "tmathssk" "treadssk" "classk" "sex" "race"
colnames(substar)[1:6] = c("STUDENT ID", "MATH SCORE", "READING SCORE", "CLASS TYPE", "GENDER", "RACE")
head(substar)
## STUDENT ID MATH SCORE READING SCORE CLASS TYPE GENDER RACE
## 27 54 559 522 regular girl white
## 106 229 536 507 regular.with.aide boy white
## 151 324 547 565 regular.with.aide boy white
## 166 358 513 503 small.class boy white
## 176 377 559 605 regular.with.aide boy white
## 197 415 559 554 regular girl white
summary(substar)
## STUDENT ID MATH SCORE READING SCORE CLASS TYPE
## Min. : 54 Min. :500.0 Min. :500.0 Length:213
## 1st Qu.: 3510 1st Qu.:536.0 1st Qu.:507.0 Class :character
## Median : 5750 Median :559.0 Median :522.0 Mode :character
## Mean : 5878 Mean :567.1 Mean :532.2
## 3rd Qu.: 8435 3rd Qu.:602.0 3rd Qu.:545.0
## Max. :11586 Max. :626.0 Max. :627.0
## GENDER RACE
## Length:213 Length:213
## Class :character Class :character
## Mode :character Mode :character
##
##
##
mean(substar$'MATH SCORE')
## [1] 567.1221
# The average in MATH SCORE in substar dataframe is more than the average in tmathssk in Star dataframe.
median(substar$`MATH SCORE`)
## [1] 559
# The median in MATH SCORE in substar dataframe is more than the average in tmathssk in Star dataframe.
mean(substar$`READING SCORE`)
## [1] 532.216
# The average in READING SCORE in substar dataframe is more than the average in treadssk in Star dataframe.
median(substar$`READING SCORE`)
## [1] 522
# The in median READING SCORE in substar dataframe is more than the median in treadssk in Star dataframe.
substar[substar == "boy"] <- "Male"
substar[substar == "girl"] <- "Female"
substar[substar == "regular"] <- "Regular Class"
substar[substar == "regular.with.aide"] <- "Regular Class With Aide"
substar[substar == "small.class"] <- "Small Class"
substar[substar == "white"] <- "White"
substar[substar == "black"] <- "Black"
substar
## STUDENT ID MATH SCORE READING SCORE CLASS TYPE GENDER RACE
## 27 54 559 522 Regular Class Female White
## 106 229 536 507 Regular Class With Aide Male White
## 151 324 547 565 Regular Class With Aide Male White
## 166 358 513 503 Small Class Male White
## 176 377 559 605 Regular Class With Aide Male White
## 197 415 559 554 Regular Class Female White
## 216 455 559 503 Regular Class Male White
## 256 523 602 518 Regular Class Female White
## 266 542 536 580 Small Class Female Black
## 281 566 626 510 Small Class Female White
## 312 636 602 518 Small Class Male Black
## 325 653 626 580 Regular Class With Aide Female White
## 404 833 626 565 Small Class Male White
## 406 838 513 538 Regular Class Male White
## 411 844 559 510 Regular Class With Aide Male White
## 416 850 559 518 Regular Class With Aide Male Black
## 560 1153 547 507 Regular Class Female White
## 604 1242 602 503 Small Class Male White
## 626 1282 513 532 Regular Class With Aide Female White
## 722 1450 576 538 Regular Class With Aide Female White
## 750 1507 626 538 Small Class Female Black
## 814 1618 528 500 Regular Class With Aide Female Black
## 868 1739 500 580 Small Class Female White
## 905 1817 576 545 Small Class Male White
## 930 1860 602 538 Small Class Female Black
## 936 1871 506 514 Regular Class Male White
## 943 1886 576 507 Regular Class Male White
## 956 1916 576 503 Small Class Female White
## 988 1970 576 538 Small Class Male White
## 1048 2122 513 545 Regular Class With Aide Female White
## 1099 2213 520 518 Regular Class With Aide Male White
## 1158 2336 513 503 Regular Class With Aide Male White
## 1173 2360 506 507 Regular Class Female White
## 1209 2435 536 522 Small Class Female White
## 1277 2562 559 565 Small Class Male White
## 1284 2573 576 627 Regular Class With Aide Male White
## 1359 2716 626 510 Regular Class With Aide Male Black
## 1364 2732 626 518 Small Class Male Black
## 1379 2763 547 522 Regular Class Male White
## 1431 2870 513 545 Regular Class With Aide Male White
## 1467 2946 626 554 Regular Class Female White
## 1511 3028 576 580 Regular Class With Aide Female White
## 1525 3053 559 565 Regular Class Female White
## 1571 3131 576 507 Regular Class With Aide Male White
## 1587 3156 506 527 Regular Class With Aide Male White
## 1597 3181 547 514 Regular Class Male White
## 1600 3185 626 545 Regular Class With Aide Female White
## 1635 3245 626 580 Regular Class Female White
## 1647 3273 513 503 Regular Class Female Black
## 1665 3311 520 532 Small Class Male White
## 1676 3332 528 580 Regular Class Male White
## 1677 3333 547 527 Small Class Male White
## 1714 3424 576 605 Regular Class Female White
## 1756 3510 547 503 Small Class Female White
## 1770 3529 602 500 Regular Class With Aide Female Black
## 1787 3566 559 532 Regular Class Female White
## 1817 3624 559 500 Small Class Male Black
## 1831 3654 576 627 Small Class Male White
## 1863 3724 626 518 Regular Class With Aide Female White
## 1871 3742 626 518 Regular Class With Aide Female Black
## 1974 3927 528 514 Small Class Male White
## 1979 3938 506 538 Regular Class Female White
## 1982 3942 520 518 Regular Class With Aide Female White
## 2005 3986 602 507 Regular Class Female White
## 2011 3997 576 580 Small Class Male White
## 2034 4046 559 503 Small Class Male White
## 2090 4155 602 514 Regular Class Male White
## 2135 4233 506 514 Regular Class With Aide Male Black
## 2160 4273 626 627 Regular Class With Aide Female Black
## 2192 4323 513 554 Small Class Female White
## 2195 4333 520 518 Regular Class Female White
## 2237 4430 547 527 Small Class Male White
## 2275 4508 547 510 Regular Class With Aide Female White
## 2296 4555 626 510 Regular Class With Aide Female White
## 2300 4559 626 580 Small Class Male White
## 2311 4581 576 503 Small Class Female Black
## 2317 4588 576 518 Small Class Female White
## 2320 4595 500 507 Regular Class With Aide Male White
## 2336 4632 559 507 Regular Class Female White
## 2354 4665 576 532 Regular Class With Aide Female White
## 2359 4677 626 627 Small Class Female White
## 2384 4736 602 503 Small Class Female White
## 2389 4744 528 545 Regular Class With Aide Male Black
## 2410 4799 602 538 Regular Class With Aide Female Black
## 2414 4805 559 580 Small Class Female White
## 2428 4828 528 500 Small Class Female White
## 2443 4857 536 507 Regular Class With Aide Female White
## 2476 4937 559 510 Regular Class Female White
## 2477 4938 626 538 Regular Class Female Black
## 2478 4939 559 507 Regular Class With Aide Male Black
## 2496 4973 626 522 Regular Class Female Black
## 2528 5036 520 545 Regular Class With Aide Female White
## 2545 5062 559 580 Regular Class With Aide Female White
## 2563 5102 536 507 Regular Class Male White
## 2568 5109 626 518 Small Class Male White
## 2605 5191 506 500 Regular Class With Aide Male Black
## 2620 5220 576 522 Small Class Female White
## 2671 5313 547 500 Small Class Female White
## 2672 5315 559 514 Small Class Male White
## 2716 5394 602 554 Regular Class Female White
## 2717 5396 602 503 Regular Class With Aide Male White
## 2729 5420 576 514 Regular Class Male White
## 2731 5426 576 580 Regular Class Male White
## 2772 5516 626 514 Regular Class Female White
## 2773 5517 528 514 Regular Class With Aide Female White
## 2777 5526 602 554 Regular Class With Aide Male White
## 2882 5750 602 500 Regular Class Female White
## 2898 5779 626 545 Regular Class Female White
## 2957 5894 626 545 Regular Class With Aide Male White
## 2979 5924 576 507 Small Class Female White
## 3047 6058 602 522 Small Class Female Black
## 3062 6084 506 518 Regular Class Female White
## 3065 6087 576 605 Regular Class With Aide Male White
## 3104 6170 626 627 Small Class Male White
## 3126 6199 559 514 Small Class Female White
## 3139 6230 520 514 Regular Class Male White
## 3141 6237 506 527 Regular Class Female White
## 3166 6290 559 503 Regular Class With Aide Female Black
## 3174 6304 602 627 Regular Class Female White
## 3184 6327 528 503 Regular Class Male White
## 3216 6401 536 538 Regular Class With Aide Male White
## 3218 6407 536 500 Small Class Female Black
## 3239 6454 500 500 Regular Class Male White
## 3246 6467 626 507 Small Class Male White
## 3247 6468 559 565 Regular Class With Aide Female White
## 3251 6472 547 554 Regular Class Female White
## 3292 6547 626 538 Small Class Female Black
## 3306 6582 536 554 Small Class Female White
## 3312 6593 520 510 Small Class Male White
## 3374 6723 576 565 Regular Class With Aide Male White
## 3395 6766 602 518 Regular Class Female White
## 3451 6881 536 605 Regular Class With Aide Female White
## 3465 6909 559 518 Small Class Female Black
## 3471 6921 559 503 Regular Class Female White
## 3473 6933 576 605 Small Class Male White
## 3543 7076 547 538 Small Class Female White
## 3565 7116 602 545 Regular Class With Aide Female Black
## 3575 7134 602 518 Regular Class With Aide Female White
## 3577 7138 559 503 Small Class Male White
## 3580 7144 626 565 Regular Class With Aide Male White
## 3655 7293 626 545 Regular Class With Aide Female Black
## 3665 7321 547 527 Small Class Male White
## 3736 7462 576 532 Regular Class Female White
## 3756 7502 576 580 Regular Class With Aide Male White
## 3801 7591 547 522 Small Class Female White
## 3852 7694 547 518 Regular Class With Aide Female White
## 3876 7734 626 500 Regular Class Male Black
## 3899 7787 559 554 Small Class Female White
## 3907 7806 602 554 Regular Class With Aide Male Black
## 3959 7918 513 510 Regular Class Female White
## 3975 7953 626 605 Regular Class With Aide Female White
## 4005 8021 520 503 Small Class Female Black
## 4035 8081 520 510 Regular Class With Aide Male White
## 4051 8135 520 554 Regular Class Female White
## 4055 8140 626 580 Regular Class With Aide Female White
## 4106 8231 626 510 Regular Class With Aide Male White
## 4158 8327 536 527 Small Class Female White
## 4189 8388 626 522 Small Class Female White
## 4210 8421 602 503 Small Class Male White
## 4218 8435 513 500 Regular Class Male White
## 4242 8481 559 545 Small Class Male White
## 4249 8497 602 500 Small Class Male White
## 4307 8613 626 538 Regular Class With Aide Male White
## 4312 8625 602 518 Regular Class Male Black
## 4340 8683 602 503 Regular Class Male White
## 4344 8694 536 545 Regular Class Female White
## 4350 8706 520 510 Small Class Female Black
## 4351 8709 520 545 Regular Class With Aide Female White
## 4451 8931 513 500 Regular Class With Aide Male Black
## 4465 8955 602 522 Regular Class Female White
## 4480 8984 626 532 Regular Class Female White
## 4512 9045 602 500 Small Class Female White
## 4570 9170 576 510 Regular Class With Aide Female White
## 4643 9316 547 532 Small Class Female White
## 4681 9397 536 522 Regular Class Male White
## 4695 9423 528 565 Regular Class With Aide Female other
## 4710 9454 602 514 Small Class Female White
## 4734 9505 602 565 Regular Class With Aide Male White
## 4768 9572 536 518 Regular Class With Aide Female White
## 4780 9588 602 538 Regular Class With Aide Female White
## 4816 9658 626 510 Small Class Male White
## 4837 9698 559 507 Regular Class With Aide Male White
## 4877 9779 626 518 Regular Class Male Black
## 4905 9840 547 510 Regular Class Male White
## 4941 9915 547 605 Regular Class Male White
## 4981 9988 500 538 Small Class Male White
## 4984 9991 576 503 Regular Class Male White
## 4996 10011 559 500 Regular Class Female White
## 4998 10014 528 503 Small Class Female White
## 5009 10037 626 527 Small Class Female Black
## 5039 10105 559 500 Small Class Female White
## 5043 10110 602 554 Small Class Female White
## 5146 10329 576 554 Regular Class Female Black
## 5197 10429 528 538 Small Class Female White
## 5238 10522 602 527 Small Class Male White
## 5246 10535 547 532 Small Class Male White
## 5277 10601 528 514 Regular Class With Aide Male Black
## 5290 10629 626 545 Regular Class Female White
## 5311 10665 547 503 Regular Class Female White
## 5339 10721 576 518 Small Class Female Black
## 5403 10843 547 554 Regular Class With Aide Female Black
## 5416 10864 576 503 Regular Class With Aide Female Black
## 5486 11027 547 500 Small Class Male White
## 5535 11138 559 545 Regular Class With Aide Male White
## 5537 11141 602 545 Small Class Female White
## 5554 11183 536 522 Regular Class With Aide Female White
## 5581 11255 576 518 Small Class Female White
## 5600 11284 576 510 Small Class Female White
## 5617 11316 576 545 Small Class Female White
## 5651 11388 559 510 Regular Class Male White
## 5656 11399 513 500 Small Class Female Black
## 5709 11496 576 500 Small Class Female White
## 5742 11586 528 605 Small Class Female White
rownames(substar) <- 1:nrow(substar)
substar
## STUDENT ID MATH SCORE READING SCORE CLASS TYPE GENDER RACE
## 1 54 559 522 Regular Class Female White
## 2 229 536 507 Regular Class With Aide Male White
## 3 324 547 565 Regular Class With Aide Male White
## 4 358 513 503 Small Class Male White
## 5 377 559 605 Regular Class With Aide Male White
## 6 415 559 554 Regular Class Female White
## 7 455 559 503 Regular Class Male White
## 8 523 602 518 Regular Class Female White
## 9 542 536 580 Small Class Female Black
## 10 566 626 510 Small Class Female White
## 11 636 602 518 Small Class Male Black
## 12 653 626 580 Regular Class With Aide Female White
## 13 833 626 565 Small Class Male White
## 14 838 513 538 Regular Class Male White
## 15 844 559 510 Regular Class With Aide Male White
## 16 850 559 518 Regular Class With Aide Male Black
## 17 1153 547 507 Regular Class Female White
## 18 1242 602 503 Small Class Male White
## 19 1282 513 532 Regular Class With Aide Female White
## 20 1450 576 538 Regular Class With Aide Female White
## 21 1507 626 538 Small Class Female Black
## 22 1618 528 500 Regular Class With Aide Female Black
## 23 1739 500 580 Small Class Female White
## 24 1817 576 545 Small Class Male White
## 25 1860 602 538 Small Class Female Black
## 26 1871 506 514 Regular Class Male White
## 27 1886 576 507 Regular Class Male White
## 28 1916 576 503 Small Class Female White
## 29 1970 576 538 Small Class Male White
## 30 2122 513 545 Regular Class With Aide Female White
## 31 2213 520 518 Regular Class With Aide Male White
## 32 2336 513 503 Regular Class With Aide Male White
## 33 2360 506 507 Regular Class Female White
## 34 2435 536 522 Small Class Female White
## 35 2562 559 565 Small Class Male White
## 36 2573 576 627 Regular Class With Aide Male White
## 37 2716 626 510 Regular Class With Aide Male Black
## 38 2732 626 518 Small Class Male Black
## 39 2763 547 522 Regular Class Male White
## 40 2870 513 545 Regular Class With Aide Male White
## 41 2946 626 554 Regular Class Female White
## 42 3028 576 580 Regular Class With Aide Female White
## 43 3053 559 565 Regular Class Female White
## 44 3131 576 507 Regular Class With Aide Male White
## 45 3156 506 527 Regular Class With Aide Male White
## 46 3181 547 514 Regular Class Male White
## 47 3185 626 545 Regular Class With Aide Female White
## 48 3245 626 580 Regular Class Female White
## 49 3273 513 503 Regular Class Female Black
## 50 3311 520 532 Small Class Male White
## 51 3332 528 580 Regular Class Male White
## 52 3333 547 527 Small Class Male White
## 53 3424 576 605 Regular Class Female White
## 54 3510 547 503 Small Class Female White
## 55 3529 602 500 Regular Class With Aide Female Black
## 56 3566 559 532 Regular Class Female White
## 57 3624 559 500 Small Class Male Black
## 58 3654 576 627 Small Class Male White
## 59 3724 626 518 Regular Class With Aide Female White
## 60 3742 626 518 Regular Class With Aide Female Black
## 61 3927 528 514 Small Class Male White
## 62 3938 506 538 Regular Class Female White
## 63 3942 520 518 Regular Class With Aide Female White
## 64 3986 602 507 Regular Class Female White
## 65 3997 576 580 Small Class Male White
## 66 4046 559 503 Small Class Male White
## 67 4155 602 514 Regular Class Male White
## 68 4233 506 514 Regular Class With Aide Male Black
## 69 4273 626 627 Regular Class With Aide Female Black
## 70 4323 513 554 Small Class Female White
## 71 4333 520 518 Regular Class Female White
## 72 4430 547 527 Small Class Male White
## 73 4508 547 510 Regular Class With Aide Female White
## 74 4555 626 510 Regular Class With Aide Female White
## 75 4559 626 580 Small Class Male White
## 76 4581 576 503 Small Class Female Black
## 77 4588 576 518 Small Class Female White
## 78 4595 500 507 Regular Class With Aide Male White
## 79 4632 559 507 Regular Class Female White
## 80 4665 576 532 Regular Class With Aide Female White
## 81 4677 626 627 Small Class Female White
## 82 4736 602 503 Small Class Female White
## 83 4744 528 545 Regular Class With Aide Male Black
## 84 4799 602 538 Regular Class With Aide Female Black
## 85 4805 559 580 Small Class Female White
## 86 4828 528 500 Small Class Female White
## 87 4857 536 507 Regular Class With Aide Female White
## 88 4937 559 510 Regular Class Female White
## 89 4938 626 538 Regular Class Female Black
## 90 4939 559 507 Regular Class With Aide Male Black
## 91 4973 626 522 Regular Class Female Black
## 92 5036 520 545 Regular Class With Aide Female White
## 93 5062 559 580 Regular Class With Aide Female White
## 94 5102 536 507 Regular Class Male White
## 95 5109 626 518 Small Class Male White
## 96 5191 506 500 Regular Class With Aide Male Black
## 97 5220 576 522 Small Class Female White
## 98 5313 547 500 Small Class Female White
## 99 5315 559 514 Small Class Male White
## 100 5394 602 554 Regular Class Female White
## 101 5396 602 503 Regular Class With Aide Male White
## 102 5420 576 514 Regular Class Male White
## 103 5426 576 580 Regular Class Male White
## 104 5516 626 514 Regular Class Female White
## 105 5517 528 514 Regular Class With Aide Female White
## 106 5526 602 554 Regular Class With Aide Male White
## 107 5750 602 500 Regular Class Female White
## 108 5779 626 545 Regular Class Female White
## 109 5894 626 545 Regular Class With Aide Male White
## 110 5924 576 507 Small Class Female White
## 111 6058 602 522 Small Class Female Black
## 112 6084 506 518 Regular Class Female White
## 113 6087 576 605 Regular Class With Aide Male White
## 114 6170 626 627 Small Class Male White
## 115 6199 559 514 Small Class Female White
## 116 6230 520 514 Regular Class Male White
## 117 6237 506 527 Regular Class Female White
## 118 6290 559 503 Regular Class With Aide Female Black
## 119 6304 602 627 Regular Class Female White
## 120 6327 528 503 Regular Class Male White
## 121 6401 536 538 Regular Class With Aide Male White
## 122 6407 536 500 Small Class Female Black
## 123 6454 500 500 Regular Class Male White
## 124 6467 626 507 Small Class Male White
## 125 6468 559 565 Regular Class With Aide Female White
## 126 6472 547 554 Regular Class Female White
## 127 6547 626 538 Small Class Female Black
## 128 6582 536 554 Small Class Female White
## 129 6593 520 510 Small Class Male White
## 130 6723 576 565 Regular Class With Aide Male White
## 131 6766 602 518 Regular Class Female White
## 132 6881 536 605 Regular Class With Aide Female White
## 133 6909 559 518 Small Class Female Black
## 134 6921 559 503 Regular Class Female White
## 135 6933 576 605 Small Class Male White
## 136 7076 547 538 Small Class Female White
## 137 7116 602 545 Regular Class With Aide Female Black
## 138 7134 602 518 Regular Class With Aide Female White
## 139 7138 559 503 Small Class Male White
## 140 7144 626 565 Regular Class With Aide Male White
## 141 7293 626 545 Regular Class With Aide Female Black
## 142 7321 547 527 Small Class Male White
## 143 7462 576 532 Regular Class Female White
## 144 7502 576 580 Regular Class With Aide Male White
## 145 7591 547 522 Small Class Female White
## 146 7694 547 518 Regular Class With Aide Female White
## 147 7734 626 500 Regular Class Male Black
## 148 7787 559 554 Small Class Female White
## 149 7806 602 554 Regular Class With Aide Male Black
## 150 7918 513 510 Regular Class Female White
## 151 7953 626 605 Regular Class With Aide Female White
## 152 8021 520 503 Small Class Female Black
## 153 8081 520 510 Regular Class With Aide Male White
## 154 8135 520 554 Regular Class Female White
## 155 8140 626 580 Regular Class With Aide Female White
## 156 8231 626 510 Regular Class With Aide Male White
## 157 8327 536 527 Small Class Female White
## 158 8388 626 522 Small Class Female White
## 159 8421 602 503 Small Class Male White
## 160 8435 513 500 Regular Class Male White
## 161 8481 559 545 Small Class Male White
## 162 8497 602 500 Small Class Male White
## 163 8613 626 538 Regular Class With Aide Male White
## 164 8625 602 518 Regular Class Male Black
## 165 8683 602 503 Regular Class Male White
## 166 8694 536 545 Regular Class Female White
## 167 8706 520 510 Small Class Female Black
## 168 8709 520 545 Regular Class With Aide Female White
## 169 8931 513 500 Regular Class With Aide Male Black
## 170 8955 602 522 Regular Class Female White
## 171 8984 626 532 Regular Class Female White
## 172 9045 602 500 Small Class Female White
## 173 9170 576 510 Regular Class With Aide Female White
## 174 9316 547 532 Small Class Female White
## 175 9397 536 522 Regular Class Male White
## 176 9423 528 565 Regular Class With Aide Female other
## 177 9454 602 514 Small Class Female White
## 178 9505 602 565 Regular Class With Aide Male White
## 179 9572 536 518 Regular Class With Aide Female White
## 180 9588 602 538 Regular Class With Aide Female White
## 181 9658 626 510 Small Class Male White
## 182 9698 559 507 Regular Class With Aide Male White
## 183 9779 626 518 Regular Class Male Black
## 184 9840 547 510 Regular Class Male White
## 185 9915 547 605 Regular Class Male White
## 186 9988 500 538 Small Class Male White
## 187 9991 576 503 Regular Class Male White
## 188 10011 559 500 Regular Class Female White
## 189 10014 528 503 Small Class Female White
## 190 10037 626 527 Small Class Female Black
## 191 10105 559 500 Small Class Female White
## 192 10110 602 554 Small Class Female White
## 193 10329 576 554 Regular Class Female Black
## 194 10429 528 538 Small Class Female White
## 195 10522 602 527 Small Class Male White
## 196 10535 547 532 Small Class Male White
## 197 10601 528 514 Regular Class With Aide Male Black
## 198 10629 626 545 Regular Class Female White
## 199 10665 547 503 Regular Class Female White
## 200 10721 576 518 Small Class Female Black
## 201 10843 547 554 Regular Class With Aide Female Black
## 202 10864 576 503 Regular Class With Aide Female Black
## 203 11027 547 500 Small Class Male White
## 204 11138 559 545 Regular Class With Aide Male White
## 205 11141 602 545 Small Class Female White
## 206 11183 536 522 Regular Class With Aide Female White
## 207 11255 576 518 Small Class Female White
## 208 11284 576 510 Small Class Female White
## 209 11316 576 545 Small Class Female White
## 210 11388 559 510 Regular Class Male White
## 211 11399 513 500 Small Class Female Black
## 212 11496 576 500 Small Class Female White
## 213 11586 528 605 Small Class Female White
head(substar,10)
## STUDENT ID MATH SCORE READING SCORE CLASS TYPE GENDER RACE
## 1 54 559 522 Regular Class Female White
## 2 229 536 507 Regular Class With Aide Male White
## 3 324 547 565 Regular Class With Aide Male White
## 4 358 513 503 Small Class Male White
## 5 377 559 605 Regular Class With Aide Male White
## 6 415 559 554 Regular Class Female White
## 7 455 559 503 Regular Class Male White
## 8 523 602 518 Regular Class Female White
## 9 542 536 580 Small Class Female Black
## 10 566 626 510 Small Class Female White
theUrl <- "https://raw.githubusercontent.com/enidroman/R-Programing/main/Star.csv"
bsubstar <- read.table(file=theUrl, header=TRUE, sep=",")
head(bsubstar)
## X tmathssk treadssk classk totexpk sex freelunk race schidkn
## 1 2 473 447 small.class 7 girl no white 63
## 2 3 536 450 small.class 21 girl no black 20
## 3 5 463 439 regular.with.aide 0 boy yes black 19
## 4 11 559 448 regular 16 boy no white 69
## 5 12 489 447 small.class 5 boy yes white 79
## 6 13 454 431 regular 8 boy yes white 5