def removefirstlastchar( x) :
value = str ( x)
if value.lower ( ) == 'NAN' .lower ( ) :
return x
if ( value[ 0 ] .isalpha ( ) == True ) :
value = value[ 1 :]
if ( value[ -1 ] .isalpha ( ) == True ) :
value = value[ :-1 ]
return float ( value)
# I am passing the above function to the columns 74:92 in my dataframe
df.iloc [ :, 74 :92 ] = df.iloc [ :, 74 :92 ] .apply ( removefirstlastchar)
# This is not cleaning. it says "could not convert string to float: '0 O15.5\\n1 NaN\\n2 NaN\\n3 NaN\\n4 NaN\\n5 15.4K\\n6 NaN\\n7 NaN\\n8 NaN\\n9 NaN\\n10 NaN\\n11 NaN\\n12 NaN\\n13 NaN\\n14 NaN\\n15 NaN\\n16 Q10.4\\n17 NaN\\n18 NaN\\n19 NaN\\n20 NaN\\n21 NaN\\n22 NaN\\n23 S16.7\\n24 NaN\\n25 NaN\\n26 NaN\\n27 NaN\\n28 NaN\\n29 14.5\\n30 14.3\\n31 NaN\\n32 NaN\\n33 14.6P\\n34 NaN\\n35 NaN\\n36 NaN\\nName: depression_adult, dtype: objec'", 'occurred at index depression_adult')
ZGVmIHJlbW92ZWZpcnN0bGFzdGNoYXIoeCk6Cgl2YWx1ZSA9IHN0cih4KQoJaWYgdmFsdWUubG93ZXIoKSA9PSAnTkFOJy5sb3dlcigpOgoJCXJldHVybiB4CglpZih2YWx1ZVswXS5pc2FscGhhKCkgPT0gVHJ1ZSk6CgkJdmFsdWUgPSB2YWx1ZVsxOl0KCWlmKHZhbHVlWy0xXS5pc2FscGhhKCkgPT0gVHJ1ZSk6CgkJdmFsdWUgPSB2YWx1ZVs6LTFdCglyZXR1cm4gZmxvYXQodmFsdWUpIAoKIAoKIyBJIGFtIHBhc3NpbmcgdGhlIGFib3ZlIGZ1bmN0aW9uIHRvIHRoZSBjb2x1bW5zIDc0OjkyIGluIG15IGRhdGFmcmFtZQpkZi5pbG9jWzosIDc0OjkyXSA9IGRmLmlsb2NbOiwgNzQ6OTJdLmFwcGx5KHJlbW92ZWZpcnN0bGFzdGNoYXIpIAoKIyBUaGlzIGlzIG5vdCBjbGVhbmluZy4gaXQgc2F5cyAiY291bGQgbm90IGNvbnZlcnQgc3RyaW5nIHRvIGZsb2F0OiAnMCAgICAgTzE1LjVcXG4xICAgICAgIE5hTlxcbjIgICAgICAgTmFOXFxuMyAgICAgICBOYU5cXG40ICAgICAgIE5hTlxcbjUgICAgIDE1LjRLXFxuNiAgICAgICBOYU5cXG43ICAgICAgIE5hTlxcbjggICAgICAgTmFOXFxuOSAgICAgICBOYU5cXG4xMCAgICAgIE5hTlxcbjExICAgICAgTmFOXFxuMTIgICAgICBOYU5cXG4xMyAgICAgIE5hTlxcbjE0ICAgICAgTmFOXFxuMTUgICAgICBOYU5cXG4xNiAgICBRMTAuNFxcbjE3ICAgICAgTmFOXFxuMTggICAgICBOYU5cXG4xOSAgICAgIE5hTlxcbjIwICAgICAgTmFOXFxuMjEgICAgICBOYU5cXG4yMiAgICAgIE5hTlxcbjIzICAgIFMxNi43XFxuMjQgICAgICBOYU5cXG4yNSAgICAgIE5hTlxcbjI2ICAgICAgTmFOXFxuMjcgICAgICBOYU5cXG4yOCAgICAgIE5hTlxcbjI5ICAgICAxNC41XFxuMzAgICAgIDE0LjNcXG4zMSAgICAgIE5hTlxcbjMyICAgICAgTmFOXFxuMzMgICAgMTQuNlBcXG4zNCAgICAgIE5hTlxcbjM1ICAgICAgTmFOXFxuMzYgICAgICBOYU5cXG5OYW1lOiBkZXByZXNzaW9uX2FkdWx0LCBkdHlwZTogb2JqZWMnIiwgJ29jY3VycmVkIGF0IGluZGV4IGRlcHJlc3Npb25fYWR1bHQnKQoK