擅长:python、mysql、java
<p>你不必加入。这里有一种方法。在</p>
<pre><code>import pandas as pd
z = {'city1' : pd.Series(['YYZ', 'YYZ','YYZ','YYZ']), 'city2' : pd.Series(['SFO', 'EWR', 'DFW', 'LAX'])}
df = pd.DataFrame(z)
x = {'city1' : pd.Series(['YYZ', 'YYX','YYZ','YYX']), 'city2' : pd.Series(['SFO', 'EWR', 'DFW', 'LAX'])}
df1 = pd.DataFrame(x)
df.head()
city1 city2
0 YYZ SFO
1 YYZ EWR
2 YYZ DFW
3 YYZ LAX
df1.head()
city1 city2
0 YYZ SFO
1 YYX EWR
2 YYZ DFW
3 YYX LAX
condition = df['city1'] == df1['city1']
df[(condition)]
city1 city2
0 YYZ SFO
2 YYZ DFW
</code></pre>