Data Processing of a Matrix

Hellow,

I have stuck to a point of the code I am writing. In summary, there is a matrix (ReviewMatrix) that carries data from an excel file. I then try to remove some random data from this matrix and create a new matrix (NewReviewMatrix) What I am having trouble is how to replace the SupReviewTable with the new matrix (NewReviewMatrix) so I can calculate VisitorsSim. Below is the code I wrote.

load("ReMatrix")
SupReviewMatrix=(ReviewMatrix>0)
A=sum(SupReviewMatrix)
th=5 %threshold
for i=1:1000
    if A(i)>th
        ReductionRatings=th-A(i) % scores decucted visitors who went to several locations
        while (ReductionRatings>0)
            Location=randi(800)
            if (SupReviewMatrix(location,i)>0) % positive review and will remove it
                SupReviewMatrix(location,i)=0
                A(i)=A(i)-1
                ReductionRatings=ReductionRatings-1
            end
        end
    end
end
sizeMatrix=size(ReviewMatrix)
visitor_num=sizeMatrix(2)
location_num=sizeMatrix(1)

visitor=400
visitor_column=SupReviewMatrix(:,visitor)
Visitor_Matrix=(visitor_column*ones(1,visitor_num)).*SupReviewMatrix
VisitorsSim=sum(Visitor_Matrix)

[Bob Thompson]

'What I am having trouble is how to replace the SupReviewTable with the new matrix (NewReviewMatrix)'

What exactly are you having trouble with? Are you getting an error message? If so, please post the entire thing. If not, how does your result differ from what you would like it to be?

Some things I noticed:

if A(i)>th
ReductionRatings=th-A(i) % Result is negative because of previous condition
while (ReductionRatings>0) % Will always return negative

I don't see where you have NewReviewMatrix anywhere in the code you posted. Are you just trying to change the input from ReviewMatrix to NewReviewMatrix? If so, I would suggest changing this into a function, so that you can adjust the input dynamically.

[stelios loizidis]

The basic idea is initially to create a new matrix (NewSupMatrix) in which some random "1" of each column should be zero. That is what I am trying to do inside the for loop. And then this matrix (NewSupMatrix) will use it to figure out rest(visitor_column,Visitor_Matrix and VisitorsSim). If there is something diffrent and easier than that I did with great pleasure I accept it.

[Bob Thompson]

Ok, that makes more sense with what your code is trying to achieve.

I am still not sure what you are looking to get answered with your question though. I would appreciate it if you could expand on your problem a little bit more.

[stelios loizidis]

I have an excel file that has 3 columns(visitors,locations,ratings).Based on this file I create the ReviewMatrix.mat matrix. Then I created the SupReviewMatrix matrix whrere this matrix has "1" in the locations that a visitor went. Also, the SupReviewMatrix matrix columns are the visitors and the rows the locations. Then I do following procedure and count VisitorsSim.

Original Code:

load("ReviewMatrix.mat")
SupReviewMatrix=(ReviewMatrix>0)

sizeMatrix=size(ReviewMatrix)
visitor_num=sizeMatrix(2)
location_num=sizeMatrix(1)

visitor=400

visitor_column=SupReviewMatrix(:,visitor)
Visitor_Matrix=(visitor_column*ones(1,visitor_num)).*SupReviewMatrix
VisitorsSim=sum(Visitor_Matrix)

[stelios loizidis]

I need to create a new matrix in this code (e.g NewSupMatrix). That is what I did with the for loop that I am showing above but I am not sure if it is right. Also, once the new matrix (NewSupMatrix) is created based on the limination that I mention later I will use it to recalculate the visitor_column, Visitor_Matrix and VisitorsSim.

More specifically, the problem I have is how to create the NewSupMatrix matrix.

[Bob Thompson]

Ok, I have a better handle on what you're asking now.

If you aren't sure if your matrix is correct or not, I would suggest making a new matrix, rather than modifying the old one. To do this just change the variable names inside the loop.

If you are looking to calculate the visitor_column, visitor_matrix, and visitorsim with the new matrix each time, then just move the calculations inside the loop. Just be sure and index your results, or you will only see the final result.

As I mentioned earlier, your loop is not currently making any changes because your logic is coming back false every time. Make sure you update that.

[stelios loizidis]

Because I was confused, how to fix the loop and the index of the matrices because I want to figure out I will put them in the loop as suggested to me and I also want to see all the values not only the final value.