Borrar filtros
Borrar filtros

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

1 visualización (últimos 30 días)
Mili Shah
Mili Shah el 20 de Jul. de 2018
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?

Respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by