Divide column 17 of table by 365

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?

Answer 1

[Sean de Wolski]

 y =  x{:,15}./365
x{:,16} = y

[xander fong]

Doesn't work. "Undefined operator './' for input arguments of type 'table'."

[Sean de Wolski]

Sorry, typo. It needs to be {} instead of () to extract from the table. See fix above.

Answer 2

[Peter Perkins]

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?