How to multiply two columns of the same table?

58 views (last 30 days)
Bengtman on 1 May 2021
Commented: Eric Sofen on 3 May 2021
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)
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 on 2 May 2021
Worked well for me without writing "Table" upfront! Thanks for the fast answer :)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by