Xjyuk

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

why "American-born", not "America-born"?

Variable does not Exist: CaseTrigger

What does `LOGFILE=$1:-/var/log/syslog` do?

Can the Conjure Barrage spell stack with the Disarming Attack or Trip Attack Battle Master maneuvers?

How did the Allies achieve air superiority on Sicily?

Team member is vehemently against code formatting

Meaning of "half-crown enclosure"

Are there any tips to help hummingbirds find a new feeder?

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

DeleteCases using two lists but with partial match?

Salesforce bug enabled "Modify All"

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

Is it safe to redirect stdout and stderr to the same file without file descriptor copies?

Is ideal gas incompressible?

Make the `diff` command look only for differences from a specified range of lines

Can someone get a spouse off a deed that never lived together and was incarcerated?

mmap: effect of other processes writing to a file previously mapped read-only

Are there historical examples of audiences drawn to a work that was "so bad it's good"?

What is this dime sized black bug with white on the segments near Loveland Colorodao?

Proto-Indo-European (PIE) words with IPA

Department head said that group project may be rejected. How to mitigate?

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

Ratings matrix plot

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 42 mins ago

malioboro

796119

asked 7 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 42 mins ago

malioboro

796119

asked 7 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 42 mins ago

malioboro

796119

asked 7 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 42 mins ago

malioboro

796119

asked 7 hours ago

naveganteXnaveganteX

1306

share|improve this question

edited 42 mins ago

malioboro

796119

asked 7 hours ago

naveganteXnaveganteX

1306

edited 42 mins ago

malioboro

796119

edited 42 mins ago

malioboro

796119

asked 7 hours ago

naveganteXnaveganteX

1306

asked 7 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 6 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 1 hour 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 6 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 6 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 6 hours ago

nbronbro

3,3302826

$endgroup$

share|improve this answer

answered 6 hours ago

nbronbro

3,3302826

answered 6 hours ago

nbronbro

3,3302826

answered 6 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 1 hour 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 1 hour 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 1 hour 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 1 hour ago

naveganteXnaveganteX

1306

answered 1 hour ago

naveganteXnaveganteX

1306

answered 1 hour ago

naveganteXnaveganteX

1306