擅长:python、mysql、java
<p>这是一个完美的SQL用例。如果您想在Python中实现类似SQL的函数,使用<a href="https://pandas.pydata.org/pandas-docs/stable/index.html" rel="nofollow noreferrer">pandas</a>通常是一个好主意。它方便、易读、易写、快捷。对于您的情况,假设附加值将存储在元组列表或字典中:</p>
<pre><code>import pandas as pd
csv = [
(1, 10),
(2, 20),
(3, 30),
]
csv_df = pd.DataFrame(csv, columns=["id", "reference"])
# This would be the data you have in your csv. For actually loading them from your
# csv located at `filepath`, use
#
# pd.DataFrame.read_csv(filepath)
additional_data = [
(1, "a"),
(2, "b"),
(3, "c"),
] # This could also be a dictionary
additional_df = pd.DataFrame(additional_data, columns=["id", "name"])
final_df = csv_df.merge(additional_df, on="id")
</code></pre>
<p>然后我们得到</p>
<pre><code>>>> final_df
id reference name
0 1 10 a
1 2 20 b
2 3 30 c
</code></pre>