Pandas DataFrame astype() Method
Example
Return a new DataFrame where the data type of all columns has been set to 'int64':
import pandas as pd
data = {
"Duration": [50, 40, 45],
"Pulse":
[109, 117, 110],
"Calories": [409.1, 479.5, 340.8]
}
df =
pd.DataFrame(data)
newdf = df.astype('int64')
Try it Yourself »
Definition and Usage
The astype() method returns a new DataFrame
where the data types has been changed to the specified type.
You can cast the entire DataFrame to one specific data type, or you can use a Python Dictionary to specify a data type for each column, like this:
{
'Duration': 'int64',
'Pulse' : 'float',
'Calories': 'int64'
}
Syntax
dataframe.astype(dtype, copy, errors)
Parameters
The copy and errors parameters are keyword arguments.
| Parameter | Value | Description |
|---|---|---|
| dtype | data type, or a dictionary with data types for each column:
{
'Duration': 'int64',
'Pulse' : 'float',
'Calories': 'int64'
} |
Required. Specifies the data type |
| copy | True|False | Optional. Default True. Specifies whether to return a copy (True), or to do the changes in the original DataFrame (False). |
| errors | 'raise'|'ignore' | Optional. Default 'raise'. Specifies whether to ignore errors or raise an exception on error. |
Return Value
a Pandas DataFrame with the changes set according to the specified dtype(s).