How to drop one or multiple columns in Pandas DataFrame

Get n-smallest values from a particular column in Pandas DataFrame

Last Updated : 18 Dec, 2018

Pandas DataFrame is two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns). Let's see how can we can get n-smallest values from a particular column in Pandas DataFrame. Observe this dataset first. We'll use 'Age', 'Weight' and 'Salary' columns of this data in order to get n-smallest values from a particular column in Pandas DataFrame.

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv") 

df.head(10)

Code #1: Getting 5 smallest Age

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("nba.csv") 


df.nsmallest(5, ['Age'])

Output:

Code #2: Getting 10 minimum weights

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("nba.csv") 


df.nsmallest(10, ['Weight'])

Output:

Code #3: Getting 10 minimum salary

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("nba.csv") 


df.nsmallest(5, ['Salary'])

Output:

How to drop one or multiple columns in Pandas DataFrame

S

Shivam_k

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Pandas Exercises and Programs

Pandas is an open-source Python Library that is made mainly for working with relational or labelled data both easily and intuitively. This Python library is built on top of the NumPy library, providing various operations and data structures for manipulating numerical data and time series. Pandas is

Different ways to create Pandas Dataframe

It is the most commonly used Pandas object. The pd.DataFrame() function is used to create a DataFrame in Pandas. There are several ways to create a Pandas Dataframe in Python.Example: Creating a DataFrame from a DictionaryPythonimport pandas as pd # initialize data of lists. data = {'Name': ['Tom',