Pandas DataFrame select_dtypes() Method
Example
Return a DataFrame with only the columns with the dtype 'int64':
import pandas as pd
df = pd.read_csv('data.csv')
newdf =
df.select_dtypes(include='int64')
Try it Yourself »
Definition and Usage
The select_dtypes() method returns a new
DataFrame that includes/excludes columns of the specified dtype(s).
Use the include parameter to specify the
included columns, or use the exclude parameter
to specify which columns to exclude
Note: You must specify at least one of the parameters
include and/or
exclude, or else you will get an error.
Syntax
dataframe.select_dtypes(include, exclude)
Parameters
The parameters are keyword arguments.
| Parameter | Value | Description |
|---|---|---|
| include | string|list | Which column(s) to include in the result. Required if the exclude parameter is not present. |
| exclude | string|list | Which column(s) to exclude from the result. Required if the include parameter is not present. |
Return Value
a Pandas DataFrame with the included columns and without the excluded columns.
