Label X-axis title based on excel/csv header

Question

noname 2018-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392490-label-x-axis-title-based-on-excel-csv-header

回答： Akira Agata 2018-4-11

I'd like to know if there is a way to label the x-axis based on the excel/csv header. I have multiple csv file,and I want to label them once I boxplot the selected file. I don't want to do it manually by using xtick since each file has different length of header. Can anyone help me with this? I really appreciate your help. Thanks!!!

(Here is my function, everything work fine, but I don't want to have 1,2,3,4 label in x-axis. Please help!!)

[baseFileName, folder] = uigetfile(defaultFileName, 'Select a file');
if baseFileName == 0
  % User clicked the Cancel button.
  return;
end
fullFileName = fullfile(folder, baseFileName)
data = csvread(fullFileName,2,0);
boxplot(data);
title(baseFileName);
xlabel('X', 'FontSize', 20);
ylabel('Y', 'FontSize', 20);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Akira Agata 2018-4-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392490-label-x-axis-title-based-on-excel-csv-header#answer_314478

在 MATLAB Online 中打开

By using readtable function, you can read header line in your csv file and put them to the figure. The following is an example.

[fileName, pathName] = uigetfile('*.csv', 'Select a file');
if fileName == 0
  return;
end
fullFileName = fullfile(pathName, fileName)
data = readtable(fullFileName);
boxplot(data{:,:},'Labels',data.Properties.VariableNames);
title(fileName);
xlabel('X', 'FontSize', 20);
ylabel('Y', 'FontSize', 20);