Pandas: Data Manipulation - to_numeric() function

Last update on August 19 2022 21:50:52 (UTC/GMT +8 hours)

to_numeric() function

The to_numeric() function is used tp convert argument to a numeric type.

The default return dtype is float64 or int64 depending on the data supplied. Use the downcast parameter to obtain other dtypes.

Due to the internal limitations of ndarray, if numbers smaller than -9223372036854775808 (np.iinfo(np.int64).min) or larger than 18446744073709551615 (np.iinfo(np.uint64).max) are passed in, it is very likely they will be converted to float so that they can stored in an ndarray. These warnings apply similarly to Series since it internally leverages ndarray.

Syntax:

pandas.to_numeric(arg, errors='raise', downcast=None)

Parameters:

Name	Description	Type / Default Value	Required / Optional
arg		scalar, list, tuple, 1-d array, or Series	Required
errors	If 'raise', then invalid parsing will raise an exception If 'coerce', then invalid parsing will be set as NaN If 'ignore', then invalid parsing will return the input	{'ignore', 'raise', 'coerce'}, Default Value: 'raise'	Required
downcst	If not None, and if the data has been successfully cast to a numerical dtype (or if the data was numeric to begin with), downcast that resulting data to the smallest numerical dtype possible according to the following rules: 'integer' or 'signed': smallest signed int dtype (min.: np.int8) 'unsigned': smallest unsigned int dtype (min.: np.uint8) 'float': smallest float dtype (min.: np.float32) As this behaviour is separate from the core conversion to numeric values, any errors raised during the downcasting will be surfaced regardless of the value of the 'errors' input. In addition, downcasting will only occur if the size of the resulting data’s dtype is strictly larger than the dtype it is to be cast to, so if none of the dtypes checked satisfy that specification, no downcasting will be performed on the data.	{‘integer’, ‘signed’, ‘unsigned’, ‘float’} , Default Value: None	Required

Returns: ret : numeric if parsing succeeded.
Return type depends on input. Series if Series, otherwise ndarray.

Example:

Download the Pandas DataFrame Notebooks from here.

Previous: notnull() function
Next: to_datetime() function