Mfcttrf

Download app bundles from App Store to run on iOS Emulator on Mac

Surface of the 3x3x3 cube as a graph

Wifi light switch needs neutral wire. Why? AND Can that wire be a skinny one?

Salesforce bug enabled "Modify All"

Would this be a dangerous impeller to use for a drone?

Efficient Algorithms for Destroyed Document Reconstruction

nginx conf: http2 module not working in Chrome in ubuntu 18.04

How to tease a romance without a cat and mouse chase?

What does it mean for something to be strictly less than epsilon for an arbitrary epsilon?

Is a world with one country feeding everyone possible?

Why do testers need root cause analysis?

Ratings matrix plot

How to become an Editorial board member?

Ribbon Cable Cross Talk - Is there a fix after the fact?

Is it normal to "extract a paper" from a master thesis?

How to eliminate gap at the start and at the end of a line when it's drawn along a side of a node's bounding box?

Is the default 512 byte physical sector size appropriate for SSD disks under Linux?

Real Analysis: Proof of the equivalent definitions of the derivative.

Why is unzipped file smaller than zipped file

Adobe Illustrator: How can I change the profile of a dashed stroke?

Why is the reciprocal used in fraction division?

What spell do I need to be my own rock band?

Goldfish unresponsive, what should I do?

How would a physicist explain this starship engine?

Ratings matrix plot

Is there an efficient way to implement a random crossover of individuals stored in a matrix?Deep NN architecture for predicting a matrix from two matricesMatrix Dimension for Linear regression coefficientsMachine learning to predict 8*8 matrix values using three independent matricesHow can the convolution operation be implemented as a matrix-vector multiplication?Which matrix represents the similarity between words when using SVD?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

$begingroup$

Hello fellows and folks.

I have been looking to do this for 1 month and still cannot find the way to do it.

Here’s what’s going on:

I have a csv file called ratings.csv with the following structure:

userID, movieID, rating
3, 12, 5
2, 7, 6

The rating scale goes from 0 to 5 stars. I want to be able to plot the sparsity of the matrix like it’s done in the following picture:

As you can see, ratings scale goes from 0 to 5 on the right. It is a very well thought plot.

I have Matlab, Python, R etc. Could you come up with something and help me? I’ve tried hard but I cannot find the way to do it.

This is what I have tried so far:

tbl = readtable('ratings.csv');
users = categorical(tbl.userId);
movies = categorical(tbl.movieId);
xlabels = categories(users);
ylabels = categories(movies);

numusers = numel(xlabels);
nummovies = numel(ylabels);

x = double(users);
y = double(movies);
ratings = tbl.rating;
cdata = accumarray([y,x],ratings,[numusers,nummovies]);
h = heatmap(xlabels,ylabels,cdata);

But it throws me this error:

Error using accumarray

First input SUBS and third input SZ must satisfy ALL(MAX(SUBS)<=SZ).

machine-learning recommender-system data-visualization

share|improve this question

edited 1 hour ago

malioboro

796119

asked 8 hours ago

naveganteXnaveganteX

1306

$endgroup$

add a comment | 

1

$begingroup$

Hello fellows and folks.

I have been looking to do this for 1 month and still cannot find the way to do it.

Here’s what’s going on:

I have a csv file called ratings.csv with the following structure:

userID, movieID, rating
3, 12, 5
2, 7, 6

The rating scale goes from 0 to 5 stars. I want to be able to plot the sparsity of the matrix like it’s done in the following picture:

As you can see, ratings scale goes from 0 to 5 on the right. It is a very well thought plot.

I have Matlab, Python, R etc. Could you come up with something and help me? I’ve tried hard but I cannot find the way to do it.

This is what I have tried so far:

tbl = readtable('ratings.csv');
users = categorical(tbl.userId);
movies = categorical(tbl.movieId);
xlabels = categories(users);
ylabels = categories(movies);

numusers = numel(xlabels);
nummovies = numel(ylabels);

