擅长:python、mysql、java
<p>假设您可以读取<code>CSV</code>文件,您可以从以下位置使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html" rel="nofollow noreferrer">merge</a>方法:</p>
<pre><code>ratings.merge(tvshows, on = 'tvID')
</code></pre>
<p>以下是一个随机玩具示例:</p>
<pre><code>import pandas as pd
#generating test data
tvshows = pd.DataFrame({'tvName':['Ab','Bc','Cd','De','Ef'],'tvID':['A','B','C','D','E']})
ratings = pd.DataFrame({'userID':[1,2,3,4,5],'userRating':[5,5,3,5,5],'tvID':['A','B','C','D','E']})
#merging the dataframes
out = ratings.merge(tvshows, on = 'tvID')
print(out)
</code></pre>
<p>输出:</p>
<pre><code> userID userRating tvID tvName
0 1 5 A Ab
1 2 5 B Bc
2 3 3 C Cd
3 4 5 D De
4 5 5 E Ef
</code></pre>