Dear @gab1one , I have a few files with Covid data divided by cities, and some columns of these tables have binary values (e.g., “hospitalized” (Y; N); “evolution” (recovered; death)). Also, I need to calculate the hospitalization (%) rate (=number of cases/cases that leaded patients to hospitalization100); and lethality (%) rates (=number of cases/cases that leaded patients to death100). So, I ask for your help on how to count all values in each column, and thereafter how to calculate these rates? The workflow is as follows: Preproccess Covid data.knwf (211.8 KB) BTW, I had to reset CSV reader, because the whole file wold be too big for this message, but the URL to CSV file is: < https://ti.saude.rs.gov.br/covid19/download >. It was written in Portuguese, and I upload a DOCX file to explain data, column headers, translations, etc.: Terminology for columns headers - Covid Knime Project.docx (18.8 KB) Oh, I almost forgot to tell you: I had formerly normalized for “0” or “1” all binary values. My doubts are not on how to do this, but on counting different values, and on configuring nodes for calculating the rates. Can you help me with this task? Thanks in advance, Rogério.

Help with Rate Calculation

ScottF May 27, 2022, 2:30pm 4

Is this question above related to what you’re already discussing in this thread?

I think it is, yes? If so, please let me know, and I’ll close this thread to help keep the forum tidy.

1 Like