Chiptole : Finding the highest ordered item about pandas_exercises HOT 4 CLOSED

The groupby(...)sum() code is accounting for item_count. Chicken bowls were ordered 726 times, but 35 of those were for 2 chicken bowls.

from pandas_exercises.

chipo["item_name"] makes a series...
chipo["item_name"].value_counts....gives the number of times each item is present in that series.
Meanwhile chipo.groupby("item_name")..makes an object and then adding the sum function further to it adds the quantity column for each time the item is present.
So basically value_counts adds the number of time item is present in "item_name" column and group_by().sum() add the quantity column elements for the items.

from pandas_exercises.

Sorry - didn't get it. I count max using chipo['item_name'].value_counts() and got 726 items. Method, shown in exercise gives 761. When I actually check original file in excel it gives me 726 as well. What is right way to count and how did this error appear?

from pandas_exercises.

Fixed with last PRs.

from pandas_exercises.