Pandas and SQA data

Link to Github repository:

https://github.com/mrcrookes/sqa_joiner

Spreadsheet of output data: 

https://docs.google.com/spreadsheets/d/13G2zyOqPBqgng9F1__Dh0EUq1TaSY1oPnN08dmVmgE8/edit#gid=1267167075

Total entries, passes, no awards from 1986-2022

https://chart-studio.plotly.com/~mrcrookes/136/#/

Percentage of As for each subject from 2016-2022

Advanced Higher

https://chart-studio.plotly.com/~mrcrookes/74/#/

Higher

https://chart-studio.plotly.com/~mrcrookes/76/#/

National 5

https://chart-studio.plotly.com/~mrcrookes/78/#/

Grade boundaries from 2016-2022

National 5

https://chart-studio.plotly.com/~mrcrookes/61/#/

Higher

https://chart-studio.plotly.com/~mrcrookes/63/#/

Advanced Higher

https://chart-studio.plotly.com/~mrcrookes/65/#/

Entries for each subject from 2018 - 2022

National 5

https://chart-studio.plotly.com/~mrcrookes/31/#/

Higher

https://chart-studio.plotly.com/~mrcrookes/33/#/

Advanced Higher

https://chart-studio.plotly.com/~mrcrookes/35/#/

Distribution of grades for State and Independent Schools from 2016 - 2022

National 5

https://chart-studio.plotly.com/~mrcrookes/55/#/

Higher

https://chart-studio.plotly.com/~mrcrookes/57/#/

Advanced Higher

https://chart-studio.plotly.com/~mrcrookes/59/#/

Percentage of A grades for each subject from Independent Schools from 2018 - 2022

National 5

https://chart-studio.plotly.com/~mrcrookes/53/#/

Higher

https://chart-studio.plotly.com/~mrcrookes/49/#/

Advanced Higher

https://chart-studio.plotly.com/~mrcrookes/51