Open selected csv file and plot

2018 3 14
1 个回答
回答已采纳
更新时间：2018 3 24
7 次查看（30 天）

0 个投票

Hi everyone, I have excel file with many spreadsheets; I convert them into csv file. My problem I have now is I want to open the csv file using uigetfile, and plot that file. However, I don't know how to plot it since different file has different data size. Can anyone help me with that? Thanks alot.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

noname
noname 2018-3-24
I'd like to use the multiselect to open more than one file, then plot them, but I don't know how to approach it. I'd really appreciate if anyone could help me. Thanks alot!

请先登录，再进行评论。

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

 采纳的回答

Image Analyst
Image Analyst 2018-3-14

2 个投票

Try this:
% Have user browse for a file, from a specified "starting folder."
% For convenience in browsing, set a starting folder from which to browse.
startingFolder = pwd; % or 'C:\wherever';
if ~exist(startingFolder, 'dir')
% If that folder doesn't exist, just start in the current folder.
startingFolder = pwd;
end
% Get the name of the file that the user wants to use.
defaultFileName = fullfile(startingFolder, '*.*');
[baseFileName, folder] = uigetfile(defaultFileName, 'Select a file');
if baseFileName == 0
% User clicked the Cancel button.
return;
end
fullFileName = fullfile(folder, baseFileName)
data = csvread(fullFileName);
x = data(:, 1); % Or wherever
y = data(:, 2);
plot(x, y, 'b*-', 'LineWidth', 2);
grid on;
title('Y vs. X', 'FontSize', 20);
xlabel('X', 'FontSize', 20);
ylabel('Y', 'FontSize', 20);

7 个评论
显示 5更早的评论 隐藏 5更早的评论

noname
noname 2018-3-14
I can't get it plot. I only can open the file. It said:
Undefined function or variable 'fullFileName'.
Error in test (line 12) data = csvread(fullFileName);
Image Analyst
Image Analyst 2018-3-15
编辑：Image Analyst 2018-3-15
I just tried it and it works fine. Do you NOT have this line of code in there:
fullFileName = fullfile(folder, baseFileName)
??? That defines the variable, but you're saying it tells you the variable is not assigned, meaning that you did not put the line of code in there. Attach your ACTUAL code if you need more help.
noname
noname 2018-3-15
Thanks, I will try it. Do you know how to plot it using boxplot? Again, thank you for your time.
Image Analyst
Image Analyst 2018-3-15
I don't use boxplot(). What I'd do is to look in the documentation for an example of how to use it.
noname
noname 2018-3-15
编辑：per isakson 2018-3-16
So I basically copy and paste your code on my file. however, I got this error, do you think I need to change my csv format?
Error using dlmread (line 138)
Mismatch between file and format string.
Trouble reading number from file (row 1u, field 1u) ==>
numberone,numbertwo,numberthree\n
Error in csvread (line 47)
m=dlmread(filename, ',', r, c);
Error in test (line 16)
data = csvread(fullFileName);
per isakson
per isakson 2018-3-16
编辑：per isakson 2018-3-16
>> m=dlmread( 'Book3.csv', ',', 1,0);
works fine, but
>> m=dlmread( 'Book3.csv', ',', 0,0);
Error using dlmread (line 147)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field number 1) ==>
numberone,numbertwo,numberthree,numberfour\n
You must chose values of r and c that doesn't include the header.
noname
noname 2018-3-24
Thank you all for your help. I found my solution. :)

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by