擅长:python、mysql、java
<p>您可以使用<code>np.select</code>:</p>
<pre><code>conditions = [(df["A"].str[:4].isin(["INKA", "IDKA"]))|(df["B"].str[:4].isin(["INKA", "IDKA"])),
(df["A"].str[:4].isin(["INAP", "IDAP"]))|(df["B"].str[:4].isin(["INAP", "IDAP"])),
(df["A"].str[:4].isin(["INRJ", "IDRJ"]))|(df["B"].str[:4].isin(["INRJ", "IDRJ"]))]
df["C"] = np.select(conditions, ["KAR", "AP", "RAJ"], None)
</code></pre>
<p>或者,您可以使用<code>map</code>和<code>combine_first</code>:</p>
<pre><code>mapper = {"INKA": "KAR", "IDKA": "KAR", "INAP": "AP", "IDAP": "AP", "INRJ": "RAJ", "IDRJ": "RAJ"
df["C"] = df["A"].str[:4].map(mapper).combine_first(df["B"].str[:4].map(mapper))
</code></pre>