How to only display the rows with data in the result table

Question

Mili Shah 2018-7-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411332-how-to-only-display-the-rows-with-data-in-the-result-table

I have code to calculate specific aspects of some data. The results, by county, are stored in a table, based on each county's identification code. I have county numbers that go up to 55139, but I only want my result table to display the rows that have data - right now all the blank county codes have zeros. How can I do this?

for geoCode=1003:55139
      whichBin = {2012:2013};
      binType = 'annual';
      binList =  {2012:2013};
      geoRegion = 'FIPS';
      whichYears = [2012:2013];
      whichDay = 'MTWThFSatSun';
      %make sure this is the unique ID of the directory you want to use!
      randStr = 'ckvc';
      csvData = ['tweetograms/tweetograms_' binType '_' geoRegion ...
                '_2012_2013_' randStr '/' binType '/' whichDay '/' num2str(geoCode) '.csv'];
      if ~exist(csvData,'file'),continue,end
      tweetogramData = csvread(csvData);
      tweetogramSmooth = smooth(tweetogramData);
      [lunchpk, loc1] = max(tweetogramSmooth(44:60));
      [dinnerpk, loc2] = max(tweetogramSmooth(68:92));
      lunchloc = loc1 + 43;
      dinnerloc = loc2 + 67;
      outTable(geoCode,:) = table(geoCode, whichDay, lunchloc, lunchpk, dinnerloc, dinnerpk);
end

My result table has a row for each number 1-55139, but I only have about 631 county codes total. How can I eliminate the rows that don't have any data from my table so it is compact?