我将如何放置 Excel 工作表的多个最大值和最小值

这是一种方法。出于测试目的，我将以下数据放入 CSV 文件中：

Cycle,Voltage
1,0.30
1,0.05
1,-0.25
13,0.03
13,0.005
13,-0.025
2,0.35
2,0.07
2,-0.23

代码如下：

from itertools import groupby
import csv
from operator import itemgetter
from typing import NamedTuple


class Record(NamedTuplE):
    """ Define the fields and their types of a record. """
    Cycle: int
    Voltage: float

    @classmethod
    def transform(cls: 'Record',Dict_: Dict) -> tuple:
        """ Convert String values in given Dictionary to corresponding Record
            class field type."""
        return tuple(cls.__Annotations__[name](value) for name,value in Dict_.items())


filepath = 'voltages.csv'

with open(filepath,newline='') as file:
    reader = csv.DictReader(filE)
    data = sorted(map(Record.transform,reader))

groups = {}
for k,g in groupby(data,key=itemgetter(0)):
    voltages = tuple(map(itemgetter(1),g))
    groups[k] = (min(voltages),max(voltages))

print(groups)  # -> {1: (-0.25,0.3),2: (-0.23,0.35),13: (-0.025,0.03)}