I have a pandas dataFrame created through a mysql call which returns the data as object type.

The data is mostly numeric, with some 'na' values.

How can I cast the type of the dataFrame so the numeric values are appropriately typed (floats) and the 'na' values are represented as numpy NaN values?