want to read 38 csv files only first and second column?

Hi,

I want to read first and second coloumn of the 48 .csv files then plot the data from them coloumns. Once data plotted seaparately then want to apply the circle algoritham to it which will give me the estimated radius of the circle in list or array then I want to plot them against time?

Can you guys help I do not know how to read column 1 and 2 of them 48 files?

[Sudhakar Shinde]

readmatrix, csvread or readtable could help you to read csv file. For more specific if you could add example csv file data and the 48 csv filenames, hopefully names are in serial form ex. file1.csv ,file2.csv and so on.

To plot data function plot will help.

[muhammad choudhry]

file names are like contours0.90....till contours0.137......I have attached the few files only wants to read first 2 columns which represents x and y values of the plot ...z -axis values are not needed which is 3rd column.

[muhammad choudhry]

and this a algoritham code which will then applied to find the radius of the circle I can do manually one by one but that's not a goal.

Answer 1

[Sudhakar Shinde]

csvFile = dir("*.csv") ; 
N = length(csvFile) ;
for i = 1:N
    data = readtable(csvFile(i).name) ;  
    iwant = data.Points_0;  
    iwant1 = data.Points_1;
    % do what you want 
end

[muhammad choudhry]

what does this line representing ? data = readtable(csvFiles(i).name) as I am getting error in this line does anything req. to change here ?

Unrecognized function or variable 'csvFiles'.

Error in SimuCircle (line 7)

data = readtable(csvFiles(i).name) ;

[Sudhakar Shinde]

it was typing error.

use csvFile instead of csvFiles. Corrected in above code lines.

Answer 2

[KSSV]

csvFiles = dir("*.csv") ; 
N = length(csvFiles) ;
for i = 1:N
    data = csvread(csvFiles(i).name) ;  % also read about xlsread 
    iwant = data(:,1:2) ;  % read first two columns 
    % do what you want 
end

[dpb]

If all is wanted/needed is the first two columns, may as well just write

data=data(:,1:2) ;  % keep only first two columns 

and not have duplicated/unwanted data hanging around...

[muhammad choudhry]

Hi,

I am getting this error!

Unrecognized function or variable 'csvFiles'.

Error in SimuCircle (line 7)

data = csvread(csvFiles(i).name) ; % also read about xlsread

[Sudhakar Shinde]

Name of csv file contains multiple dots , example: contours0.90.csv and looks like csvread producess error for this.

Use readtable or readmatrix instead.

[KSSV]

There is a typo error..edited the code.....