擅长:python、mysql、java
<p>我的建议是不要使用变量名作为数据的“键”,而是在元组或dict中为它们指定专有名称</p>
<p>因此,不是:</p>
<pre><code>warehouse = pd.read_excel('warehouse.xls')
retail = pd.read_excel('retailonhand.xls')
shed3 = pd.read_excel('shed3onhand.xls')
</code></pre>
<p>你应该:</p>
<pre><code>sites = {}
sites['warehouse'] = pd.read_excel('warehouse.xls')
sites['retail'] = pd.read_excel('retailonhand.xls')
sites['shed3'] = pd.read_excel('shed3onhand.xls')
...etc
</code></pre>
<p>然后您可以创建负关键点,如下所示:</p>
<pre><code>sites_neg = {}
for site_name, site in sites.items():
neg_key = site_name + '_neg'
sites_neg[neg_key] = site[site.OnHand < 0]
</code></pre>