擅长:python、mysql、java
<p>确实有一种更简单的方法-<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html" rel="nofollow noreferrer">merge</a>将数据帧放在一个文件中。基本上是这样的:</p>
<pre><code>df1 = pd.read_csv("CSV-1.csv")
df2 = pd.read_csv("CSV-2.csv")
df3 = df1.merge(df2, on="filename", how="left")
df3.fillna(0, inplace=True)
# df3 would contain the following dataframe
###########
# filename number_of_changes_x number_of_changes_y
# 0 A 20 20.0
# 1 B 10 15.0
# 2 C 10 0.0
# 3 E 5 10.0
# 4 F 15 0.0
</code></pre>
<p>基本上将两个数据帧合并为一个,并用0填充np.NaN值。根据需要,可能需要将第二列转换为int。如果需要更改列名,请使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.rename.html" rel="nofollow noreferrer">rename</a>方法</p>