How to multiply two columns of the same table?

137 views (last 30 days)
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)
  2 Comments
Eric Sofen
Eric Sofen on 3 May 2021
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

Sign in to comment.

Accepted Answer

David Fletcher
David Fletcher on 1 May 2021
Use curly brace to extract the column data as matrices
df_train.revenue = table(df_train{:,5}.*df_train{:,6})
  1 Comment
Bengtman
Bengtman on 2 May 2021
Worked well for me without writing "Table" upfront! Thanks for the fast answer :)

Sign in to comment.

More Answers (0)

Categories

Find more on Loops and Conditional Statements 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!

Translated by