How to count the frequency of a specific value in a column in pandas

Asked Nov 15 '17 at 16:05

Active Nov 15 '17 at 16:49

Viewed 628 times

I am trying to count the number of times the word "unacc" occurs in the column "evaluation" in this excel data file using pandas. With the below code, I can see that there are 1210 "unacc" occurrences but I want to be able to just print that number instead of printing all the unique values in the column. How would I go about that?

import pandas as pd
data_file=pd.read_csv('9car.data.csv')
print(data_file.evaluation.value_counts())

edited Nov 15 '17 at 16:49

miradulo

28,857
6
80
93

asked Nov 15 '17 at 16:05

Sarah Elton

that only prints the number of unique values, I need the number of times a specific value occurs within the attribute – Sarah Elton Nov 15 '17 at 16:08
Yep I misread. See jezraels answer below – Anton vBR Nov 15 '17 at 16:08

How to count the frequency of a specific value in a column in pandas

0 Answers0