Append Row to bottom of table
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Theodore
il 29 Mar 2023
Commentato: Peter Perkins
il 5 Apr 2023
I'd like to append a to a Nx4 table:
Name Amt Price Change
Pears 5 $1 $0.50
Apples 10 $1.5 $0.25
Such that it will add a row with the Name, but a '-' dash for the other three, which will be added with other logic.
For example adding Oranges would change the table to:
Name Amt Price Change
Pears 5 $1 $0.50
Apples 10 $1.5 $0.25
Oranges - - -
Thank you!
0 Commenti
Risposta accettata
Dyuman Joshi
il 29 Mar 2023
Modificato: Dyuman Joshi
il 29 Mar 2023
One of the ways to achieve the output you mentioned is to use string/cell/categorical data type for the variables as it is not possible to denote '-' i.e. a dash in numeric data type
%Categorical
Name = categorical(["Pears"; "Apples"]);
Amt = categorical(["5";"10"]);
Price = categorical(["$1";"$1.5"]);
Change = categorical(["$0.5";"$0.25"]);
y = table(Name,Amt,Price,Change)
var = categorical("-");
y(3,:) = {categorical("Orange"),var, var, var}
2 Commenti
Walter Roberson
il 29 Mar 2023
Right.
To emphasize slightly: numeric variables cannot be set to be blank or to dash : if you need those output, you need to use one of char or string or categorical.
Peter Perkins
il 5 Apr 2023
Or to display with dollar signs, for that matter.
Teodore, to get what you are looking for, I recommend writing your own pretty-print function that does exactly what you need. That's kind of what Dyuman has done. Table display just isn't intended for that kind of output.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Financial Data 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!