How to count average number of occurance of data and Nan from text file.
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Prashant Dwivedi
le 15 Nov 2018
Commenté : Prashant Dwivedi
le 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.
thank you in advance
0 commentaires
Réponse acceptée
Arunkumar M
le 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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import and Export 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!