如何在java中的同一个csv文件的2列之间进行筛选？

Question

你好，我有一个java类，它统计csv文件中的所有行。但是现在我需要创建一个过滤器，这样它只计算一定数量的行，这取决于过滤器中的条件。

像这样的东西：

COUNTROWS(FILTER(Customer_Data, Customer_Data[Age]>=18
&& Customer_Data[IsActiveMember]=1))

我现在正在学习java，这是相当困难的。

我现在的代码是：

import java.io.File;
import java.io.IOException;

public class CountRows {

    public static void countorows() throws IOException {
        var Query ="COUNTROWS(FILTER(Customer_Data, Customer_Data[Age]>=18\r\n"
                + "&& Customer_Data[IsActiveMember]=1))";
      
        ReadFile file = new ReadFile(new File("file location"));
        var teste = file.getcustomers();
        System.out.println(teste.size());
    }
}

csv文件（它有10.000行，如下所示）：`

RowNumber,CustomerId,Surname,CreditScore,Geography,Gender,Age,Tenure,Balance,NumOfProducts,HasCrCard,IsActiveMember,EstimatedSalary,Exited
1,15634602,Hargrave,619,France,Female,42,2,0,1,1,1,101348.88,1
2,15647311,Hill,608,Spain,Female,41,1,83807.86,1,0,1,112542.58,0
3,15619304,Onio,502,France,Female,42,8,159660.8,3,1,0,113931.57,1
3,15619304,Onio,502,France,Female,42,8,159660.8,3,1,0,113931.57,2
3,15619304,Onio,502,France,Female,42,8,159660.8,3,1,0,113931.57,3
3,15619304,Onio,502,France,Female,42,8,159660.8,3,1,0,113931.57,4
3,15619304,Onio,502,France,Female,42,8,159660.8,3,1,0,113931.57,5
3,15619304,Onio,502,France,Female,42,8,159660.8,3,1,0,113931.57,6

Answer 1

我知道读取文件的方式是：

null

也许你需要做点什么：

public class CountRows {

    public static void countorows() throws IOException {
    
        try {
            int counter = 0;
            BufferedReader b = new BufferedReader(new inputFile);
            String readLine = "";
            while ((readLine = b.readLine()) != null) {
                String sNewLine = new String(sLinea_nueva.getBytes("ISO-8859-1"), "UTF-8");
                String[] sLinea = sNewLine.split(",");
                String sName = sLinea[0];
                String sAge = sLinea[1];
                if (Integer.value(sAge) >= 18) {
                    counter = counter + 1;
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}