Build a machine learning predictor for student performance

1 次查看(过去 30 天)
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.

采纳的回答

Saumya Goel
Saumya Goel 2018-8-30
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 个评论
Cuong Quang
Cuong Quang 2018-8-31
Thankyou Saumya - I will apply your suggestion and come back on whether that worked!
Cuong Quang
Cuong Quang 2018-8-31
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.

请先登录,再进行评论。

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by