Count values in Pandas data Frame -Python

Question

I have a data set as such

For simplicity -Let's say I want to calculate the number of type of each manufacturer of the plane.

I want the output as such-

BOEING-xxx
EMBRAER-xxx
MCDONNELL-XXX
:
:
:
so on

How can I do this ? Please help me out with this.

Timbus Calin · Accepted Answer · 2020-10-10 13:37:27Z

2

You can use dataframe['manufacturer'].value_counts() to get the result that you want;

However, note that you have NaNs in your column; so prior to applying the function above, use:

dataframe.dropna(subset=['manufacturer'],inplace=True)

Summing it up:

answered Oct 10, 2020 at 13:30

Timbus Calin

15.2k6 gold badges49 silver badges69 bronze badges

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

1 Answer 1