Divide column 17 of table by 365
15 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
xander fong
le 30 Juil 2015
Réponse apportée : Peter Perkins
le 30 Juil 2015
Hello, I have a 1500x15 table, how do I divide every element in the 15th column by 365? Or, how do I create a new column which is column 15 divided by 365?
0 commentaires
Réponse acceptée
Sean de Wolski
le 30 Juil 2015
Modifié(e) : Sean de Wolski
le 30 Juil 2015
y = x{:,15}./365
x{:,16} = y
2 commentaires
Sean de Wolski
le 30 Juil 2015
Sorry, typo. It needs to be {} instead of () to extract from the table. See fix above.
Plus de réponses (1)
Peter Perkins
le 30 Juil 2015
More directly:
x.Var15 = x.Var15 / 365 % or whatever the 15th var is named
or
x.Var16 = x.Var15 / 365 % or whatever the new 16th var should be named
table brace subscripting is most useful for multiple variables, while the dot is more clear when there's only one.
Dividing by 365 sounds like a leap year bug just waiting to happen. Should you be using the calendar calculations built into datetime and calendarDuration?
0 commentaires
Voir également
Catégories
En savoir plus sur Data Type Identification 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!