擅长:python、mysql、java
<pre><code>import pandas as pd
death = pd.DataFrame({'County': ['county1', 'county2', 'county3'], 'Deaths': [1,2,3]})
County Deaths
0 county1 1
1 county2 2
2 county3 3
air = pd.DataFrame({'County': ['county2', 'county3', 'county4'], 'AQI': [21,32,43]})
County AQI
0 county2 21
1 county3 32
2 county4 43
merged = pd.merge(death, air)
County Deaths AQI
0 county2 2 21
1 county3 3 32
</code></pre>