<\/p>\n
Ba\u015fka bir DataFrame’de olmayan bir panda DataFrame’inden sat\u0131rlar almak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n A\u015fa\u011f\u0131daki iki panda DataFrame’e sahip oldu\u011fumuzu varsayal\u0131m:<\/span><\/p>\n \u0130ki DataFrame’i birle\u015ftirmek ve hangi sat\u0131rlar\u0131n her bir DataFrame’e ait oldu\u011funu g\u00f6steren bir g\u00f6sterge s\u00fctunu olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span><\/span><\/p>\n Daha sonra yaln\u0131zca ilk DataFrame’den ikinci DataFrame’de olmayan sat\u0131rlar\u0131 almak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span><\/span><\/p>\n Son olarak istersek _merge<\/strong> s\u00fctununu kald\u0131rabiliriz:<\/span><\/p>\n Sonu\u00e7, t\u00fcm sat\u0131rlar\u0131n ilk DataFrame’de mevcut oldu\u011fu ancak ikinci DataFrame’de bulunmad\u0131\u011f\u0131 bir DataFrame’dir.<\/span><\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde pandalarda di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Pandas’ta bir DataFrame’den di\u011ferine s\u00fctun nas\u0131l eklenir?<\/a> Ba\u015fka bir DataFrame’de olmayan bir panda DataFrame’inden sat\u0131rlar almak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz: #merge two DataFrames and create indicator column df_all = df1. merge ( df2.drop_duplicates (), on=[‘ col1 ‘,’ col2 ‘], how=’ left ‘, indicator= True ) #create DataFrame with rows that exist in first DataFrame only df1_only = df_all[df_all[‘ _merge ‘] == […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3721","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n #merge two DataFrames and create indicator column<\/span>\ndf_all = df1. merge<\/span> ( df2.drop_duplicates<\/span> (), on=[' col1<\/span> ',' col2<\/span> '],\n how=' left<\/span> ', indicator= True<\/span> )\n\n#create DataFrame with rows that exist in first DataFrame only<\/span>\ndf1_only = df_all[df_all[' _merge<\/span> '] == ' left_only<\/span> ']<\/strong><\/pre>\n \u00d6rnek: Bir Pandas DataFrame’de ba\u015fka bir DataFrame’de olmayan sat\u0131rlar\u0131 alma<\/strong><\/h2>\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\nprint<\/span> (df2)\n\n team points\n0 to 12\n1 D 29\n2 F 15\n3 G 19\n4:10 a.m.\n<\/span><\/span><\/strong><\/pre>\n #merge two DataFrames and create indicator column\n<\/span>df_all = df1. merge<\/span> ( df2.drop_duplicates<\/span> (), on=[' team<\/span> ',' points<\/span> '],\n how=' left<\/span> ', indicator= True<\/span> )\n\n#view result\n<\/span>print<\/span> (df_all)<\/strong><\/pre>\n #create DataFrame with rows that exist in first DataFrame only\n<\/span>df1_only = df_all[df_all[' _merge<\/span> '] == ' left_only<\/span> ']\n\n#view DataFrame\n<\/span>print<\/span> (df1_only)\n\n team points _merge\n1 B 15 left_only\n2 C 22 left_only\n4 E 24 left_only\n<\/strong><\/pre>\n #drop '_merge' column\n<\/span>df1_only = df1_only. drop<\/span> (' _merge<\/span> ', axis= 1<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df1_only)\n\n team points\n1 B 15\n2 C 22\n4 E 24<\/span><\/span><\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Pandalarda s\u00fctun s\u0131ras\u0131 nas\u0131l de\u011fi\u015ftirilir?<\/a>
Pandalar’da s\u00fctunlar ada g\u00f6re nas\u0131l s\u0131ralan\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"