Python计数来自CSV Pandas的行

Question

colors.csv

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

您如何计算多少f＆amp;T，（如下）

colors_summary = colors.count('is_trans')
print(colors_summary)

寻找结果

is_trans    id  name    rgb
f   107 107 107
t   28  28  28

Answer 1

让我们说你有

color_df # dataframe object

您可以做到：

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

Answer 2

和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})