Feature Type

  • [ ] Adding new functionality to pandas

  • [x] Changing existing functionality in pandas

  • [ ] Removing existing functionality in pandas

Problem Description

When reading a CSV file that has been written with pandas I get the error message:

TypeError: 'str' object cannot be interpreted as an integer

This probably happens because some value in some column has an unexpected type. But with a dataframe of hundreds of columns and tens of thousands of rows, how is one supposed to find out where the problem lies?

Pandas obvious knows exactly the column and row, but does not care to tell the user.

Please make it give this info to the user, this is pretty basic practice when showing an error message: provide all the information to make it easy for the user to figure out how to fix the problem!

Feature Description

Give the details about which column and row in the data causes the problem

Alternative Solutions

Fiddling around endlessly.

Additional Context

No response

Comment From: yashachaurasia

take