擅长:python、mysql、java
<h3>设置</h3>
<pre><code>df = pd.DataFrame({'E001': [1, 2, 3]})
df
E001
0 1
1 2
2 3
</code></pre>
<hr/>
<h3>创建不在<code>df</code></h3>中的列的字典
<pre><code>codes = ['E001', 'E002', 'E003', 'E004']
df.assign(**dict.fromkeys({*codes} - {*df}, 0))
E001 E002 E004 E003
0 1 0 0 0
1 2 0 0 0
2 3 0 0 0
</code></pre>
<hr/>
<h3>结合新构造的数据帧</h3>
<pre><code>codes = ['E001', 'E002', 'E003', 'E004']
df.combine_first(pd.DataFrame(0, df.index, codes))
E001 E002 E004 E003
0 1 0 0 0
1 2 0 0 0
2 3 0 0 0
</code></pre>