通过字典迭代并创建Excel文件
我有一个名为 mth_prod的字典，看起来像这样：
{'2006-01-01 00:00:00': [ date product price Date
EEX French-Baseload-Month-Future
2006-01-02 2006-01-01 00:00:00 80 2
2006-01-03 2006-01-01 00:00:00 80 3
2006-01-04 2006-01-01 00:00:00 80 4
2006-01-05 2006-01-01 00:00:00 80 5
2006-01-06 2006-01-01 00:00:00 80 6
2006-01-09 2006-01-01 00:00:00 80 9
2006-01-10 2006-01-01 00:00:00 80 10
2006-01-11 2006-01-01 00:00:00 80 11
2006-01-12 2006-01-01 00:00:00 80 12
2006-01-13 2006-01-01 00:00:00 80 13
2006-01-16 2006-01-01 00:00:00 80 16
2006-01-17 2006-01-01 00:00:00 80 17
2006-01-18 2006-01-01 00:00:00 80 18
2006-01-19 2006-01-01 00:00:00 80 19
2006-01-20 2006-01-01 00:00:00 80 20
2006-01-23 2006-01-01 00:00:00 80 23
2006-01-24 2006-01-01 00:00:00 80 24
2006-01-25 2006-01-01 00:00:00 80 25
2006-01-26 2006-01-01 00:00:00 80 26
2006-01-27 2006-01-01 00:00:00 80 27],
'2006-02-01 00:00:00': [ date product price Date
EEX French-Baseload-Month-Future
2006-01-02 2006-02-01 00:00:00 77 2
2006-01-03 2006-02-01 00:00:00 74 3
2006-01-04 2006-02-01 00:00:00 76 4
2006-01-05 2006-02-01 00:00:00 76 5
2006-01-06 2006-02-01 00:00:00 78 6
2006-01-09 2006-02-01 00:00:00 72 9
2006-01-10 2006-02-01 00:00:00 72 10
2006-01-11 2006-02-01 00:00:00 73 11
2006-01-12 2006-02-01 00:00:00 70 12
2006-01-13 2006-02-01 00:00:00 68 13
2006-01-16 2006-02-01 00:00:00 66 16
2006-01-17 2006-02-01 00:00:00 74 17
2006-01-18 2006-02-01 00:00:00 82 18
2006-01-19 2006-02-01 00:00:00 80 19
2006-01-20 2006-02-01 00:00:00 86 20
2006-01-23 2006-02-01 00:00:00 79 23
2006-01-24 2006-02-01 00:00:00 71 24
2006-01-25 2006-02-01 00:00:00 73 25
2006-01-26 2006-02-01 00:00:00 76 26
2006-01-27 2006-02-01 00:00:00 72 27
2006-01-30 2006-02-01 00:00:00 78 30
2006-01-31 2006-02-01 00:00:00 78 31
2006-02-01 2006-02-01 00:00:00 78 32
2006-02-02 2006-02-01 00:00:00 78 33
2006-02-03 2006-02-01 00:00:00 78 34
2006-02-06 2006-02-01 00:00:00 78 37
2006-02-07 2006-02-01 00:00:00 78 38
2006-02-08 2006-02-01 00:00:00 78 39
2006-02-09 2006-02-01 00:00:00 78 40
2006-02-10 2006-02-01 00:00:00 78 41
2006-02-13 2006-02-01 00:00:00 78 44
2006-02-14 2006-02-01 00:00:00 78 45
2006-02-15 2006-02-01 00:00:00 78 46
2006-02-16 2006-02-01 00:00:00 78 47
2006-02-17 2006-02-01 00:00:00 78 48
2006-02-20 2006-02-01 00:00:00 78 51
2006-02-21 2006-02-01 00:00:00 78 52
2006-02-22 2006-02-01 00:00:00 78 53
2006-02-23 2006-02-01 00:00:00 78 54
2006-02-24 2006-02-01 00:00:00 78 55],...}
每个键/值对是一个带有列名称eex french french-baseload-month-future的数据框架，date date产品，Price，分别。我想迭代字典，并将每个数据帧导出为 xlsx 在Speciifc文件夹中。用文件名称相应的dict键。
结果文件夹应该看起来像这样。
\my_foder\
2006-01-01 00:00:00.xlsx
2006-02-01 00:00:00.xlsx
.
.
.
提前致谢！
I have a dictionary named mth_prod that looks like this:
{'2006-01-01 00:00:00': [ date product price Date
EEX French-Baseload-Month-Future
2006-01-02 2006-01-01 00:00:00 80 2
2006-01-03 2006-01-01 00:00:00 80 3
2006-01-04 2006-01-01 00:00:00 80 4
2006-01-05 2006-01-01 00:00:00 80 5
2006-01-06 2006-01-01 00:00:00 80 6
2006-01-09 2006-01-01 00:00:00 80 9
2006-01-10 2006-01-01 00:00:00 80 10
2006-01-11 2006-01-01 00:00:00 80 11
2006-01-12 2006-01-01 00:00:00 80 12
2006-01-13 2006-01-01 00:00:00 80 13
2006-01-16 2006-01-01 00:00:00 80 16
2006-01-17 2006-01-01 00:00:00 80 17
2006-01-18 2006-01-01 00:00:00 80 18
2006-01-19 2006-01-01 00:00:00 80 19
2006-01-20 2006-01-01 00:00:00 80 20
2006-01-23 2006-01-01 00:00:00 80 23
2006-01-24 2006-01-01 00:00:00 80 24
2006-01-25 2006-01-01 00:00:00 80 25
2006-01-26 2006-01-01 00:00:00 80 26
2006-01-27 2006-01-01 00:00:00 80 27],
'2006-02-01 00:00:00': [ date product price Date
EEX French-Baseload-Month-Future
2006-01-02 2006-02-01 00:00:00 77 2
2006-01-03 2006-02-01 00:00:00 74 3
2006-01-04 2006-02-01 00:00:00 76 4
2006-01-05 2006-02-01 00:00:00 76 5
2006-01-06 2006-02-01 00:00:00 78 6
2006-01-09 2006-02-01 00:00:00 72 9
2006-01-10 2006-02-01 00:00:00 72 10
2006-01-11 2006-02-01 00:00:00 73 11
2006-01-12 2006-02-01 00:00:00 70 12
2006-01-13 2006-02-01 00:00:00 68 13
2006-01-16 2006-02-01 00:00:00 66 16
2006-01-17 2006-02-01 00:00:00 74 17
2006-01-18 2006-02-01 00:00:00 82 18
2006-01-19 2006-02-01 00:00:00 80 19
2006-01-20 2006-02-01 00:00:00 86 20
2006-01-23 2006-02-01 00:00:00 79 23
2006-01-24 2006-02-01 00:00:00 71 24
2006-01-25 2006-02-01 00:00:00 73 25
2006-01-26 2006-02-01 00:00:00 76 26
2006-01-27 2006-02-01 00:00:00 72 27
2006-01-30 2006-02-01 00:00:00 78 30
2006-01-31 2006-02-01 00:00:00 78 31
2006-02-01 2006-02-01 00:00:00 78 32
2006-02-02 2006-02-01 00:00:00 78 33
2006-02-03 2006-02-01 00:00:00 78 34
2006-02-06 2006-02-01 00:00:00 78 37
2006-02-07 2006-02-01 00:00:00 78 38
2006-02-08 2006-02-01 00:00:00 78 39
2006-02-09 2006-02-01 00:00:00 78 40
2006-02-10 2006-02-01 00:00:00 78 41
2006-02-13 2006-02-01 00:00:00 78 44
2006-02-14 2006-02-01 00:00:00 78 45
2006-02-15 2006-02-01 00:00:00 78 46
2006-02-16 2006-02-01 00:00:00 78 47
2006-02-17 2006-02-01 00:00:00 78 48
2006-02-20 2006-02-01 00:00:00 78 51
2006-02-21 2006-02-01 00:00:00 78 52
2006-02-22 2006-02-01 00:00:00 78 53
2006-02-23 2006-02-01 00:00:00 78 54
2006-02-24 2006-02-01 00:00:00 78 55],...}
Each key/value pairs is a dataframe with columns name EEX French-Baseload-Month-Future, date product, price, Date respectively. I would like to iterate over the dictionary and export each data frame as xlsx in a speciifc folder. With file name the corresponding dict key.
The result folder should look like this.
\my_foder\
2006-01-01 00:00:00.xlsx
2006-02-01 00:00:00.xlsx
.
.
.
Thanks in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论