nlargest of each group 1

nlargest of each group

ByAnurag batra 
df.groupby('team').apply(lambda x:x.nlargest(3,'points')).reset_index(drop=True)

  team   player  points
0    A    Alice      15
1    A   Carmen      13
2    A    Becky      11
3    B    Greta      29
4    B     Fran      28
5    B     Iris      25
6    C     Lucy      23
7    C    Molly      18
8    C  Ophelia      15

Here is what the above code is Doing:
1. groupby(‘team’)
2. apply(lambda x:x.nlargest(3,’points’))
3. reset_index(drop=True)

1. groupby(‘team’)

This is the same as before.

2. apply(lambda x:x.nlargest(3,’points’))

This is the new part.

apply() is a function that takes another function as an argument.

In this case, the function we’re passing to apply() is lambda x:x.nlargest(3,’points’).

lambda x:x.nlargest(3,’points’) is a function that takes a dataframe as an argument and returns the 3 rows with the highest values in the ‘points’ column.

So, when we call apply(lambda x:x.nlargest(3,’points’)), we’re telling pandas to group the dataframe by ‘team’, and then for each group, return the 3 rows with the highest values in the ‘points’ column.

3. reset_index(drop=True)

This is the same as before.

Similar Posts

python keep value recursive function

python keep value recursive function

ByAnurag batra

def to_string(node): def actual_recursive(node): nonlocal a_str # ~global, can modify surrounding function’s scope. a_str += str(node.val) if node.next != None: actual_recursive(node.next) a_str = ” actual_recursive(node) return a_str Here is what the above code is Doing: 1. Define a function that takes a node as an argument. 2. Define a nonlocal variable a_str. 3. Append the…

WAP THAT ASKS A USER FOR A NUMBER OF YEARS AND THEN PRINTS OUT THE NUMBER OF DAYS, HOURS ,MINUTES AND SECONDS IN THAT NO. OF YEARS.

WAP THAT ASKS A USER FOR A NUMBER OF YEARS AND THEN PRINTS OUT THE NUMBER OF DAYS, HOURS ,MINUTES AND SECONDS IN THAT NO. OF YEARS.

ByAnurag batra

y = float(input(“How many years? “)) d = y * 365 h = d * 24 m = h * 60 s = m * 60 print(y, “years is:”) print(d, “days”) print(h, “hours”) print(m, “minutes”) print(s, “seconds”) Here is what the above code is Doing: 1. It asks the user to input a number of…

shebnag python

shebnag python

ByAnurag batra

#!/usr/bin/python Here is what the above code is Doing: 1. We’re importing the Flask class. An instance of this class will be our WSGI application. 2. We create an instance of this class. The first argument is the name of the application’s module or package. If you are using a single module (as in this…

how to search on wikipedia with python and speak the result

how to search on wikipedia with python and speak the result

ByAnurag batra

import wikipedia import pyttsx3 word = “python programmming” result = wikipedia.summary(word) print(result) pyttsx3.speak(result) Here is what the above code is Doing: 1. We are importing the wikipedia module. 2. We are importing the pyttsx3 module. 3. We are creating a variable named word and assigning it the value “python programming”. 4. We are creating a…