I have 100's of column CSV data with 50000 row data. i want to convert it into matlab. can anyone help me with this.

I have a >100 of column data with >30000 of row data in CSV format. I tried to plot this in EXCEL but in excel it is not have any clarity and the data i have plotted is not been Zoomed in EXCEL. The data i cant put it here can anyone please help me solve this one. it is very urgent to me. i am a working proffssional.

[Stephen23]

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

https://www.mathworks.com/help/matlab/ref/dir.html

https://www.mathworks.com/help/matlab/ref/readmatrix.html

https://www.mathworks.com/help/matlab/ref/readtable.html

https://www.mathworks.com/help/matlab/ref/plot.html

[Cris LaPierre]

I'd add the following link to the list

https://www.mathworks.com/help/matlab/import_export/read-and-analyze-data-in-a-tabulartextdatastore.html

Answer 1

[Shishir Reddy]

Hi Sandeep,

As per my understanding, you want to extract the data from a .csv file and store in the MATLAB variable and then plot it.

Here’s a sample MATLAB code to perform the same.

%store the table in data     
data = readmatrix('data.csv'); 
[r, c] = size(data);   

%Setup figure                
figure;                      
hold on;                    
for i = 1:c                  
    plot(data(:, i))        
end                             
%labels and legends can also be added

hold off;

In every iteration of the loop, we get one plot. Therefore, in total we get ‘c’ plots where c is the number of columns in the excel sheet.

For further reference, please refer these links to know more about ‘readmatrix’ and ‘plot’ functions.

https://www.mathworks.com/help/matlab/ref/readmatrix.html

https://www.mathworks.com/help/matlab/ref/plot.html

I hope this helps resolving the issue.