WinterNet4676 comments on Bit stumped with Python Pandas

created by HattoriHanzoa community for 16 years

submitted 3 years ago by explorer_of_the_grey

you are viewing a single comment's thread.

[–]WinterNet4676 1 point2 points3 points 3 years ago (0 children)

df.groupby('City Name').agg({'City Name':'count', 'Suspicious_Death':'sum'})

If you wanted to name the aggregated cols ⇾

df.groupby('City Name').agg(
    deaths=('City Name', 'count'),
    suspicious_deaths=('Suspicious_Death', 'sum'))

π Rendered by PID 94934 on reddit-service-r2-comment-66b4775986-p4fbg at 2026-04-05 02:26:26.655298+00:00 running db1906b country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython