R Notebook

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

# Load necessary libraries
library(readxl)
library(dplyr)

# Load and process Grade 8 Math
g8_math <- read_excel('Grade 8 Math (1).Xlsx', col_names = FALSE)

New names:
• `` -> `...1`
• `` -> `...2`
• `` -> `...3`
• `` -> `...4`
• `` -> `...5`

g8_math <- g8_math[-(1:16), ]  # Skip header rows
colnames(g8_math) <- c('JURISDICTION', 'SCORE', 'DIFFERENCE_FROM_NP', 
                        'AT_OR_ABOVE_BASIC', 'AT_OR_ABOVE_PROFICIENT')

# Define regions list
regions <- list(
  Northeast = c('Maine', 'New Hampshire', 'Vermont', 'Massachusetts', 
                'Rhode Island', 'Connecticut', 'New York', 
                'Pennsylvania', 'New Jersey'),
  Midwest = c('Wisconsin', 'Michigan', 'Illinois', 'Indiana', 'Ohio', 
              'Missouri', 'North Dakota', 'South Dakota', 'Nebraska', 
              'Kansas', 'Minnesota', 'Iowa'),
  South = c('Delaware', 'Maryland', 'District of Columbia', 'Virginia', 
            'West Virginia', 'North Carolina', 'South Carolina', 
            'Georgia', 'Florida', 'Kentucky', 'Tennessee', 
            'Mississippi', 'Alabama', 'Oklahoma', 'Texas', 
            'Arkansas', 'Louisiana'),
  West = c('Idaho', 'Montana', 'Wyoming', 'Nevada', 'Utah', 
           'Colorado', 'Arizona', 'New Mexico', 'Alaska', 
           'Washington', 'Oregon', 'California', 'Hawaii')
)

# Function to assign region
assign_region <- function(state) {
  for (region in names(regions)) {
    if (state %in% regions[[region]]) {
      return(region)
    }
  }
  return('Other')
}

# Apply the function to assign regions
g8_math$REGION <- sapply(g8_math$JURISDICTION, assign_region)

# Print selected columns
cat("Grade 8 Math - Selected Columns:\n")

Grade 8 Math - Selected Columns:

print(g8_math %>% select(JURISDICTION, DIFFERENCE_FROM_NP, REGION) %>% head(10))

# Load necessary libraries
library(readxl)
library(dplyr)

# Load and process Grade 8 Reading
g8_reading <- read_excel('Grade 8 Reading (1).Xlsx', col_names = FALSE)

New names:
• `` -> `...1`
• `` -> `...2`
• `` -> `...3`
• `` -> `...4`
• `` -> `...5`

g8_reading <- g8_reading[-(1:16), ]  # Skip header rows
colnames(g8_reading) <- c('JURISDICTION', 'SCORE', 'DIFFERENCE_FROM_NP', 
                           'AT_OR_ABOVE_BASIC', 'AT_OR_ABOVE_PROFICIENT')

# Assign regions using the previously defined assign_region function
g8_reading$REGION <- sapply(g8_reading$JURISDICTION, assign_region)

# Print selected columns
cat("Grade 8 Reading - Selected Columns:\n")

Grade 8 Reading - Selected Columns:

print(g8_reading %>% select(JURISDICTION, DIFFERENCE_FROM_NP, REGION) %>% head(10))

NA

# Load necessary libraries
library(readxl)
library(dplyr)

# Load and process Grade 4 Reading
g4_reading <- read_excel('Grade 4 Reading (1).Xlsx', col_names = FALSE)

New names:
• `` -> `...1`
• `` -> `...2`
• `` -> `...3`
• `` -> `...4`
• `` -> `...5`

g4_reading <- g4_reading[-(1:16), ]  # Skip header rows
colnames(g4_reading) <- c('JURISDICTION', 'SCORE', 'DIFFERENCE_FROM_NP', 
                           'AT_OR_ABOVE_BASIC', 'AT_OR_ABOVE_PROFICIENT')

# Assign regions using the previously defined assign_region function
g4_reading$REGION <- sapply(g4_reading$JURISDICTION, assign_region)

# Print selected columns
cat("Grade 4 Reading - Selected Columns:\n")

Grade 4 Reading - Selected Columns:

print(g4_reading %>% select(JURISDICTION, DIFFERENCE_FROM_NP, REGION) %>% head(10))

# Load necessary libraries
library(readxl)
library(dplyr)

# Load and process Grade 4 Math
g4_math <- read_excel('Grade 4 Math (3).Xlsx', col_names = FALSE)

New names:
• `` -> `...1`
• `` -> `...2`
• `` -> `...3`
• `` -> `...4`
• `` -> `...5`

g4_math <- g4_math[-(1:16), ]  # Skip header rows
colnames(g4_math) <- c('JURISDICTION', 'SCORE', 'DIFFERENCE_FROM_NP', 
                        'AT_OR_ABOVE_BASIC', 'AT_OR_ABOVE_PROFICIENT')

# Assign regions using the previously defined assign_region function
g4_math$REGION <- sapply(g4_math$JURISDICTION, assign_region)

# Print selected columns
cat("Grade 4 Math - Selected Columns:\n")

Grade 4 Math - Selected Columns:

print(g4_math %>% select(JURISDICTION, DIFFERENCE_FROM_NP, REGION) %>% head(10))

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.