CODEWITHSUNDEEP
pythondata-sciencegspreadfind-occurrences
AmZaliAn
AmZaliAn

Reputation: 21

Find an occurrence in a table column using panda

I'm a complete beginner using Python and I'm trying to find a way to know how much Female and Male I have in my table. I've imported my table and printed it but don't know how to find occurrences in my columns 

tableur = gc.open("KIDS91").sheet1
print(tableur)


CITY    CSP BIRTHDAY    NAME    GENDER
LOND    48  01/04/2009  Peter   M
LOND    20  06/11/2008  Lucy    F
LOND    22  23/06/2009  Piper   F

Upvotes: 1

Views: 96

Answers (2)

martin
martin

Reputation: 1185

Perhaps this will be good?

import pandas as pd


df =  pd.read_csv("KIDS91", sep ='\t')
df.GENDER.value_counts()

a bit simplifying:

First line - import pandas

Second line - loading yours data frame to memory

Last line - return counted values from column GENDER in data frame named df.

Upvotes: 1

Tom Ron
Tom Ron

Reputation: 6181

See pandas value_counts -

tableur.GENDER.value_counts()

Upvotes: 1

Related Questions