NYC Open Data - Data Analysis Using R

Aim

The purpose of the product is to:

Show the difference per Borough in Math Proficiency and ELA Proficiency using 2021 DOE Middle School Data. In order to express the data, summary statistics were used. Due to the large amount of data, only the top 10 schools in descending order were used.

Load Libraries & Load Data

library(tidyverse)
library(RSocrata)
library(knitr)
library(DT)

data <- read.socrata("https://data.cityofnewyork.us/resource/f6s7-vytj.csv")

Create Data Frame

# selected variables (columns)
columns <-c("district","name","borough","latitude","longitude",
            "mathprof", "totalstudents","gradespan", "elaprof",
            "acceleratedclasses","electiveclasses","languageclasses",
            "diversityinadmissions")
mydata <- data |> 
  select(all_of(columns))

Manhattan Summary Statistics

name	borough	totalstudents	mathprof	elaprof
Special Music School	MANHATTAN	306	98	93
East Side Middle School	MANHATTAN	457	97	94
The Anderson School	MANHATTAN	522	97	97
Tag Young Scholars	MANHATTAN	600	96	92
New Explorations into Science, Technology & Math	MANHATTAN	1806	95	94
New York City Lab Middle School for Collaborative Studies	MANHATTAN	603	94	91
The Clinton School	MANHATTAN	776	93	92
M.S. 255 Salk School of Science	MANHATTAN	383	92	94
M.S. 243 Center School	MANHATTAN	247	90	94
Columbia Secondary School	MANHATTAN	698	88	87

Bronx Summary Statistics

name	borough	totalstudents	mathprof	elaprof
P.S. 019 Judith K. Weiss	BRONX	525	64	61
M.S. X101 Edward R. Byrne	BRONX	545	60	67
The Laboratory School of Finance and Technology: X223	BRONX	683	59	56
Comprehensive Model School Project M.S. 327	BRONX	708	56	40
P.S./M.S. 11X498 - VAN NEST ACADEMY	BRONX	656	56	54
The School for Inquiry and Social Justice	BRONX	494	55	51
Riverdale / Kingsbridge Academy	BRONX	1540	55	54
P.S. X015 Institute for Environmental Learning	BRONX	485	54	54
P.S. 071 Rose E. Scala	BRONX	1455	52	45
Mott Hall III	BRONX	340	52	64

Queens Summary Statistics

name	borough	totalstudents	mathprof	elaprof
Baccalaureate School for Global Education	QUEENS	557	100	100
P.S. 122 Mamie Fay	QUEENS	1365	98	98
The 30th Avenue School	QUEENS	544	95	96
Scholars’ Academy	QUEENS	1311	92	92
Robert F. Wagner, Jr. Secondary School for Arts and Technology	QUEENS	653	86	83
Queens Gateway to Health Sciences Secondary School	QUEENS	694	86	85
J.H.S. 067 Louis Pasteur	QUEENS	1044	83	79
J.H.S. 074 Nathaniel Hawthorne	QUEENS	1160	82	76
The Queens College School for Math, Science and Technology	QUEENS	523	81	83
East-West School of International Studies	QUEENS	666	80	71

Brooklyn Summary Statistics

name	borough	totalstudents	mathprof	elaprof
The Christa McAuliffe School.S. 187	BROOKLYN	982	96	95
I.S. 98 Bay Academy	BROOKLYN	1601	92	93
All City Leadership Secondary School	BROOKLYN	433	91	90
Brooklyn School of Inquiry	BROOKLYN	534	90	92
The Lenox Academy	BROOKLYN	1174	89	90
The Math & Science Exploratory School	BROOKLYN	549	85	83
M.S. 51 William Alexander	BROOKLYN	1150	84	82
Mark Twain I.S. 239 for the Gifted & Talented	BROOKLYN	1345	84	87
New Voices School of Academic & Creative Arts	BROOKLYN	573	79	82
Academy of Arts and Letters	BROOKLYN	523	77	75

Staten Island Summary Statistics

name	borough	totalstudents	mathprof	elaprof
I.S. 034 Tottenville	STATEN IS	1033	75	61
P.S. 048 William G. Wilcox	STATEN IS	1000	69	63
I.S. 075 Frank D. Paulo	STATEN IS	1448	64	65
I.S. 007 Elias Bernstein	STATEN IS	1184	60	71
Marsh Avenue School for Expeditionary Learning	STATEN IS	453	57	65
Staten Island School of Civic Leadership	STATEN IS	873	57	60
The Michael J. Petrides School	STATEN IS	1338	56	60
I.S. 024 Myra S. Barnes	STATEN IS	1364	53	64
I.S. 072 Rocco Laurie	STATEN IS	1582	50	54
I.S. 027 Anning S. Prall	STATEN IS	1070	38	53