从具有列名和行名的文件中读取矩阵

import pandas as pd

# 读取CSV文件
df = pd.read_csv('filename.csv')

# 将DataFrame转换为矩阵
matrix = df.values

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.IOException;

public class ReadExcel {
    public static void main(String[] args) {
        try {
            // 读取Excel文件
            FileInputStream file = new FileInputStream("filename.xlsx");
            Workbook workbook = new XSSFWorkbook(file);

            // 读取第一个工作表
            Sheet sheet = workbook.getSheetAt(0);

            // 获取行数和列数
            int rowCount = sheet.getPhysicalNumberOfRows();
            int colCount = sheet.getRow(0).getPhysicalNumberOfCells();

            // 创建矩阵
            double[][] matrix = new double[rowCount - 1][colCount - 1];

            // 读取数据
            for (int i = 1; i < rowCount; i++) {
                Row row = sheet.getRow(i);
                for (int j = 1; j < colCount; j++) {
                    Cell cell = row.getCell(j);
                    matrix[i - 1][j - 1] = cell.getNumericCellValue();
                }
            }

            // 关闭文件
            file.close();

            // 打印矩阵
            for (int i = 0; i < rowCount - 1; i++) {
                for (int j = 0; j < colCount - 1; j++) {
                    System.out.print(matrix[i][j] + " ");
                }
                System.out.println();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}