爬取数据 列表比较大小

Question

将爬取下来的数据，第二例，取最小的三个数，第三列取最大的三个数（0和负数不取）第一列的列名也要对应上

Answer 1

data = [
    ["dell", "34%", "17%"],
    ["hpe", "19%", "19%"],
    ["ms", "33%", "22%"],
    ["amazon", "13%", "13%"],
    ["nv", "26%", "32%"],
    ["oracle", "66%", "66%"],
    ["ali", "32%", "23%"],
    ...
]

# 将第二列数据转换为浮点数，并按降序排序，获取前三项
top_second_col = sorted([(float(row[1].rstrip("%")), row[0]) for row in data], reverse=True)[:3]
print("Top 3 companies by second column:")
for value, company in top_second_col:
    print(f"{company}: {value}%")

# 将第三列数据转换为浮点数，并按升序排序，获取前三项
top_third_col = sorted([(float(row[2].rstrip("%")), row[0]) for row in data])[:3]
print("\nTop 3 companies by third column:")
for value, company in top_third_col:
    print(f"{company}: {value}%")