擅长:python、mysql、java
<p>我已经找到了解决我问题的办法。我将用两个不同的过滤器过滤这些行</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
df = pd.read_excel('Bauteilliste.xlsx')
pd.set_option('display.max_columns', 75)
# Filter settings
filt_with_isolation = (df['KZ'] == 'R-R') & (df['D'] == 160) & (df['IsoOf'].isna() == False)
filt_without_isolation = (df['KZ'] == 'R-R') & (df['D'] == 160) & (df['IsoOf'].isna() == True)
# counting the meters
counter_with_isolation = 0
counter_without_isolation = 0
# for-Slice, get Elements with isolation
for row in df.loc[filt_with_isolation, 'L']:
counter_with_isolation = counter_with_isolation + row
for row in df.loc[filt_without_isolation, 'L']:
counter_without_isolation = counter_without_isolation + row
print(counter_with_isolation)
print(counter_without_isolation)
Output:
6030.0
41050.0
</code></pre>