Seeking help to list all Yticks

Question

Maria Baeza 2023-4-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1948578-seeking-help-to-list-all-yticks

回答： Cris LaPierre 2023-4-17

My_Music.csv

I have created a file with Python containing all the metadata of my music collection. I am trying to graph my music in hours by Genre using a Pareto chart, which seems to be working but I have not been able to figure out how to show all Genres (YTicks).

% Load the table

data = readtable('My_Music.csv');

% Convert the Song_Time column to hours

data.Song_Time = data.Song_Time / 3600;

% Create a grouped table by Genre and sum the Song_Time for each Genre

groupedData = varfun(@sum, data, 'GroupingVariables', 'Genre', 'InputVariables', 'Song_Time', 'OutputFormat', 'table');

% groupedData.Properties.VariableNames{'GroupingVariables'} = 'Genre';

% Sort the table by descending order of total time

groupedData = sortrows(groupedData,2);

% Calculate cumulative percentage

total = groupedData.sum_Song_Time / sum(groupedData.sum_Song_Time) * 100;

cumulative_percent = cumsum(total);

% Create horizontal bar chart

figure;

barh(groupedData.sum_Song_Time);

hold on;

yticklabels(groupedData.Genre);

yticks(groupedData.Genre);

Error using yticks
Invalid tick values. To set tick labels use yticklabels.

set(gca,'yticklabel', groupedData.sum_Song_Time);

xlabel('Total Time (Hours)');

title('Pareto chart of total time by Genre');

2 个评论
显示无隐藏无

Image Analyst 2023-4-17

You forgot to attach 'D:\Music\My_Music.csv'.

Why are all genres not showing in the y tick labels? Which ones are missing?

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

Maria Baeza 2023-4-17

Almost all of the genres are missing.

I have now attached the csv file as requested.

Ed

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2023-4-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1948578-seeking-help-to-list-all-yticks#answer_1217543

在 MATLAB Online 中打开

My_Music.csv

You need to set yticks first, then assign a label for each tick.

Something like this (updated code a little).

data = readtable('My_Music.csv');

sumTbl = groupsummary(data,"Genre","sum","Song_Time");

sumTbl = sortrows(sumTbl,"sum_Song_Time")

sumTbl = 29×3 table

Genre GroupCount sum_Song_Time _______________________ __________ _____________ {0×0 char } 1 271 {'Comedy' } 8 1602 {'Salsa' } 12 3397 {'Patriotic' } 14 3436 {'Soundtrack' } 19 5265 {'Celtic' } 33 7173 {'Zydeco' } 33 7293 {'Hawaiian' } 35 8049 {'World' } 46 9575 {'Classical' } 43 10956 {'Punk' } 50 17874 {'Funk' } 78 23341 {'Disco & Dance Music'} 88 23557 {'Latin' } 112 26216 {'Folk' } 107 26841 {'Jazz' } 226 69074

barh(sumTbl.sum_Song_Time)

yticks(1:height(sumTbl));

yticklabels(sumTbl.Genre)