{"id":3724,"date":"2023-07-15T22:26:06","date_gmt":"2023-07-15T22:26:06","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-baris-tersebut-berada-dalam-kerangka-data-lain\/"},"modified":"2023-07-15T22:26:06","modified_gmt":"2023-07-15T22:26:06","slug":"pandas-memeriksa-apakah-baris-tersebut-berada-dalam-kerangka-data-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-baris-tersebut-berada-dalam-kerangka-data-lain\/","title":{"rendered":"Pandas: periksa apakah baris dari satu dataframe ada di dataframe lain"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk menambahkan kolom baru ke pandas DataFrame yang menunjukkan apakah setiap baris ada di DataFrame lain:<\/span><\/p>\n

 #merge two DataFrames on specific columns<\/span>\nall_df = pd. merge<\/span> (df1, df2, on=[' column1<\/span> ', ' column2<\/span> '], how=' left<\/span> ', indicator=' exists<\/span> ')\n\n#drop unwanted columns<\/span>\nall_df = all_df. drop<\/span> (' column3<\/span> ', axis= 1<\/span> )\n\n#add column that shows if each row in one DataFrame exists in another<\/span>\nall_df[' exists<\/span> '] = np. where<\/span> (all_df. exists<\/span> == ' both<\/span> ', True<\/span> , False<\/span> )\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: periksa apakah baris di satu Pandas DataFrame ada di baris lain<\/strong><\/h2>\n
 Mari kita asumsikan kita memiliki dua panda DataFrames berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#create first DataFrame\ndf1 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D', 'E'], \n                    ' points<\/span> ': [12, 15, 22, 29, 24]}) \n\nprint<\/span> (df1)\n\n  team points\n0 to 12\n1 B 15\n2 C 22\n3 D 29\n4 E 24\n\n#create second DataFrame\n<\/span>df2 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'D', 'F', 'G', 'H'],\n                    ' points<\/span> ': [12, 29, 15, 19, 10],\n                    ' assists<\/span> ': [4, 7, 7, 10, 12]})\n\nprint<\/span> (df2)\n\n  team points assists\n0 to 12 4\n1 D 29 7\n2 F 15 7\n3 G 19 10\n4:10:12\n<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan sintaks berikut untuk menambahkan kolom yang disebut ada<\/strong> ke DataFrame pertama yang menunjukkan apakah setiap nilai dalam kolom tim<\/strong> dan poin<\/strong> di setiap baris ada di DataFrame kedua:<\/span><\/p>\n
 import<\/span> numpy as<\/span> np\n\n#merge two dataFrames and add indicator column\n<\/span>all_df = pd. merge<\/span> (df1, df2, on=[' team<\/span> ', ' points<\/span> '], how=' left<\/span> ', indicator=' exists<\/span> ')\n\n#drop assists columns\n<\/span>all_df = all_df. drop<\/span> (' assists<\/span> ', axis= 1<\/span> )\n\n#add column to show if each row in first DataFrame exists in second\n<\/span>all_df[' exists<\/span> '] = np. where<\/span> (all_df. exists<\/span> == ' both<\/span> ', True<\/span> , False<\/span> )\n\n#view updated DataFrame\n<\/span>print<\/span> (all_df)\n\n  team points exists\n0 A 12 True\n1 B 15 False\n2 C 22 False\n3 D 29 True\n4 E 24 False\n<\/strong><\/span><\/pre>\n
 Kolom baru ada<\/strong> menunjukkan apakah setiap nilai di kolom tim<\/strong> dan poin<\/strong> di setiap baris ada di DataFrame kedua.<\/span><\/span><\/p>\n
 Dari hasilnya kita dapat melihat:<\/span><\/p>\n