Difficulty to convert column

[reza1615]

In real word problems there are many cases which an integer/float type column has some missing data or some string data such as
'...'
'' (empty)
'nan'
'00000000'
ets

Finding the missing cells some times is a nightmare. for example in the below code we can not convert it to float also can not find the missing value in the description to replace it.

import pandas as pd
import numpy as np
numbers=list(range(200))
numbers.append('')
numbers=numbers+list(range(200,300))
data={'col1': numbers}
df=pd.DataFrame(data)

column description doesn't show the incorrect format value (here is an empty cell)

[reza1615]

• For finding missed or wong format cells we should have a part in the description to show the wired values. for example shows there is '...' in the numeric data
• For converting to the float Force convert to float #240 will be helpful for other formats such as data we can use another solution

[aschonfeld]

added in v1.13.0