Plotting graph from the data of a csv file

Hi, I am using MATLAB R2016a. I have got into a situation where I have to parse through a csv file and draw a plot using them. I am using the following code for that. close all; file = 'test.csv';

Array = csvread(file); col1 = Array(:, 1); col2 = Array(:, 2); plot(col1, col2)

There are total 6 columns in the csv file. I am getting the following errors.

Error using dlmread (line 147) Mismatch between file and format string. Trouble reading 'Numeric' field from file (row number 1, field number 1) ==> /in X,/in Y,/z X,/z Y,/out X,/out Y\n

Error in csvread (line 48) m=dlmread(filename, ',', r, c);

Error in untitled (line 4) Array = csvread(file);

Can anyone suggest me a solution? Thanks in advance.

Regards

Saikat Chatterjee

[Nithya Ravi]

How to merge the two arrays [col1 col2] into a single variable to perform mean?

Answer 1

[Benjamin Kraus]

My recommendation is to try the "Import Data" wizard (look for the "Import Data" button on the tool strip). Select your file, set up how you want to import your data, and then you can generate a script to automate the importing in the future.

If that doesn't work, can you post a few lines of the CSV file? Either real data or arbitrary data in the same format?

[Skot]

Thanks a lot Benjamin, it worked.

[Jesus Beltran]

What do we do with the generated script?