求指导！请问怎么把excel中的数据按species导入python呢？

请问怎么把excel中的数据按species导入python呢？

A B
width species

1.5 versicolor
0.3 setosa
1.6 versicolor
2.3 virginica
2.3 virginica
2.1 virginica
2 virginica
2.5 virginica

s = """1.5 versicolor
0.3 setosa
1.6 versicolor
2.3 virginica
2.3 virginica
2.1 virginica
2 virginica
2.5 virginica"""
temp = {}
for line in s.split('\n'):
    f, w = line.split(' ')
    temp[w] = temp.get(w, [])
    temp[w].append(f)
print(temp)