<p>第一个concat具有<code>LOWI_Precipitation_24_Hour_</code>和
concat具有<code>TGPY_Precipitation_24_Hour_(mm)</code>的所有df,然后使用merge</p>
<pre><code>df1 = pd.DataFrame({'GMT_date': ["01-01-2000", "02-01-2000", "03-01-2000", "04-01-2000", "05-01-2000"],
'LOWI_Precipitation_24_Hour_(mm)': [2.2, 0, 0.2, 0.4, 0]})
df2 = pd.DataFrame({'GMT_date': ["06-01-2000", "07-01-2000", "08-01-2000", "09-01-2000", "10-01-2000"],
'LOWI_Precipitation_24_Hour_(mm)': [0.1, 0.1, 3.1, 4.0, 0]})
df3 = pd.DataFrame({'GMT_date': ["06-01-2000", "07-01-2000", "08-01-2000", "09-01-2000", "10-01-2000"],
'TGPY_Precipitation_24_Hour_(mm)': [0.6, 0.7, 5.1, 1.0, 2.0]})
# merge_df = pd.DataFrame()
new_df = pd.concat([df1, df2])
print(new_df)
merge_df = pd.merge(new_df, df3, how='left')
print(merge_df)
</code></pre>
<p><strong>输出:</strong></p>
^{pr2}$
<hr/>
<p>例如你有这种测向仪</p>
<pre><code>df1 = pd.DataFrame({'GMT_date': ["01-01-2000", "02-01-2000", "03-01-2000", "04-01-2000", "05-01-2000"],
'LOWI_Precipitation_24_Hour_(mm)': [2.2, 0, 0.2, 0.4, 0]})
df2 = pd.DataFrame({'GMT_date': ["06-01-2000", "07-01-2000", "08-01-2000", "09-01-2000", "10-01-2000"],
'LOWI_Precipitation_24_Hour_(mm)': [0.1, 0.1, 3.1, 4.0, 0]})
df3 = pd.DataFrame({'GMT_date': ["06-01-2000", "07-01-2000", "08-01-2000", "09-01-2000", "10-01-2000"],
'TGPY_Precipitation_24_Hour_(mm)': [0.6, 0.7, 5.1, 1.0, 2.0]})
df4 = pd.DataFrame({'GMT_date': ["01-01-2000", "02-01-2000", "03-01-2000", "04-01-2000", "05-01-2000"],
'TGPY_Precipitation_24_Hour_(mm)': [0.6, 0.7, 5.1, 1.0, 2.0]})
# merge_df = pd.DataFrame()
# df1.set_index('GMT_date')
new_df = pd.concat([df1, df2])
new_df2 = pd.concat([df3, df4])
print(new_df)
merge_df = pd.merge(new_df, new_df2, how='left')
print(merge_df)
</code></pre>
<p><strong>输出:</strong></p>
<pre><code> GMT_date LOWI_Precipitation_24_Hour_(mm) TGPY_Precipitation_24_Hour_(mm)
0 01-01-2000 2.2 0.6
1 02-01-2000 0.0 0.7
2 03-01-2000 0.2 5.1
3 04-01-2000 0.4 1.0
4 05-01-2000 0.0 2.0
5 06-01-2000 0.1 0.6
6 07-01-2000 0.1 0.7
7 08-01-2000 3.1 5.1
8 09-01-2000 4.0 1.0
9 10-01-2000 0.0 2.0
</code></pre>