Read non-negative cells from a cell array

Question

Damith 2014-11-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/161648-read-non-negative-cells-from-a-cell-array

回答： Voss 2024-1-9

Hi,

I have following code to read two csv files. I need to read the non-negative cell values from col 6 of Dt cell array and corresponding cell array from col 5 with YYYY-MM-DD format and store it in "Data" cell array.

Any suggestions to do that inside the for loop. Please see the two csv files attached.

Thanks in advance.

clear all
cd ('<path1>')
myFolder = '<path2>';
if ~isdir(myFolder)
  errorMessage = sprintf('Error: The following folder does not exist:\n%s', myFolder);
  uiwait(warndlg(errorMessage));
  return;
end
filePattern = fullfile(myFolder, '*.csv');
csvFiles = dir(filePattern);
celsplt = @(x) strsplit(x, ',' ,'CollapseDelimiters',1);
for k = 1:length(csvFiles)
  fid(k) = fopen(fullfile(myFolder,csvFiles(k).name));
  out{k} = textscan(fid(k),'%s%s%f','delimiter','\t');
  Ds = cellfun(celsplt,out{1,k}{1,1}, 'Uni',0);
  Dt{k} = vertcat(Ds{:});  
  fclose(fid(k));
end

Sample of Dt cell array is shown below.

Dt=
  'KH'  '100401'  'PH'  'M'  '1970-12-31T07:00:00+07:00'  '-9999.00'  'mm'  'O'
  'KH'  '100401'  'PH'  'M'  '1971-01-01T07:00:00+07:00'  '0.00'          'mm'  'O'
  'KH'  '100401'  'PH'  'M'  '1971-01-02T07:00:00+07:00'  '0.00'          'mm'  'O'

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Star Strider 2014-11-7

For context, see my (as yet unaccepted) Answer at Read all the columns in a .csv file.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Voss 2024-1-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/161648-read-non-negative-cells-from-a-cell-array#answer_1386421

在 MATLAB Online 中打开

myFolder = '.';
filePattern = fullfile(myFolder, '*.csv');
csvFiles = dir(filePattern);
N = numel(csvFiles);
Data = cell(N,1);
for k = 1:N
    C = readcell(fullfile(myFolder,csvFiles(k).name));
    Data{k} = C([C{:,6}]>=0,[5 6]); % use 5 instead of [5 6] if you just want the dates
end
disp(Data)
    {5113×2 cell}
    {8681×2 cell}

That makes Data a cell array with a cell for each file. If you want everything together you can do:

Data = vertcat(Data{:})
Data = 13794×2 cell array
    {'1971-01-01T07:00:00+07:00'}    {[0]}
    {'1971-01-02T07:00:00+07:00'}    {[0]}
    {'1971-01-03T07:00:00+07:00'}    {[0]}
    {'1971-01-04T07:00:00+07:00'}    {[0]}
    {'1971-01-05T07:00:00+07:00'}    {[0]}
    {'1971-01-06T07:00:00+07:00'}    {[0]}
    {'1971-01-07T07:00:00+07:00'}    {[0]}
    {'1971-01-08T07:00:00+07:00'}    {[0]}
    {'1971-01-09T07:00:00+07:00'}    {[0]}
    {'1971-01-10T07:00:00+07:00'}    {[0]}
    {'1971-01-11T07:00:00+07:00'}    {[0]}
    {'1971-01-12T07:00:00+07:00'}    {[0]}
    {'1971-01-13T07:00:00+07:00'}    {[0]}
    {'1971-01-14T07:00:00+07:00'}    {[0]}
    {'1971-01-15T07:00:00+07:00'}    {[0]}
    {'1971-01-16T07:00:00+07:00'}    {[0]}