来自csv熊猫的python计数行

和stdlib的替代方案 csv & Counter 是的。

color_csv = """id  name    rgb         is_trans
0   -1  Unknown 0033B2  f
1   0   Black   05131D  f
2   1   Blue    0055BF  t"""

import csv
from collections import Counter
from io import StringIO

settings = dict(delimiter=' ', skipinitialspace=True)
creader = csv.reader(StringIO(color_csv), **settings)
headers = next(creader)
counter = Counter((row[-1] for row in creader))
print(counter)

Counter({'f': 2, 't': 1})

假设你有

color_df # dataframe object

你可以这样做:

result_df = color_df.groupby('is_trans').count()
print(result_df) # should give you what you ask for.