Sep-10-2017, 05:44 AM
I have '-' and some negative numbers '-2.5' in a column of data. How to replace only column values having only '-' with NaN, leaving negative numbers unchanged. Tried below didn't work.
Data[col]=Data[col].replace(to_replace='^-$', value='NaN')
Data[col]=Data[col].replace(to_replace='^-$', value='NaN')