How do I troubleshoot type hints?

My table has a column that's the wrong type. I checked my typecasting and type hints, and it should produce the correct type. What's going on?

There are multiple things that can cause a column to be of the wrong type. If a column should be an integer type but instead contains decimal numbers, there could be a NaN value poisoning it. Here is an example where this happens. If a column should be numeric, but is of string type, it has a non-numeric value somewhere. A good way to find exactly where these things happen is to convert the column to a pandas DataFrame and search for the offending value.

note

These FAQ pages contain answers to questions about Deephaven Community Core that our users have asked in our Community Slack. If you have a question that is not in our documentation, join our Community and we'll be happy to help!