设置1列中除给定行以外的所有内容的子集

import pandas as pd

# 加载数据集
data = pd.read_csv('data.csv')

# 设置给定行的索引
given_row_index = 2

# 筛选出除给定行以外的所有内容的子集
subset = data.loc[data.index != given_row_index]

# 将筛选得到的子集保存到新的CSV文件
subset.to_csv('subset.csv', index=False)

import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVParser;
import org.apache.commons.csv.CSVPrinter;
import org.apache.commons.csv.CSVRecord;

public class SubsetExample {
    public static void main(String[] args) {
        String inputFile = "data.csv";
        String outputFile = "subset.csv";
        int givenRowIndex = 2;

        try (FileReader reader = new FileReader(inputFile);
             FileWriter writer = new FileWriter(outputFile);
             CSVParser csvParser = CSVFormat.DEFAULT.parse(reader);
             CSVPrinter csvPrinter = new CSVPrinter(writer, CSVFormat.DEFAULT)) {

            for (CSVRecord record : csvParser) {
                if (record.getRecordNumber() != givenRowIndex + 1) {
                    csvPrinter.printRecord(record);
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}