{"id":3779,"date":"2023-07-15T14:38:19","date_gmt":"2023-07-15T14:38:19","guid":{"rendered":"https:\/\/statorials.org\/tr\/pandalar-coklu-pivot-tablo-aggfunc\/"},"modified":"2023-07-15T14:38:19","modified_gmt":"2023-07-15T14:38:19","slug":"pandalar-coklu-pivot-tablo-aggfunc","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/pandalar-coklu-pivot-tablo-aggfunc\/","title":{"rendered":"Pandalar: birden fazla aggfunc i\u00e7eren bir pivot tablo olu\u015fturun"},"content":{"rendered":"

<\/p>\n

\n

Pandalarda pivot tablo olu\u015fturmak ve aggfunc<\/strong> arg\u00fcman\u0131na birden fazla de\u011fer sa\u011flamak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n

 df. pivot_table<\/span> (index=' col1<\/span> ', values=' col2<\/span> ', aggfunc=(' sum<\/span> ', ' mean<\/span> '))\n<\/strong><\/pre>\n
 Bu \u00f6zel \u00f6rnek, col2<\/strong> i\u00e7indeki de\u011ferlerin toplam\u0131n\u0131 ve ortalamas\u0131n\u0131 col1’e<\/strong> g\u00f6re grupland\u0131rarak g\u00f6r\u00fcnt\u00fcleyen bir pivot tablo olu\u015fturur.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n
 \u00d6rnek: Birden fazla aggfunc i\u00e7eren bir Pandas pivot tablosu olu\u015fturun<\/strong><\/span><\/h2>\n
 \u00c7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki pandalar DataFrame’e sahip oldu\u011fumuzu varsayal\u0131m:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B',\n                            'B', 'B', 'C', 'C', 'C', 'C'],\n                   ' points<\/span> ': [4, 4, 2, 8, 9, 5, 5, 7, 8, 8, 4, 3],\n                   ' assists<\/span> ': [2, 2, 5, 5, 4, 7, 5, 3, 9, 8, 4, 4]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n   team points assists\n0 to 4 2\n1 to 4 2\n2 to 2 5\n3 to 8 5\n4 B 9 4\n5 B 5 7\n6 B 5 5\n7 B 7 3\n8 C 8 9\n9 C 8 8\n10 C 4 4\n11 C 3 4\n<\/strong><\/pre>\n
 Her tak\u0131m\u0131n<\/strong> att\u0131\u011f\u0131 toplam ve ortalama puan<\/strong> say\u0131s\u0131n\u0131 \u00f6zetleyen bir pivot tablo olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki kodu kullanabiliriz:<\/span><\/p>\n
 #create pivot table to summarize sum and mean of points by team<\/span>\ndf. pivot_table<\/span> (index=' team<\/span> ', values=' points<\/span> ', aggfunc=(' sum<\/span> ', ' mean<\/span> '))\n\n\tmean sum\nteam\t\t\nAt 4.50 18\nB 6.50 26\nC 5.75 23\n<\/span><\/span><\/strong><\/pre>\n
 Ortaya \u00e7\u0131kan pivot tablo, her tak\u0131m\u0131n att\u0131\u011f\u0131 puanlar\u0131n ortalamas\u0131n\u0131 ve toplam\u0131n\u0131 \u00f6zetler.<\/span><\/span><\/p>\n
 \u00d6rne\u011fin \u015funlar\u0131 g\u00f6rebiliriz:<\/span><\/p>\n