Knn code to compare two excel sheet

4 次查看（过去 30 天）

Nana Fernandes 2017-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/331481-knn-code-to-compare-two-excel-sheet

评论： Nana Fernandes 2017-4-2

we are working on a power system on which we have to determine whether the failure of the power system is a fault or not a fault. We have created a dataset with all possibilities of faults and not faults of the system called training set. we have created another excel sheet called the training set in which we have taken some values of faults and not faults from the dataset. We want to use knn algorithm and euclidean distance to compare/classify whether the readings in the training set are the values of faults or not faults when compared with the original dataset. As we are putting four five values in the training set, how do we make matlab read and classify all the values one after the other without manually entering the values

P.S- 1 represents 'fault' and 2 represents 'not a fault' (in the AE column of the excel sheet)in the dataset excel sheet. After running knn algorithm we want 1 or 2 displayed on command line and written on training set.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Rik 2017-3-23

You mean you need to read the Excel files into Matlab? That can be done with xlsread. It sounds like after that it is only a few matrix multiplications. (potentially useful function: repmat, also keep in mind that Matlab trims the result from xlsread, removing empty rows and columns)

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

sam CP 2017-3-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/331481-knn-code-to-compare-two-excel-sheet#answer_260439

编辑：per isakson 2017-4-2

在 MATLAB Online 中打开

%The following code will helps you.
clc
clear all
training0 = xlsread('training set.xls'); 
training1 = xlsread('dataset.xlsx');
zero = zeros(10,1);
one = ones(10,1);
group = [zero;one];
test = TestFeatinputMRI;
training = [training0;training1];
KNN = fitcknn(training,group)
Class = knnclassify(test,training,group)