Changing values within a table
22 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I want to make all weights (4th column) that are larger than 5 display the value 1 and all values below 5 to display 0.
This is what I have done so far, but it does not work.
T = table(column4); % Creating column table
A = table2array(T) % Converting table to an aray
A > 5
Thank you in advance!
Risposte (1)
Cris LaPierre
il 20 Mar 2021
Modificato: Cris LaPierre
il 20 Mar 2021
Try this.
trc = readtable("table1.csv");
trc.WEIGHT = trc.WEIGHT>5
A comment as well that I can't see what the full name of the 4th column is, so I assumed "WEIGHT". Update this code to match whatever the actual name is.
2 Commenti
Cris LaPierre
il 20 Mar 2021
Modificato: Cris LaPierre
il 20 Mar 2021
Your indexing is wrong. The use of dot notation already selects the 4th column (trc.WEIGHT). The curly braces in addition are not a valid syntax. See the table I linked to previousy for valid ways to access data in a table.
You probably want something that selects the column and then specific rows inside that column. The approach below creates a logical array to indicate which rows in trc.Type to extract.
extract = trc.Type(trc.Type == 'WED(R)')
Cris LaPierre
il 20 Mar 2021
Modificato: Cris LaPierre
il 20 Mar 2021
You can add a second condition for the conditional statement to check using '&'.
extract = trc.Type(trc.Type == 'WED(R)' & trc.WEIGHT == 1)
Vedere anche
Categorie
Scopri di più su Logical 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!