# Table findRows() multiple criteria
**URL:** https://discourse.processing.org/t/table-findrows-multiple-criteria/37595
**Category:** Coding Questions
**Tags:** homework
**Created:** [June 17, 2022, 11:58am UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595 "2022-06-17T11:58:16Z")
**Posts on this page:** 19
**Page:** 1
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 17, 2022, 11:58am UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/1 "2022-06-17T11:58:16Z")
Hello,
Say I’m importing a .csv table where headers are:
Column 2 - Data\_value
Column 11 - Series\_title\_2
and I’m printing out the values from column 2 where column 11 contains “Mining”, as follows:
```auto
Table table = loadTable("data.csv","header");
for(TableRow row : table.findRows("Mining","Series_title_2")) {
println(row.getInt("Data_value"));
}
```
Now, how can I concatenate more filters? I.e. by also adding “Actual” from column 12 - Series\_title\_3?
I’ve tried a for loop inside the for loop to no avail.
Thanks
---
### Author:  [@glv](https://discourse.processing.org/u/glv)
#### Post date: [June 17, 2022, 12:40pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/2 "2022-06-17T12:40:29Z")
Hello,
Tutorial here:
> **[Data](https://processing.org/tutorials/data/)**
>
> Learn the basics of working with data feeds in Processing.
If you know the row that contains “Mining” you then check if column 2 with that row contains that value.
Try _get.String()_
References:
[https://processing.org/reference/Table.html](https://processing.org/reference/Table.html)
You will need “equals” to compare strings:
[https://processing.org/reference/String\_equals\_.html](https://processing.org/reference/String_equals_.html)
`:)`
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 17, 2022, 1:19pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/3 "2022-06-17T13:19:30Z")
Hi @glv, thanks for the references.
I checked the ‘Table’ ref page with all the methods inside out for hours yesterday, and the Data tutorial provided is identical to the Data chapter from the ‘Learning Processing Morgan Kaufmann Series’ by Daniel Shiffman book, which I’m using as a textbook to learn Processing.
As far as I know, getString() will give me one unique value when row/column is specified, but the result of my code so far is a list of 300 values, which I need to further reduce to 44 by introducing additional filters (similar to concatenating filters in Excel).
Right now, I’m able to apply the single filter of “Mining”, but I need to add the “Total earnings” and “Actual” ones to get the values from column C below.
Are you suggesting running that for loop 3 times with single filters each then use equals to compare the results? Sorry can’t seem to get the idea there ☹
---
### Author:  [@Chrisir](https://discourse.processing.org/u/Chrisir)
#### Post date: [June 17, 2022, 5:47pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/4 "2022-06-17T17:47:03Z")
> [@Erif](#):
>
> `table.findRows("Mining","Series_title_2")`
When you put this in an separate line, what’s the return type please? Array of rows?
`TableRow[] = ....` does that work?
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 17, 2022, 6:00pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/5 "2022-06-17T18:00:05Z")
@Chrisir Nope… or I’m doing it wrongly.
Do you mean like this?
```auto
TableRow[] row = table.findRows("Mining","Series_title_2");
```
---
### Author:  [@Chrisir](https://discourse.processing.org/u/Chrisir)
#### Post date: [June 17, 2022, 6:18pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/6 "2022-06-17T18:18:44Z")
That’s what I meant. Then you can for lioop
over row (which is not a good name)
I was just thinking about whether you can apply the same command findRows on this array again? Or make it to a table and then use the command again?
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 17, 2022, 6:28pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/7 "2022-06-17T18:28:02Z")
I was trying this… but doesn’t seem to work (below full code). It made sense to me to be restricting the output more and more by adding additional loops/conditions.
```auto
void setup() {
size(500,500,P2D);
loadData();
}
void draw() {
background(255);
}
void loadData() {
Table table = loadTable("data.csv","header");
for(TableRow row : table.findRows("Mining","Series_title_2")) {
for(TableRow row1 : table.findRows("Actual","Series_title_3")) {
for(TableRow row2 : table.findRows("Total earnings","Series_title_1")) {
println(row2.getInt("Data_value"));
noLoop();
}
}
}
}
```
The idea is to get the values I need first with println() then represent them in a graph.
---
### Author:  [@Chrisir](https://discourse.processing.org/u/Chrisir)
#### Post date: [June 17, 2022, 6:34pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/8 "2022-06-17T18:34:04Z")
When you look [here:](https://processing.org/reference/Table_matchRows_.html)
Maybe you can write a regexp with AND?
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 17, 2022, 6:47pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/9 "2022-06-17T18:47:52Z")
Looked at it as well yesterday but don’t find anything that works… i.e:
1. concatenating .findRows, I get an error saying that findRows(String,String) does not exist
```auto
for(TableRow row : table.findRows("Mining","Series_title_2").findRows("Actual","Series_title_3")) {
println(row.getInt("Data_value"));
noLoop();
}
```
1. Using &&, no good either…
```auto
for(TableRow row : table.findRows("Mining","Series_title_2") && table.findRows("Actual","Series_title_3")) {
println(row.getInt("Data_value"));
noLoop();
}
```
The problem is that I can’t find a method from the Table object that accepts multiple parameters
---
### Author:  [@glv](https://discourse.processing.org/u/glv)
#### Post date: [June 17, 2022, 7:01pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/10 "2022-06-17T19:01:07Z")
Hello @Erif,
Consider simplifying and iterate through each row of the table and perform any required tasks.
Consider using logical operators.
Example
```auto
Table table = loadTable("data.csv", "header");
for (int i = 0; i **[Logical Operators / Examples](https://processing.org/examples/logicaloperators.html)**
>
> The logical operators for AND (&&) and OR (||) are used to combine simple relational statements into more complex expressions. The NOT (!) operator is used to negate a boolean statement.
I also added a comment to code above.
`:)`
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 17, 2022, 8:45pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/11 "2022-06-17T20:45:33Z")
mmm… I’m afraid this doesn’t work either… or I don’t know how to apply it ☹
As per the image below with a simpler table, the output of println() should be just those 13 values in column 3, that is:
147.870064
148.915685
143.481452
145.689559
139.114093
143.738115
144.76762
140.216363
153.26737
145.279694
141.911001
154.31287
149.699332
There is not a single string value from columns Series\_title\_1,2 and 3 which is common between those columns, so I fail to see how s1.equals(s2) would work??
````auto
Table table = loadTable("data.csv","header");
for(int i = 0; i < table.getRowCount(); i++) {
TableRow row = table.getRow(i);
String s1 = row.getString("Series_title_1");
String s2 = row.getString("Series_title_2");
String s3 = row.getString("Series_title_3");
int i1 = row.getInt("Data_value");
println(s1,s2,s3,i1);
noLoop();
if(s1.equals(s2) || s2.equals(s3)) {
println("Yay!");
table.setInt(i,"Data_value",1);
}
}```
````
---
### Author:  [@glv](https://discourse.processing.org/u/glv)
#### Post date: [June 17, 2022, 9:55pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/12 "2022-06-17T21:55:41Z")
> [@Erif](#):
>
> There is not a single string value from columns Series\_title\_1,2 and 3 which is common between those columns, so I fail to see how s1.equals(s2) would work??
> [@glv](#):
>
> Modify as required.
I provided an example… not a direct answer to your question.
I added an update to my previous topic.
`:)`
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 20, 2022, 4:03pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/13 "2022-06-20T16:03:20Z")
Aaaaaaaahhhhh, got it! I’m so used to the Excel rationale when it comes to filters that didn’t see the way of thinking in programming is different lol
Ok, so my code is correct till ‘println(income)’; now I get the target 13 values 🤘😝
Now, when I try to store those values in the table by using ‘table.setFloat’ then use those income values as the height for a bar chart is when there’s something missing 🤔.
```auto
Table table = loadTable("data.csv","header");
for(int i = 0; i < table.getRowCount(); i++) {
//iterate over all the table rows
TableRow row = table.getRow(i);
//define variables to retrieve the column headers I'm interested to filter by
String s1 = row.getString("Series_title_1");
String s2 = row.getString("Series_title_2");
String s3 = row.getString("Series_title_3");
//define the target variable from where I need to get my results
float income= row.getFloat("Data_value");
//define filtering condition
if(s1.equals("Total earnings") && s2.equals("Mining") && s3.equals("Actual")) {
println(income);
table.setFloat(i,"Data_value",income);
}
//draw rectangles whose height equals income
//I think the problem is here when defining the bar widths?!?
float w = width/income;// or... table.getRow(i).getFloat("Data_value");
fill(0);
stroke(255);
rect(w*i,height-income,w,income);
}
```
---
### Author:  [@glv](https://discourse.processing.org/u/glv)
#### Post date: [June 21, 2022, 12:08am UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/14 "2022-06-21T00:08:48Z")
Hello @Erif,
Consider
- using a counter in the if statement and increment each time you get a hit.
use a println() to watch this increment … 0, 1, 2, 3…
- use this counter for the rectangle spacing
- think about where you want to draw the bars… in the if or after?
I used a fixed width for w and was able to get a graph for 4 “hits”:
`:)`
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 21, 2022, 4:21pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/15 "2022-06-21T16:21:29Z")
1 Cool! @glv I’m getting closer 😊 I followed those points and managed to get the counter working and printing the 1,2,3 …13 to account for all the hits.
3 My view is that you need to draw the bar inside the if in order to obtain just 13 bars, otherwise the filter would not apply.
2 What I’m struggling with now is the rectangle spacing, that is how to obtain the max(count) to divide the width always by 13. Right now as count is always increasing so is the denominator of ‘w’.
```auto
int count = 0; //var to count the final number of filtered values
Table table = loadTable("data.csv","header");
for(int i = 0; i < table.getRowCount(); i++) {
//iterate over all the table rows
TableRow row = table.getRow(i);
//define variables to retrieve the column headers I'm interested to filter by
String h1 = row.getString("Series_title_1");
String h2 = row.getString("Series_title_2");
String h3 = row.getString("Series_title_3");
//define variables to retrive the text filters we're looking for
String filter1 = "Total earnings";
String filter2 = "Mining";
String filter3 = "Actual";
//define filtering condition
if(h1.equals(filter1) && h2.equals(filter2) && h3.equals(filter3)) {
//define the target variable from where I need to get my results
float income = row.getFloat("Data_value");
//increment the counting
count++;
//draw rectangles whose height equals income
float w = width/count;
fill(0);
stroke(255);
rect(0,height,w,-income); //I know 0 is not correct but w*i doesn't work so one at a time :)
println(income + " / " + count + " / " + w);
}
}
```
---
### Author:  [@glv](https://discourse.processing.org/u/glv)
#### Post date: [June 21, 2022, 5:46pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/16 "2022-06-21T17:46:03Z")
> [@Erif](#):
>
> `rect(0,height,w,-income); //I know 0 is not correct but w*i doesn't work so one at a time :)`
Keep thinking about it…
counter: 0, 1, 2, 3, 4…
x: 0, 50, 100, 150, 200…
Reference:
> **[rect() / Reference](https://processing.org/reference/rect_.html)**
>
> Draws a rectangle to the screen. A rectangle is a four-sided shape with every angle at ninety degrees. By default, the first two parameters set the location of the upper-left corner, the third sets th…
`:)`
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 21, 2022, 7:23pm UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/17 "2022-06-21T19:23:07Z")
Ok, I think I got the rectX right with:
```auto
rect((count-1)*(i-count),height-income,5,income);
```
Now still struggling with the ‘w’… had to use a fixed one (5) temporarily for visibility.
This below doesn’t work as count increases therefore ‘w’ decreases. I need to pick the maximum value of ‘count’, which is 13, and divide width by it, am I right? 🤔
I tried max(count) but that’d mean turning count into an array and doesn’t take me anywhere.
```auto
float w = width/count;
```
Also tried this with no luck.
```auto
IntList count_values = new IntList();
count_values.append(count);
int max_count = count_values.max();
//draw rectangles whose height equals income
float w = width/max_count;
```
---
### Author:  [@glv](https://discourse.processing.org/u/glv)
#### Post date: [June 22, 2022, 12:53am UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/18 "2022-06-22T00:53:35Z")
Hello,
This is a simple example of a bar graph:
```auto
size(600, 200);
int max = 70; // Try different values
for(int i = 0; i< max; i++)
{
int x = i;
int y = 0;
float w = float(width)/max; // I need floating point math here. Try with the float!
float h = random(50, 170); // Random elements... this could have been from array or table
stroke(0);
rect(x*w, y, w, h);
}
```
Take a look at the syntax and parameters in the reference:
> **[Reference](https://processing.org/reference/rect_.html)**
>
> Draws a rectangle to the screen. A rectangle is a four-sided shape with every angle at ninety degrees. By default, the first two parameters set the location of the upper-left corner, the third sets th…
Explore (play with different values) and understand this first and then integrate your version into your code.
`:)`
---
### Author:  [@Erif](https://discourse.processing.org/u/Erif)
#### Post date: [June 22, 2022, 9:56am UTC](https://discourse.processing.org/t/table-findrows-multiple-criteria/37595/19 "2022-06-22T09:56:39Z")
Thanks, yes, I understand the example provided, and in my case x,y and h variables are perfectly clear. The problem is the denominator of ‘w’ → max.
```auto
float w = float(width)/max //in the example it's a hardcoded number (70)
```
If I use max = 13, I get a perfectly valid result 🕶
What I’m trying is to not have to use a hardcoded value, but ‘max’ being the maximum value of my counter, as per below, so if I use another filter on the table and the max of counter is 7 don’t have to modify the code.
Does it make sense?
