<\/p>\n
Aby znale\u017a\u0107 sum\u0119 warto\u015bci wed\u0142ug grup w pandach, mo\u017cesz u\u017cy\u0107 nast\u0119puj\u0105cej podstawowej sk\u0142adni:<\/span><\/p>\n Poni\u017csze przyk\u0142ady pokazuj\u0105, jak w praktyce u\u017cywa\u0107 tej sk\u0142adni z nast\u0119puj\u0105c\u0105 ramk\u0105 DataFrame pand:<\/span><\/p>\n Poni\u017cszy kod pokazuje, jak grupowa\u0107 wed\u0142ug kolumn i sumowa\u0107 warto\u015bci w kolumnie:<\/span><\/p>\n Z wyniku mo\u017cemy zobaczy\u0107, \u017ce:<\/span><\/p>\n Poni\u017cszy kod pokazuje, jak grupowa\u0107 wiele kolumn i sumowa\u0107 wiele kolumn:<\/span><\/p>\n Z wyniku mo\u017cemy zobaczy\u0107, \u017ce:<\/span><\/p>\n I tak dalej.<\/span><\/p>\n Nale\u017cy pami\u0119ta\u0107, \u017ce funkcja reset_index()<\/strong> zapobiega grupowaniu kolumn jako cz\u0119\u015bci indeksu.<\/span><\/p>\n Na przyk\u0142ad tak wygl\u0105da wynik, je\u015bli go nie u\u017cyjemy:<\/span><\/p>\n W zale\u017cno\u015bci od tego, jak maj\u0105 wygl\u0105da\u0107 wyniki, mo\u017cesz u\u017cy\u0107 funkcji reset_index()<\/strong> lub nie.<\/span><\/p>\n Poni\u017csze samouczki wyja\u015bniaj\u0105, jak wykonywa\u0107 inne typowe operacje grupowania w pandach:<\/span><\/p>\n Jak liczy\u0107 obserwacje grupowe u pand<\/a> Aby znale\u017a\u0107 sum\u0119 warto\u015bci wed\u0142ug grup w pandach, mo\u017cesz u\u017cy\u0107 nast\u0119puj\u0105cej podstawowej sk\u0142adni: df. groupby ([’ group1 ’,’ group2 ’])[’ sum_col ’]. sum (). reset_index () Poni\u017csze przyk\u0142ady pokazuj\u0105, jak w praktyce u\u017cywa\u0107 tej sk\u0142adni z nast\u0119puj\u0105c\u0105 ramk\u0105 DataFrame pand: import pandas as pd #createDataFrame df = pd. DataFrame ({’ team ’: [’A’, 'A’, 'A’, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2192","post","type-post","status-publish","format-standard","hentry","category-przewodnik"],"yoast_head":"\n df. groupby<\/span> ([' group1<\/span> ',' group2<\/span> '])[' sum_col<\/span> ']. sum<\/span> (). reset_index<\/span> ()\n<\/strong><\/pre>\n import<\/span> pandas as<\/span> pd\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n ' position<\/span> ': ['G', 'G', 'F', 'C', 'G', 'F', 'F', 'C'],\n ' points<\/span> ': [25, 17, 14, 9, 12, 9, 6, 4],\n ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n#view DataFrame\n<\/span>df\n\n\tteam position points rebounds\n0 A G 25 11\n1 A G 17 8\n2 A F 14 10\n3 A C 9 6\n4 B G 12 6\n5 B F 9 5\n6 B F 6 9\n7 B C 4 12<\/b><\/pre>\n Przyk\u0142ad 1: grupuj wed\u0142ug kolumny, dodaj kolumn\u0119<\/strong><\/span><\/h3>\n
#group by team and sum the points\ndf. groupby<\/span> ([' team<\/span> '])[' points<\/span> ']. sum<\/span> (). reset_index<\/span> ()\n\n\tteam points\n0 to 65\n1 B 31\n<\/span><\/span><\/strong><\/pre>\n\n
Przyk\u0142ad 2: grupuj wed\u0142ug wielu kolumn, dodaj wiele kolumn<\/strong><\/span><\/h3>\n
#group by team and position, sum points and rebounds\ndf. groupby<\/span> ([' team<\/span> ', ' position<\/span> '])[' points<\/span> ', ' rebounds<\/span> ']. sum<\/span> (). reset_index<\/span> ()\n\n team position points rebounds\n0 A C 9 6\n1 A F 14 10\n2 A G 42 19\n3 B C 4 12\n4 B F 15 14\n5 B G 12 6\n<\/span><\/span><\/strong><\/pre>\n\n
#group by team and position, sum points and rebounds\ndf. groupby<\/span> ([' team<\/span> ', ' position<\/span> '])[' points<\/span> ', ' rebounds<\/span> ']. sum<\/span> ()\n\n rebound points\nteam position\t\t\nA C 9 6\nF 14 10\nG 42 19\nB C 4 12\nF 15 14\nG 12 6<\/span><\/span><\/strong><\/pre>\n Dodatkowe zasoby<\/strong><\/span><\/h3>\n
Jak znale\u017a\u0107 maksymaln\u0105 warto\u015b\u0107 na grup\u0119 w Pandas<\/a>
Jak obliczy\u0107 kwantyle wed\u0142ug grupy w Pandach<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"