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