How to multiply two columns of the same table?

Hello, I have a set of data with two columns: "Item_price" (column 5) , "Item_cnt_day" (column 6)

I want to multiply these to columns in order to get a new column "revenue":

When I use the operator ".*", I only get the debug result that the operator doesn't work for tables.

This is the codeline I got right now:

df_train.revenue = df_train(:,5).*df_train(:,6)

[Stephen23]

You need to use curly braces to acces the table content. Read this to know more:

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html

[Eric Sofen]

Parens indexing creates a table of a subset of the data. Curly braces or dot indexing access the contents of a table. These all do the same thing:

df_train.revenue = df_train{:,5}.*df_train{:,6}
df_train.revenue = df_train.(5).*df_train.(6)
df_train.revenue = df_train.Item_price.*df_train.Item_cnt_day

Answer 1

[David Fletcher]

Use curly brace to extract the column data as matrices

df_train.revenue = table(df_train{:,5}.*df_train{:,6})

[Bengtman]

Worked well for me without writing "Table" upfront! Thanks for the fast answer :)