R Markdown

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")

Already installed Tidyverse to upload csv file from my laptop.

I will load the package now.

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()

Upload my csv file.

Star <- read.csv("Star.csv")

Use the summary function to gain an overview of the data set.

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

Display the first couple of rows to observe.

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

Display the mean and median for at least 2 attributes.

Mean and Median for tmatssk.

mean(Star$tmathssk)
## [1] 485.6481
median(Star$tmathssk)
## [1] 484

Mean and Median for treadssk.

mean(Star$treadssk)
## [1] 436.7423
median(Star$treadssk)
## [1] 433

Create a new data frame with a subset of the columns and rows. Make sure to rename it.

Display columns X, tmathssk, treadssk, classk, sex, race.

Display tmathssk and treadssk greater than or equal to 500.

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

Create new column names for the new data frame.

Display Column Names.

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

Use the summary function to create an overview of your new data frame. Then print the mean and median for the same two attributes. Please compare.

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  
##                                       
##                                       
## 

Display the mean and median for the same two attributes. Please compare.

Mean and Median for Math Score.

My conclustion on my comparison below removing the scores below 500 had increased the average and the median in substar.

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 and Median for READING SCORE.

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. 

For at least 3 values in a column please rename so that every value in that column is renamed. (Did 8.)

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

Display enough rows to see examples of all of steps 1-5 above.

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

BONUS – place the original .csv in a github file and have R read from the link.

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