从字典的元素创建DataFrame

Question

下面，我有一个名为'date_dict'的字典。我想创建一个DataFrame，它接受这个字典的每个键，并让它出现在DataFrame的n行中，n是值。例如，日期'20220107'将出现在75910行中。这可能吗?

{'20220107': 75910,
'20220311': 145012,
'20220318': 214286,
'20220325': 283253,
'20220401': 351874,
'20220408': 419064,
'20220415': 486172,
'20220422': 553377,
'20220429': 620635,
'20220506': 684662,
'20220513': 748368,
'20220114': 823454,
'20220520': 886719,
'20220527': 949469,
'20220121': 1023598,
'20220128': 1096144,
'20220204': 1167590,
'20220211': 1238648,
'20220218': 1310080,
'20220225': 1380681,
'20220304': 1450031}

Answer 1

也许这能帮上忙。

import pandas as pd
myDict = {'20220107': 3, '20220311': 4, '20220318': 5 }
wrkList = []
for k, v in myDict.items():
for i in range(v):
rowList = []
rowList.append(k)
wrkList.append(rowList)
df = pd.DataFrame(wrkList)
print(df)
'''
R e s u l t
0
0   20220107
1   20220107
2   20220107
3   20220311
4   20220311
5   20220311
6   20220311
7   20220318
8   20220318
9   20220318
10  20220318
11  20220318
'''