python count rows from 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

How do you count how many f & t, (something like below)

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

Looking for Result

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

Uh, what kind of object is colors? Is this a pandas dataframe? How is this question related to csv? — Aran-Fey
– Aran-Fey, Commented Mar 3, 2019 at 19:15
You can make use of Counter class from collections built-in module, but only if that's not a pandas DataFrame. — bc291
– bc291, Commented Mar 3, 2019 at 19:16
import pandas as pd colors = pd.read_csv('datasets/colors.csv') — StackBartender
– StackBartender, Commented Mar 3, 2019 at 19:18
edit that into the question please. And you'll probably want to add a pandas tag while you're at it. — Aran-Fey
– Aran-Fey, Commented Mar 3, 2019 at 19:20
how does your output match the input? can you explain plz? do you mean df.groupby('is_trans').count().reset_index() ? — anky
– anky, Commented Mar 3, 2019 at 19:26

usher · Accepted Answer · 2019-03-03 19:33:25Z

1

let say you have

color_df # dataframe object

you can do that:

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

answered Mar 3, 2019 at 19:33

usher

861 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

StackBartender Over a year ago

yess! groupby worked, I did not know, python has this like SQL

ahed87 · Accepted Answer · 2019-03-03 20:13:51Z

0

and an alternative with 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})

answered Mar 3, 2019 at 20:13

ahed87

1,36010 silver badges12 bronze badges

Collectives™ on Stack Overflow

python count rows from csv pandas

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related