Build a machine learning predictor for student performance

4 views (last 30 days)
Cuong Quang
Cuong Quang on 22 Aug 2018
Commented: Cuong Quang on 31 Aug 2018
Hi all,
My question is on how I can get Matlab to reformat raw data into a format I can use for supervised machine learning.
I have a dataset on a large number, N, of schools that lists the academic performance of students in Biology, Maths, Physics and Overall according to the school term of which there are 4 terms.
I would like to build a machine learning predictor where the performance in each of these academic subjects and the term that the school is in are input features and the school performance Overall is the target.
I would like help on Matlab commands that helps me transpose the raw dataset into a structure that I can build a supervised machine learning model from.
I have attached the raw and intended data formats and have tried using the STACK command but this is not as easy as I thought it would be. Any help would be welcomed.

Accepted Answer

Saumya Goel
Saumya Goel on 30 Aug 2018
I am assuming that you are having data in table format. I think the unstack function might help you resolve the above issue, you can try the below step: unstack(tablename, {'Average Grade','Median Grade','Standard Deviation','No. students','State rank'},'Term')
  2 Comments
Cuong Quang
Cuong Quang on 31 Aug 2018
Saumya
Thank you very much for your suggestion. My final tweak to your answer is actually: unstack(tablename, {'Average Grade','Median Grade','Standard Deviation','No. students','State rank'},'Class')
This leaves the rows sorted by School No. and Term in the format I desire.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!