擅长:python、mysql、java
<p>可以使用<a href="https://docs.scipy.org/doc/numpy/reference/generated/numpy.select.html" rel="nofollow noreferrer">^{<cd1>}</a>和for get columns names <code>format</code>:</p>
<pre><code>for i in range (1980,2015,5):
m1 = df["DWWC{}".format(i)] <=18.25
#inverted m1 mask by ~
m2 = ~m1 & (df["DWWC{}".format(i)] <= 36.5)
a = (((10-33)/(5))*(df["DWWC{}".format(i)]-5))+10
b = ((10/(df.two-df.three))*(df["DWWC{}".format(i)]-df.three))+df.Three
c = (((df.Three_value-6)/(df.three-5))*(df["DWWC{}".format(i)]-6
df["MWTP{}".format(i)] = np.select([m1,m2],[a,b], default=c)
</code></pre>