How to only display the rows with data in the result table
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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?
0 commentaires
Réponses (0)
Voir également
Catégories
En savoir plus sur Data Type Conversion dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!