How to multiply two columns of the same table?
34 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Stephen23
il 2 Mag 2021
You need to use curly braces to acces the table content. Read this to know more:
Eric Sofen
il 3 Mag 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
Risposta accettata
David Fletcher
il 1 Mag 2021
Use curly brace to extract the column data as matrices
df_train.revenue = table(df_train{:,5}.*df_train{:,6})
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Workspace Variables and MAT-Files in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!