library(dplyr)
## Warning: package 'dplyr' was built under R version 3.6.3
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(knitr)
## Warning: package 'knitr' was built under R version 3.6.3
data <- read.csv("C:/Users/christine.iyer/Downloads/report1598396413322.csv", header = T, stringsAsFactors = F)
data1 <- data


kable(data1 %>% filter(Career == "Undergraduate") %>% group_by(App.Possible.Acad.Major) %>% summarise(n = n()) %>% arrange(App.Possible.Acad.Major))
## `summarise()` ungrouping output (override with `.groups` argument)
App.Possible.Acad.Major n
551394
Accounting 802
Admissions Pathway Program 204
Applied Energy 1
Applied Geographic Information (Certificate) 1
Applied Technical Leadership 62
Art 16
Art - BA 277
Art - Fine Art Studio - BFA 263
Art - GO 9
Art Education - BFA 166
Art Education - GO 2
Arts and Humanities 7
Athletic Training 664
Bio Pre-Med 1
Biochemistry 338
Biochemistry - GO 3
Biology 2380
Biology - GO 21
Business 2
Chemistry 212
Chemistry-BA 1
Chemistry - GO 1
Communication 617
Communication - GO 9
Computer Science 1186
Computer Science - GO 11
Criminology 1288
Criminology - GO 45
Cyber Security 286
Economics 5
Economics-BA 122
Economics-BS 92
Economics - GO 3
Educational Studies-minor 1
Electrical Engineering 445
Engineering 419
Engineering - GO 14
English 1287
English - GO 20
English Language Bridge 95
Environmental Planning & Policy 111
Environmental Planning & Policy - GO 1
Environmental Planning and Policy 22
Environmental Science 544
Environmental Science - GO 10
Exercise Science 613
Finance 425
Foundations of Holistic Health 1
French 1
General Management 2252
Geography/Anthropology 188
Geography/Anthropology - GO 2
Health Sciences 1339
History 689
History - GO 11
Holistic & Integrative Health-minor 1
Honors-minor 1
Information Technology 213
Leadership & Organizational Studies 212
Leadership and Organizational Studies 43
Leadership Studies-minor 1
Liberal Studies 382
Linguistics 492
Linguistics - GO 8
Management 468
Marketing 572
Mathematics 306
Mathematics - GO 4
Mechanical Engineering 967
Mechanical Engineering - GO 8
Media Studies 310
Media Studies - GO 6
Mental Health/Psychology 1
Music 2
Music-BA 76
Music-BA GO 1
Music Education 263
Music Education - GO 1
Music Education Pathway K-12 5
Music Performance 218
Music Performance - GO 1
Musical Theatre 88
Musical Theatre - GO 3
Natural & Applied Sciences 90
Natural and Applied Sciences 3
Non-Degree STJ 1
Nursing 2992
Ocapational Therapy 1
Philosophy 73
Philosophy - GO 1
Physciology 1
Physics 126
Physics - GO 1
Political Science 707
Political Science - GO 6
Pre-Med 1
psychology 1
Psychology 1944
Psychology - GO 37
Recreation and Leisure Studies 111
Recreation and Leisure Studies - GO 6
Social and Behavioral Sciences 10
Social Work 882
Social Work - GO 22
Social/Behavioral Sciences 761
Social/Behavioral Sciences - GO 4
Sociology 156
Sociology - GO 2
Sport Management 584
Teacher Education Pathway 7-12 1
Teacher Education Pathway K-8 5
Technology Management 148
Technology Management - GO 3
Theater 190
Theater - GO 3
Theatre 3
Tourism and Hospitality 271
Tourism and Hospitality - GO 10
Undeclared 5563
Undeclared - GO 830
Women & Gender Studies 31
Women & Gender Studies - GO 1
Women and Gender Studies 7
Writing 1