ENH: dataframe.astype() exception message to include column name · Issue #47571 · pandas-dev/pandas (original) (raw)

Is your feature request related to a problem?

When using dataframe.astype() and there is a column missing or there are some values that cannot be correctly converted, there is an exception raised. But there is no way to know which column is missing or which column has the wrong value.

Describe the solution you'd like

The exception message of the dataframe.astype() should contain the column name responsible for the exception (missing column(s) or column with wrong values).

API breaking implications

This does not introduce any breaking changes

Additional context

Some examples of the current exceptions raised by astype():

KeyError: 'Only a column name can be used for the key in a dtype mappings argument.'

TypeError: object cannot be converted to an IntegerDtype

ValueError: invalid literal for int() with base 10: 'test'