x = double(users);
y = double(movies);
ratings = tbl.rating;
cdata = accumarray([y,x],ratings,[numusers,nummovies]);
h = heatmap(xlabels,ylabels,cdata);

But it throws me this error:

Error using accumarray

First input SUBS and third input SZ must satisfy ALL(MAX(SUBS)<=SZ).

machine-learning recommender-system data-visualization

share|improve this question

edited 1 hour ago

malioboro

796119

asked 8 hours ago

naveganteXnaveganteX

1306

$endgroup$

add a comment | 

$begingroup$

Hello fellows and folks.

I have been looking to do this for 1 month and still cannot find the way to do it.

Here’s what’s going on:

I have a csv file called ratings.csv with the following structure:

userID, movieID, rating
3, 12, 5
2, 7, 6

The rating scale goes from 0 to 5 stars. I want to be able to plot the sparsity of the matrix like it’s done in the following picture:

As you can see, ratings scale goes from 0 to 5 on the right. It is a very well thought plot.

I have Matlab, Python, R etc. Could you come up with something and help me? I’ve tried hard but I cannot find the way to do it.

This is what I have tried so far:

tbl = readtable('ratings.csv');
users = categorical(tbl.userId);
movies = categorical(tbl.movieId);
xlabels = categories(users);
ylabels = categories(movies);

numusers = numel(xlabels);
nummovies = numel(ylabels);

x = double(users);
y = double(movies);
ratings = tbl.rating;
cdata = accumarray([y,x],ratings,[numusers,nummovies]);
h = heatmap(xlabels,ylabels,cdata);

But it throws me this error:

Error using accumarray

First input SUBS and third input SZ must satisfy ALL(MAX(SUBS)<=SZ).

machine-learning recommender-system data-visualization

share|improve this question

edited 1 hour ago

malioboro

796119

asked 8 hours ago

naveganteXnaveganteX

1306

$endgroup$

userID, movieID, rating
3, 12, 5
2, 7, 6

tbl = readtable('ratings.csv');
users = categorical(tbl.userId);
movies = categorical(tbl.movieId);
xlabels = categories(users);
ylabels = categories(movies);

numusers = numel(xlabels);
nummovies = numel(ylabels);

x = double(users);
y = double(movies);
ratings = tbl.rating;
cdata = accumarray([y,x],ratings,[numusers,nummovies]);
h = heatmap(xlabels,ylabels,cdata);

share|improve this question

edited 1 hour ago

malioboro

796119

asked 8 hours ago

naveganteXnaveganteX

1306

share|improve this question

edited 1 hour ago

malioboro

796119

asked 8 hours ago

naveganteXnaveganteX

1306

edited 1 hour ago

malioboro

796119

edited 1 hour ago

malioboro

796119

asked 8 hours ago

naveganteXnaveganteX

1306

asked 8 hours ago

naveganteXnaveganteX

1306

2 Answers
2

active

oldest

votes

2

$begingroup$

You're looking for a heatmap. Check out e.g. https://stackoverflow.com/q/33282368/3924118 (if you like Python more than the others). See also this documentation.

share|improve this answer

answered 7 hours ago

nbronbro

3,3302826

$endgroup$

add a comment | 

1

$begingroup$

I did it!

A = importdata('u.data');
user_id = A(:, 1);
movie_id = A(:, 2);
rating = A(:, 3);

% Build matrix R and w (weights matrix)
R = zeros(943, 1682);
w = zeros(943, 1682);
for i=1:100000
 R(user_id(i), movie_id(i)) = rating(i);
 w(user_id(i), movie_id(i)) = 1;
end


m = HeatMap(R)
ax = hm.plot; % 'ax' will be a handle to a standard MATLAB axes.
colorbar('Peer', ax); % Turn the colorbar on
caxis(ax, [0 5]); % Adjust the color limits

Output:

share|improve this answer

answered 2 hours ago

naveganteXnaveganteX

1306

$endgroup$

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "658"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fai.stackexchange.com%2fquestions%2f12414%2fratings-matrix-plot%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

$begingroup$

