擅长:python、mysql、java
<p>我将使用<code>pivot</code>函数并将数据透视帧作为字典返回。我们需要从字典中删除具有空值的键,并进行迭代以统一字典。你知道吗</p>
<pre><code>df_pivot = pd.pivot_table(df, columns=['s','t'], index='Biomasse', values='KWS')
lst= [{k: v for k, v in dct.items() if not math.isnan(v)} for dct in df_pivot.to_dict(orient='row')]
Ang = {}
for el in lst:
Ang.update({("Biomasse", key[0],key[1]):value for key, value in el.items()})
</code></pre>
<p>结果</p>
<pre><code>{('Biomasse', 'AT2', 2025.0): 2323.0,
('Biomasse', 'AT1', 2025.5): 2939.0,
('Biomasse', 'AT1', 2025.0): 2323.0,
('Biomasse', 'AT1', 2025.25): 990.0}
</code></pre>