Divide column 17 of table by 365

51 views (last 30 days)
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?

Accepted Answer

Sean de Wolski
Sean de Wolski on 30 Jul 2015
Edited: Sean de Wolski on 30 Jul 2015
y = x{:,15}./365
x{:,16} = y
  2 Comments
xander fong
xander fong on 30 Jul 2015
Doesn't work. "Undefined operator './' for input arguments of type 'table'."
Sean de Wolski
Sean de Wolski on 30 Jul 2015
Sorry, typo. It needs to be {} instead of () to extract from the table. See fix above.

Sign in to comment.

More Answers (1)

Peter Perkins
Peter Perkins on 30 Jul 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?

Categories

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