Browse CSV file and calculate the mean

Hello everyone,

I am on the end on my projet. I need to browse a csv file and to calculate the mean of these values. Then i will put this mean in a new csv file

Does anyone have suggestion or programme for help ?

Thanks

Answer 1

[Ameer Hamza]

1) Read the csv file using: readmatrix(): https://www.mathworks.com/help/matlab/ref/readmatrix.html, or readtable(): https://www.mathworks.com/help/matlab/ref/readtable.html.

2) Calculate the mean values of the data according to its dimensions.

3) Write the data to file using writematrix(): https://www.mathworks.com/help/matlab/ref/writematrix.html or writetable(): https://www.mathworks.com/help/matlab/ref/writetable.html

[Abbass SAYEGH]

Is it possible to print a message in the console to ask and to choose directly the area for the process ?

[Ameer Hamza]

What do you mean by area?

[Abbass SAYEGH]

like for example the range A1:A20

[Ameer Hamza]

yes, you can specify the range too. For example,

range = input('Input the range: ', 's'); % input A1:A20
data = readmatrix('filename.csv', 'range', range)