Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Error in Confusion Matrix : the data and reference factors must have the same number of levels

I've trained a Linear Regression model with R caret. I'm now trying to generate a confusion matrix and keep getting the following error:

Error in confusionMatrix.default(pred, testing$Final) : the data and reference factors must have the same number of levels

EnglishMarks <- read.csv("E:/Subject Wise Data/EnglishMarks.csv",  header=TRUE) inTrain<-createDataPartition(y=EnglishMarks$Final,p=0.7,list=FALSE) training<-EnglishMarks[inTrain,] testing<-EnglishMarks[-inTrain,] predictionsTree <- predict(treeFit, testdata) confusionMatrix(predictionsTree, testdata$catgeory) modFit<-train(Final~UT1+UT2+HalfYearly+UT3+UT4,method="lm",data=training) pred<-format(round(predict(modFit,testing)))               confusionMatrix(pred,testing$Final) 

The error occurs when generating the confusion matrix. The levels are the same on both objects. I cant figure out what the problem is. Their structure and levels are given below. They should be the same. Any help would be greatly appreciated as its making me cracked!!

> str(pred) chr [1:148] "85" "84" "87" "65" "88" "84" "82" "84" "65" "78" "78" "88" "85"   "86" "77" ... > str(testing$Final) int [1:148] 88 85 86 70 85 85 79 85 62 77 ...  > levels(pred) NULL > levels(testing$Final) NULL 
like image 843
abcd Avatar asked May 02 '15 11:05

abcd


1 Answers

Do table(pred) and table(testing$Final). You will see that there is at least one number in the testing set that is never predicted (i.e. never present in pred). This is what is meant why "different number of levels". There is an example of a custom made function to get around this problem here.

However, I found that this trick works fine:

table(factor(pred, levels=min(test):max(test)),        factor(test, levels=min(test):max(test))) 

It should give you exactly the same confusion matrix as with the function.

like image 178
nayriz Avatar answered Sep 26 '22 07:09

nayriz