擅长:python、mysql、java
<p>您可以使用pandas加入新值:</p>
<pre><code>import pandas as pd
df1 = pd.read_csv("<path to csv1>.csv")
df2 = pd.read_csv("<path to csv2>.csv").rename(columns={"Switch": "new_switch", "Port": "new_port"})
# clean up column names
df1.columns = [i.strip() for i in df1.columns]
df2.columns = [i.strip() for i in df2.columns]
# join in new values
result = df1.join(df2.set_index("Mac"), on="Mac")
# use the new values where they're defined, otherwise fill in with the old values
result["Switch"] = result["new_switch"].fillna(result["Switch"])
result["Port"] = result["new_port"].fillna(result["Port"])
# delete the "new" columns, which are no longer needed
del result["new_switch"], result["new_port"]
# write out
result.to_csv("<path to new csv>.csv", index=False)
</code></pre>
<p>这假设您的csv2对于每个<code>Mac</code>值只有一行。你知道吗</p>