function to calculate rows with non-missing data
Show older comments
I have an excel file with many missing data. How can i write a function to calculate the number of rows with no-missing data for each column.
Filename and column number will be the input variables.
Thank you!
Answers (1)
dpb
on 7 Nov 2020
0 votes
Don't need to write any functions -- use ismissing and friends with, perhaps sum and maybe all, any could be of interest as well.
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!