Why matlab reading data from csv file completely different ?

Hi,

I am reading first and 7 column from the csv file attached using the code below but whenever on workspace I check the csv file data it is completely different then

what I have in the csv file. Why is this happening?

Code:

%Read the CSV file and Extract data
data=csvread('Mesh.csv',1,0);   % read the csv file, skip header row
plot(data(:,1),data(:,7))            % plot 2nd column vs 1st
xlabel('Cases')
ylabel('totalcell')

Answer 1

[VBBV]

The data in 2nd column of your csv file is treated as text since it was not pasted to excel file correctly,

See the attached file which is corrected now. Use readtable instead of csvread

[VBBV]

You can also use readmatrix

TT = readmatrix('Mesh.csv')
plot(TT(:,1),TT(:,7))

This is how plot looks like

[muhammad choudhry]

Thanks for the help!