Sort Pandas dataframe and print highest n values Sort Pandas dataframe and print highest n values pandas pandas

Sort Pandas dataframe and print highest n values


pandas sorting dataframe max

I think you can use nlargest (New in pandas version 0.17.0):

print df   0  Bytes  Client             Ip0  1      1    1000   192.168.10.21  0      0    2000  192.168.10.122  2      2     500   192.168.10.43  3      3     159  192.168.10.56print df.nlargest(3, 'Client')   0  Bytes  Client             Ip1  0      0    2000  192.168.10.120  1      1    1000   192.168.10.22  2      2     500   192.168.10.4

pandas sorting dataframe max

Note: sort is deprecated - use sort_values instead

To sort descending use ascending=False:

In [6]: df.sort('Bytes', ascending=False)Out[6]:   0  Bytes      Client Ip1  1   2000  192.168.10.120  0   1000   192.168.10.22  2    500   192.168.10.43  3    159  192.168.10.56

To take the first 10 values use .head(10).

pandas sorting dataframe max 

df['Bytes'] = df['Bytes'].astype('int')print df.sort('Bytes', ascending=False).head(10)[['Bytes', 'Client-IP']]

I could solve it using above code with the help of Andy Hayden. :D

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last