回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个字典,我想转换成一个数据帧。问题是列和行都在我的字典的值部分。如何将<code>dict.values</code>转换为数据帧</p>
<p>例如:
<code>test = {TableName('Extract','Extract): myDesiredDf}</code></p>
<p>以下是数据集:</p>
<pre><code>{TableName('Extract', 'Extract'): depot_name market submarket realized_date \
0 <NA> Boston Boston 2020-09-18
1 <NA> Bay Area Bay Area 2020-09-07
2 <NA> Minneapolis Minneapolis 2020-08-27
3 <NA> Washington, DC Washington, DC 2020-09-10
4 <NA> New York New York 2020-09-07
... ... ... ... ...
79069 Unknown Location Washington, DC Washington, DC 2020-09-14
79070 Unknown Location Washington, DC Washington, DC 2020-09-15
79071 Unknown Location Washington, DC Washington, DC 2020-09-16
79072 Unknown Location Washington, DC Washington, DC 2020-09-22
79073 Unknown Location Washington, DC Washington, DC 2020-09-25
category subcategory actual denom nume
0 Headcount Clocked-In 11.0 NaN NaN
1 Headcount Clocked-In 40.0 NaN NaN
2 Headcount Clocked-In 8.0 NaN NaN
3 Headcount Clocked-In 25.0 NaN NaN
4 Headcount Unknown 85.0 NaN NaN
... ... ... ... ... ...
79069 Repairs: Unknown Location eBike 18.0 NaN NaN
79070 Repairs: Unknown Location eBike 35.0 NaN NaN
79071 Repairs: Unknown Location eBike 14.0 NaN NaN
79072 Repairs: Unknown Location eBike 3.0 NaN NaN
79073 Repairs: Unknown Location eBike 2.0 NaN NaN
[79074 rows x 9 columns]}
</code></pre>
<p>我所尝试的:</p>
<pre><code>pd.Dataframe(test)
ValueError: If using all scalar values, you must pass an index
pd.DataFrame(test.values())
ValueError: Must pass 2-d input. shape=(1, 79074, 9)
pd.DataFrame(test,index=[0])
ValueError: Shape of passed values is (9, 1), indices imply (1, 1)
</code></pre>
<p>我期望的结果是:
我希望test.values()/myDesiredDf是一个数据帧</p>