DataFrame.select_dtypes() to get subset of DataFrame of mathching dtype

select_dtypes(self, include=None, exclude=None)

select_dtypes() : to get subset of DataFrame of particular dtypes.

`Parameters`	include or exclude the selection dtypes
`Returns`	DataFrame to include ( or exclude ) dtypes
`Raise`	ValueError , if Parameters is not given

Let us create a DataFrame having all data types. From this DataFrame we will collect all int dtypes.

import pandas as pd 
td = pd.Series([pd.Timedelta(days=i) for i in range(6)])  
my_dict={'NAME':['Ravi','Raju','Alex','Ron','King','Jack'],
         'ID':[1,2,3,4,5,6],
         'MATH':[80,40,70,70,70,30],
         'Avg_mark':[45.5,48.09,50.12,55.1,50.6,55.6],
         'dt_start':['1/1/2020','2/1/2020','5/1/2020','11/7/2020',
			'15/8/2020','31/12/2020'],
         'Exam':[True,False,True,True,False,False],
         'dt':td,
         'grade':['a', 'c', 'b', 'b','b','c']}

my_data = pd.DataFrame(data=my_dict)
my_data['grade']=my_data['grade'].astype('category')
my_data['dt_start'] = pd.to_datetime(my_data['dt_start'])
print(my_data.select_dtypes(include='int64'))

Output

   ID  MATH
0   1    80
1   2    40
2   3    70
3   4    70
4   5    70
5   6    30

Using more than one dtypes using a list.

print(my_data.select_dtypes(include=['int64','bool']))

Output

   ID  MATH   Exam
0   1    80   True
1   2    40  False
2   3    70   True
3   4    70   True
4   5    70  False
5   6    30  False

Using exclude

We will remove two dtypes int64 and float64, other dtypes will be returned.

print(my_data.select_dtypes(exclude=['int64','float64']))

Output

   NAME   dt_start   Exam     dt grade
0  Ravi 2020-01-01   True 0 days     a
1  Raju 2020-02-01  False 1 days     c
2  Alex 2020-05-01   True 2 days     b
3   Ron 2020-11-07   True 3 days     b
4  King 2020-08-15  False 4 days     b
5  Jack 2020-12-31  False 5 days     c

Pandas to_timedelta() astype() select_dtypes() timedelta64()

Numpy arrays Python & MySQL Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here