使用if条件删除特定的列/行值

import pandas as pd

# 读取数据集
data = pd.read_csv('data.csv')

# 删除特定列值
if_condition = data['column_name'] == specific_value
data = data.loc[:, ~if_condition]

# 删除特定行值
if_condition = (data['column_name'] == specific_value) & (data['other_column'] > 10)
data = data.loc[~if_condition, :]

# 输出结果
print(data)

import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVParser;
import org.apache.commons.csv.CSVPrinter;
import org.apache.commons.csv.CSVRecord;

import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;

public class CSVExample {
    public static void main(String[] args) throws IOException {
        // 读取数据集
        CSVParser parser = new CSVParser(new FileReader("data.csv"), CSVFormat.DEFAULT.withHeader());

        // 创建输出文件
        CSVPrinter printer = new CSVPrinter(new FileWriter("output.csv"), CSVFormat.DEFAULT);

        // 删除特定列值
        for (CSVRecord record : parser) {
            if (!record.get("column_name").equals("specific_value")) {
                printer.printRecord(record);
            }
        }

        // 关闭文件
        printer.close();
        parser.close();
    }
}