# How to count average number of occurance of data and Nan from text file.

1 view (last 30 days)
Prashant Dwivedi on 15 Nov 2018
Commented: Prashant Dwivedi on 15 Nov 2018
Dear all,
I'm new to Matlab
I have a text data file like :
# "Frame" "CenterofMass"
0 [5.35542667 7.49759667 6.42651167]
1 [5.36150333 7.49310833 6.44564167]
2 Nan
3 Nan
4 Nan
5 [42.3471765 12.4554735 12.32290767]
6 [22.016623 13.46475567 21.90701423]
7 [32.80792167 13.49493133 21.81519458]
8 Nan
9 [22.05034433 13.24664267 32.74229167]
I wanted to count average occurance of data(some numbers) like: (2+3+1)"sum of data row"/3 '''occurance of data row 3 times' will give average =2
same for Nan : (3+1)/2=2 .
How to do that in matlab.
Any help will be appriciated.

Arunkumar M on 15 Nov 2018
You can use xlsread function if you have the data in the form of excel or csv.
Let us take a as the variable holding data.
[m n] = size(a);
num_rows_NaN = 0;
num_rows_number = 0;
for i = 1:m
if (sum(isnan(a(i,:)))) == 0
num_rows_NaN = num_rows_NaN + 1;
else
num_rows_number = num_rows_number + 1;
end
end
Prashant Dwivedi on 15 Nov 2018
Thank you so much for help.
It's working perfactly for counting Nan and data . But i have to find average occurance of Nan and data. as I asked above.
Is it possible to find.
thank you

### Categories

Find more on Calculus 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!