Category
Load DataFrame
groupby()
SELECT portno, COUNT(1) FROM table GROUP BY portno
SELECT portno, SUM(security_rank), … FROM table GROUP BY portno
SELECT portno, SUM(nbr_shares) FROM table GROUP BY portno
SELECT portno, COUNT(1) FROM table GROUP BY portno
SELECT portno, SUM(security_rank), … FROM table GROUP BY portno
SELECT portno, SUM(nbr_shares) FROM table GROUP BY portno