You're looking for a heatmap. Check out e.g. https://stackoverflow.com/q/33282368/3924118 (if you like Python more than the others). See also this documentation.

share|improve this answer

answered 7 hours ago

nbronbro

3,3302826

$endgroup$

add a comment | 

2

$begingroup$

You're looking for a heatmap. Check out e.g. https://stackoverflow.com/q/33282368/3924118 (if you like Python more than the others). See also this documentation.

share|improve this answer

answered 7 hours ago

nbronbro

3,3302826

$endgroup$

add a comment | 

$begingroup$

You're looking for a heatmap. Check out e.g. https://stackoverflow.com/q/33282368/3924118 (if you like Python more than the others). See also this documentation.

share|improve this answer

answered 7 hours ago

nbronbro

3,3302826

$endgroup$

share|improve this answer

answered 7 hours ago

nbronbro

3,3302826

answered 7 hours ago

nbronbro

3,3302826

answered 7 hours ago

nbronbro

3,3302826

1

$begingroup$

I did it!

A = importdata('u.data');
user_id = A(:, 1);
movie_id = A(:, 2);
rating = A(:, 3);

% Build matrix R and w (weights matrix)
R = zeros(943, 1682);
w = zeros(943, 1682);
for i=1:100000
 R(user_id(i), movie_id(i)) = rating(i);
 w(user_id(i), movie_id(i)) = 1;
end


m = HeatMap(R)
ax = hm.plot; % 'ax' will be a handle to a standard MATLAB axes.
colorbar('Peer', ax); % Turn the colorbar on
caxis(ax, [0 5]); % Adjust the color limits

Output:

share|improve this answer

answered 2 hours ago

naveganteXnaveganteX

1306

$endgroup$

add a comment | 

1

$begingroup$

I did it!

A = importdata('u.data');
user_id = A(:, 1);
movie_id = A(:, 2);
rating = A(:, 3);

% Build matrix R and w (weights matrix)
R = zeros(943, 1682);
w = zeros(943, 1682);
for i=1:100000
 R(user_id(i), movie_id(i)) = rating(i);
 w(user_id(i), movie_id(i)) = 1;
end


m = HeatMap(R)
ax = hm.plot; % 'ax' will be a handle to a standard MATLAB axes.
colorbar('Peer', ax); % Turn the colorbar on
caxis(ax, [0 5]); % Adjust the color limits

Output:

share|improve this answer

answered 2 hours ago

naveganteXnaveganteX

1306

$endgroup$

add a comment | 

$begingroup$

I did it!

A = importdata('u.data');
user_id = A(:, 1);
movie_id = A(:, 2);
rating = A(:, 3);

% Build matrix R and w (weights matrix)
R = zeros(943, 1682);
w = zeros(943, 1682);
for i=1:100000
 R(user_id(i), movie_id(i)) = rating(i);
 w(user_id(i), movie_id(i)) = 1;
end


m = HeatMap(R)
ax = hm.plot; % 'ax' will be a handle to a standard MATLAB axes.
colorbar('Peer', ax); % Turn the colorbar on
caxis(ax, [0 5]); % Adjust the color limits

Output:

share|improve this answer

answered 2 hours ago

naveganteXnaveganteX

1306

$endgroup$

A = importdata('u.data');
user_id = A(:, 1);
movie_id = A(:, 2);
rating = A(:, 3);

% Build matrix R and w (weights matrix)
R = zeros(943, 1682);
w = zeros(943, 1682);
for i=1:100000
 R(user_id(i), movie_id(i)) = rating(i);
 w(user_id(i), movie_id(i)) = 1;
end


m = HeatMap(R)
ax = hm.plot; % 'ax' will be a handle to a standard MATLAB axes.
colorbar('Peer', ax); % Turn the colorbar on
caxis(ax, [0 5]); % Adjust the color limits

share|improve this answer

answered 2 hours ago

naveganteXnaveganteX

1306

answered 2 hours ago

naveganteXnaveganteX

1306

answered 2 hours ago

naveganteXnaveganteX

1306