% Ranking Project
 %AML/B5/Dec-2019
 %% Load extrnal data  files
load -ascii Pure.txt
load -ascii Applied.txt
load -ascii Chemistry.txt
load -ascii Physics.txt
%% Define a matrix and store data in it
all_data=zeros(30,6);
all_data(:,1)=1:30;
all_data(:,2)=Pure(:,2);
all_data(:,3)=Applied(:,2);
all_data(:,4)=Chemistry(:,2);
all_data(:,5)=Physics(:,2);
all_data(:,6)=all_data(:,2)+all_data(:,3)+all_data(:,4)+all_data(:,5);
%% Part 1 Subject highest with Index No
disp('Part:1')
disp(['Max Pure ',num2str(max(all_data(:,2))),',and SID is: ',num2str(find(all_data(:,2)== max(all_data(:,2))))])
disp(['Max Applied ',num2str(max(all_data(:,3))),',and SID is: ',num2str(find(all_data(:,3)== max(all_data(:,3))))])
disp(['Max Chemistry ',num2str(max(all_data(:,4))),',and SID is: ',num2str(find(all_data(:,4)== max(all_data(:,4))))])
disp(['Max Physics ',num2str(max(all_data(:,5))),',and SID is: ',num2str(find(all_data(:,5)== max(all_data(:,5))))])
disp(' ')
%% Part 2 Class Highest with student IDs
all_data=sortrows(all_data,-6);
disp('Part:2')
disp(['1st rank SID: ',num2str(all_data(1,1)),', and the mark is: ',num2str(all_data(1,6))])
disp(['2nd rank SID: ',num2str(all_data(2,1)),', and the mark is: ',num2str(all_data(2,6))])
disp(['3rd rank SID: ',num2str(all_data(3,1)),', and the mark is: ',num2str(all_data(3,6))])
disp(' ')
%% Part 3 mean and STD for each subject
disp('Part:3')
disp(['Mean mk for Pure is: ', num2str(mean(all_data(:,2))), ' and STD is: ', num2str(std(all_data(:,2)))])
disp(['Mean mk for Applied is: ', num2str(mean(all_data(:,3))), ' and STD is: ', num2str(std(all_data(:,3)))])
disp(['Mean mk for Chemistry is: ', num2str(mean(all_data(:,4))), ' and STD is: ', num2str(std(all_data(:,4)))])
disp(['Mean mk for Physics is: ', num2str(mean(all_data(:,5))), ' and STD is: ', num2str(std(all_data(:,5)))])
disp(' ')
%% Part 4 No. of failed students
disp('Part:4')
disp(' ')
%% Part 5: re-writing the matrix
all_datanew=[[1:30]',all_data(:,1),all_data(:,6),all_data(:,2:5)];
%% To save this as a text file
save -ascii RankingRM.txt all_datanew