<\/p>\n
Pandalar pivot tablosunu bir s\u00fctunun de\u011ferlerine g\u00f6re s\u0131ralamak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel \u00f6rnek, my_pivot_table<\/strong> adl\u0131 bir pivot tablonun de\u011ferlerini, some_column<\/strong> de\u011ferlerine g\u00f6re azalan d\u00fczende s\u0131ralar.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\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 Her tak\u0131m i\u00e7in puan<\/strong> ve asist<\/strong> s\u00fctunlar\u0131ndaki de\u011ferlerin toplam\u0131n\u0131 g\u00f6r\u00fcnt\u00fcleyen pandalarda bir pivot tablo olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki kodu kullanabiliriz:<\/span><\/p>\n Varsay\u0131lan olarak pandalar, pivot tablo sat\u0131rlar\u0131n\u0131, ekip<\/strong> s\u00fctunu olan dizin s\u00fctununun de\u011ferine g\u00f6re alfabetik olarak s\u0131ralar.<\/span><\/p>\n Ancak pivot tablo sat\u0131rlar\u0131n\u0131 nokta<\/strong> s\u00fctun de\u011ferlerine g\u00f6re s\u0131ralamak i\u00e7in sort_values()<\/strong> i\u015flevini kullanabiliriz:<\/span><\/p>\n PivotTable sat\u0131rlar\u0131n\u0131n art\u0131k Noktalar<\/strong> s\u00fctunundaki de\u011ferlere g\u00f6re s\u0131raland\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n Artan=Yanl\u0131\u015f<\/strong> arg\u00fcman\u0131n\u0131 atlarsan\u0131z, sat\u0131rlar\u0131n nokta<\/strong> s\u00fctunundaki de\u011ferlere g\u00f6re artan s\u0131rada s\u0131ralanaca\u011f\u0131n\u0131 unutmay\u0131n:<\/span><\/p>\n PivotTable sat\u0131rlar\u0131n\u0131n art\u0131k nokta<\/strong> s\u00fctun de\u011ferlerine g\u00f6re artan s\u0131rada (en k\u00fc\u00e7\u00fckten en b\u00fcy\u00fc\u011fe) s\u0131raland\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n Not #1:<\/strong> Ayr\u0131ca sort_values()<\/strong> i\u015flevindeki by<\/strong> arg\u00fcman\u0131na birden \u00e7ok de\u011fer ileterek pivot tablodaki birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama yapabilirsiniz.<\/span><\/p>\n Not #2<\/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: DataFrame’i uzundan geni\u015fe do\u011fru yeniden \u015fekillendirme<\/a> Pandalar pivot tablosunu bir s\u00fctunun de\u011ferlerine g\u00f6re s\u0131ralamak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz: my_pivot_table. sort_values (by=[‘ some_column ‘], ascending= False ) Bu \u00f6zel \u00f6rnek, my_pivot_table adl\u0131 bir pivot tablonun de\u011ferlerini, some_column de\u011ferlerine g\u00f6re azalan d\u00fczende s\u0131ralar. A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir. \u00d6rnek: Pandalar pivot tablosunu s\u00fctundaki de\u011ferlere g\u00f6re s\u0131ralama \u00c7e\u015fitli basketbol oyuncular\u0131 […]<\/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-3777","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n my_pivot_table. sort_values<\/span> (by=[' some_column<\/span> '], ascending= False<\/span> )\n<\/strong><\/pre>\n \u00d6rnek: Pandalar pivot tablosunu s\u00fctundaki de\u011ferlere g\u00f6re s\u0131ralama<\/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',\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 #create pivot table\n<\/span>df_pivot = df. pivot_table<\/span> (index=[' team<\/span> '], values=[' points<\/span> ', ' assists<\/span> '], aggfunc=' sum<\/span> ')\n\n#view pivot table\n<\/span>print<\/span> (df_pivot)\n\n assist points\nteam \nAt 14 18\nB 19 26\nC 25 23\n<\/span><\/span><\/strong><\/pre>\n #sort pivot table by value in 'points' column in descending order\n<\/span>sorted_df_pivot = df_pivot. sort_values<\/span> (by=[' points<\/span> '], ascending= False<\/span> )\n\n#view sorted pivot table\n<\/span>print<\/span> (sorted_df_pivot)\n\n assist points\nteam \nB 19 26\nC 25 23\nAt 14 18\n<\/span><\/span><\/strong><\/pre>\n #sort pivot table by value in 'points' column in ascending order\n<\/span>sorted_df_pivot = df_pivot. sort_values<\/span> (by=[' points<\/span> '])\n\n#view sorted pivot table\n<\/span>print<\/span> (sorted_df_pivot)\n\n assist points\nteam \nAt 14 18\nC 25 23\nB 19 26\n<\/span><\/span><\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Pandalar: DataFrame’i geni\u015ften uzuna nas\u0131l yeniden \u015fekillendirebilirim?<\/a>
Pandalar: birden \u00e7ok s\u00fctunda nas\u0131l grupland\u0131r\u0131l\u0131r ve toplan\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"