Get minimum value per column with Table Compute

[dariakoppes]

Hi,

I have a question about the table compute tool. Whatever I change in the syntax the custom expression on the whole table does not work. It outputs an empty tabular file instead of a table with the new values. See the image below.

Here the steps that I followed in table compute tool:

• “Input Single or Multiple Tables”: Single Table
  • param-file “Table”: iris.csv with box: input data has Column names on the first row checked
  • “Type of table operation”: Perform a full table operation
    • “Operation”: Custom
      • “Custom expression on ‘table’, along ‘axis’ (0 or 1)”: table.sub(table.min(0), 0)

Any help with solving this problem would be appreciated!

Daria

[jennaj]

Hi @dariakoppes

Are you trying to compute the minimum value per column? Please try this:

If you want to instead calculate the minimum value per column AND subtract that minimum from all the original values in that same column, change the operation to this:

[dariakoppes]

Thankyou I wanted to indeed calculate the minimum value per column AND substract that minimum from all the original values in that same column. This works now!

Greetings