Changing values within a table

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!

[Star Strider]

See also — Changing values in atable

Answer 1

[Cris LaPierre]

Try this.

trc = readtable("table1.csv");
trc.WEIGHT = trc.WEIGHT>5

You may find this page on accessing data in a table helpful.

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.

[Cris LaPierre]

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)')

You can learn more about logical arrays in Ch 12 of MATLAB Onramp.

[Cris LaPierre]

You can add a second condition for the conditional statement to check using '&'.

extract = trc.Type(trc.Type == 'WED(R)' & trc.WEIGHT == 1)