作者:可燕戏天 | 来源:互联网 | 2022-12-06 13:33
我在熊猫中有2个以下数据框:
电影
+---+------------------------------+--------------+-----------+
| | movie title | genre | tconst |
+---+------------------------------+--------------+-----------+
| 0 | Edison Kinetoscopic Record | Documentary | tt0000008 |
+---+------------------------------+--------------+-----------+
| 1 | La sortie des usines Lumière | Documentary | tt0000010 |
+---+------------------------------+--------------+-----------+
| 2 | The Arrival of a Train | Documentary | tt0000012 |
+---+------------------------------+--------------+-----------+
| 3 | The Oxford and Cambridge | NaN | tt0000025 |
+---+------------------------------+--------------+-----------+
| 4 | Le manoir du diable | Short|Horror | tt0000091 |
+---+------------------------------+--------------+-----------+
和船员
+---+-----------+-----------+---------+------+
| | tconst | directors | writers | year |
+---+-----------+-----------+---------+------+
| 0 | tt0000001 | nm0005690 | \N | 2001 |
+---+-----------+-----------+---------+------+
| 1 | tt0000002 | nm0721526 | \N | 2002 |
+---+-----------+-----------+---------+------+
| 2 | tt0000003 | nm0721526 | \N | 2003 |
+---+-----------+-----------+---------+------+
| 3 | tt0000004 | nm0721526 | \N | 2004 |
+---+-----------+-----------+---------+------+
| 4 | tt0000005 | nm0005690 | \N | 2005 |
+---+-----------+-----------+---------+------+
如何创建一个新的数据框,我将导演和年份列仅加入电影数据框(使用tconst列)?
1> AsheKetchum..:
尝试:
pd.merge(movies, crew[["tconst", "directors", "year"]], on="tconst", how="left")
该on
参数告诉函数您要在键上合并tconst
,该how
参数告诉函数您希望如何处理两个DataFrame之间不是交叉(共享)的行.