How to select particular column from csv file using csvread function in Matlab

1 次查看（过去 30 天）

POKA 2017-11-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/369628-how-to-select-particular-column-from-csv-file-using-csvread-function-in-matlab

评论： POKA 2017-11-28

Hi Friends,

In my working place we are using Matlab student version 1999. As a work purpose I need to extract few columns of data from large csv file. So far our implementation was writing %f or %*f for all columns depending on number of columns we want.But it is cumbersome task to write so lengthy line. I have seen xlsread function to read particular column from csv file in new matlab version. But since we are using student version I am unable to get this feature. Also I have gone through csvread(filename,R1,C1,[R1,C1,R2,C2))feature of csvread but could not make success to read desired columns.

%My input is 'Navdata.csv'

    Time .......missing columns not required..         Latitude(30th column)  Longitude     Altitude
    1234                                                 0.3567                 0.4678         356
    ....                 .....                           ......                          ....           ...
    % Using xlsread
     extract_data=xlsread('Navdata.csv','Navdata','A:A')