我有一个名为tableTest的表，如下所示:
| startDate | endDate | 2022-12-15 | 2022-12-18 |
|---|---|
| 2022-12-19 | 2022-12-21 |
| 2022-12-22 | 2022-12-24 |
| 2022-12-26 | 2022-12-27 |
| 2022-12-29 | 2022-12-30 |
| 2022-12-02 | 2022-12-04 |
| 2022-12-06 | 2022-12-07 |
| 2022-12-07 | 2022-12-08 |
| 2022-12-09 | 2022-12-09 |
| 2022-12-13 | 2022-12-14 |
可以使用.to_dict的into参数传入OrderedDict:
from collections import OrderedDict
dictTest = df.set_index('startDate')['endDate'].to_dict(into=OrderedDict)
查看这里的文档。
只要tableTest是一个数据框架，就可以直接使用iterrows按原顺序进行迭代。
for index, row in tableTest.iterrows():
startDate = row['startDate']
endDate = row['endDate']
print(f'startDate is {startDate} and corresponding endDate is {endDate}.')