<\/p>\n
Pandas’ta belirli bir s\u00fctun i\u00e7in toplam\u0131n y\u00fczdesini g\u00f6r\u00fcnt\u00fcleyen bir pivot tabloya bir s\u00fctun eklemek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel s\u00f6zdizimi, puan<\/strong> s\u00fctunundaki toplam de\u011ferlerin y\u00fczdesini g\u00f6r\u00fcnt\u00fcleyen my_table<\/strong> adl\u0131 pivot tabloya % puan<\/strong> ad\u0131 verilen yeni bir s\u00fctun ekler.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Farkl\u0131 basketbol oyuncular\u0131 taraf\u0131ndan at\u0131lan puanlar\u0131n say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki panda DataFrame’e sahip oldu\u011fumuzu varsayal\u0131m:<\/span><\/p>\n Tak\u0131ma ve konuma g\u00f6re puanlar\u0131n toplam\u0131n\u0131 g\u00f6steren bir pivot tablo olu\u015fturmak i\u00e7in pivot_table()<\/strong> i\u015flevini kullanabiliriz:<\/span><\/p>\n Sonu\u00e7tan \u015funlar\u0131 g\u00f6rebiliriz:<\/span><\/p>\n Daha sonra, her sat\u0131r i\u00e7in toplam puanlar\u0131n y\u00fczdesini g\u00f6r\u00fcnt\u00fcleyen % puan<\/strong> ad\u0131 verilen yeni bir s\u00fctun eklemek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span><\/span><\/p>\n Yeni % Puan<\/strong> s\u00fctunu art\u0131k puan de\u011ferlerini toplam puanlar\u0131n y\u00fczdesi olarak g\u00f6steriyor.<\/span><\/p>\n Ayr\u0131ca y\u00fczde de\u011ferlerini belirli say\u0131da ondal\u0131k basama\u011fa yuvarlamak i\u00e7in round()<\/strong> i\u015flevini kullanabilece\u011finizi unutmay\u0131n.<\/span><\/p>\n Y\u00fczde de\u011ferleri art\u0131k iki ondal\u0131k basama\u011fa yuvarlan\u0131yor.<\/span><\/p>\n Not<\/strong> : Pandalar\u0131n pivot_table()<\/strong> i\u015flevinin tam belgelerini burada<\/a> bulabilirsiniz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde pandalarda di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Pandalar: Pivot tabloya filtre nas\u0131l eklenir?<\/a> Pandas’ta belirli bir s\u00fctun i\u00e7in toplam\u0131n y\u00fczdesini g\u00f6r\u00fcnt\u00fcleyen bir pivot tabloya bir s\u00fctun eklemek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz: my_table[‘ % points ‘] = (my_table[‘ points ‘]\/my_table[‘ points ‘]. sum ())* 100 Bu \u00f6zel s\u00f6zdizimi, puan s\u00fctunundaki toplam de\u011ferlerin y\u00fczdesini g\u00f6r\u00fcnt\u00fcleyen my_table adl\u0131 pivot tabloya % puan ad\u0131 verilen yeni bir s\u00fctun ekler. A\u015fa\u011f\u0131daki \u00f6rnek, bu […]<\/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-4250","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n my_table[' % points<\/span> '] = (my_table[' points<\/span> ']\/my_table[' points<\/span> ']. sum<\/span> ())* 100\n<\/span><\/strong><\/pre>\n \u00d6rnek: Y\u00fczdelerle Pandalar \u00d6zet Tablosu Olu\u015fturma<\/strong><\/span><\/h2>\n
import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n ' position<\/span> ': ['Guard', 'Guard', 'Forward', 'Forward',\n 'Guard', 'Guard', 'Forward', 'Forward'],\n ' points<\/span> ': [22, 30, 14, 15, 19, 30, 23, 20]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n team position points\n0 A Guard 22\n1A Guard 30\n2 A Forward 14\n3 A Forward 15\n4 B Guard 19\n5 B Guard 30\n6 B Forward 23\n7 B Forward 20\n<\/strong><\/pre>\n #create pivot table to calculate sum of points by team and position\n<\/span>my_table = pd. pivot_table<\/span> (df, index=[' team<\/span> ', ' position<\/span> '], aggfunc=' sum<\/span> ')\n\n#view pivot table\n<\/span>print<\/span> (my_table)\n\n points\nteam position \nA Forward 29\n Guard 52\nB Forward 43\n Guard 49\n<\/span><\/span><\/strong><\/pre>\n\n
#add column that displays points as a percentage of total points<\/span>\nmy_table[' % points<\/span> '] = (my_table[' points<\/span> ']\/my_table[' points<\/span> ']. sum<\/span> ())* 100\n\n#view updated pivot table\n<\/span>print<\/span> (my_table)\n\n points % points\nteam position \nA Forward 29 16.763006\n Guard 52 30.057803\nB Forward 43 24.855491\n Guard 49 28.323699<\/span><\/span><\/strong><\/pre>\n #add column that displays points as a percentage of total points (rounded)<\/span>\nmy_table[' % points<\/span> '] = round<\/span> ((my_table[' points<\/span> ']\/my_table[' points<\/span> ']. sum<\/span> ())* 100 , 2<\/span> )<\/span>\n\n#view updated pivot table\n<\/span>print<\/span> (my_table)\n\n points % points\nteam position \nA Forward 29 16.76\n Guard 52 30.06\nB Forward 43 24.86\n Guard 49 28.32\n<\/span><\/span><\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Pandalar: Pivot tablo s\u00fctundaki de\u011ferlere g\u00f6re nas\u0131l s\u0131ralan\u0131r<\/a>
Pandalar: De\u011ferlerin toplam\u0131n\u0131 i\u00e7eren bir pivot tablo nas\u0131l olu\u015fturulur?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"