MATLAB Answers

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

1 ビュー (過去 30 日間)
Prashant Dwivedi 2018 年 11 月 15 日
コメント済み: Prashant Dwivedi 2018 年 11 月 15 日
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.
thank you in advance

サインインしてコメントする。

### 採用された回答

Arunkumar M 2018 年 11 月 15 日
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
##### 1 件のコメント表示非表示 なし
Prashant Dwivedi 2018 年 11 月 15 日
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

サインインしてコメントする。

### Community Treasure Hunt

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

Start Hunting!