Pandas: "ValueError: could not convert string to float: " (empty string)

Question

When trying to convert a Pandas Series to float, I get this error message. It refers to an empty string (" "), which is not a np.nan. Just an empty string.

I tried replacing " " by np.nan, but it doesn't do anything. I also tried replacing " " by "" but it also doesn't do anything.

import pandas as pd
import numpy as np

df = pd.DataFrame(np.array([[1, 2, 3], [4, " ", 6], [7, 8, 9]]), 
                  columns=['a', 'b', 'c'])

df.astype(float)

ValueError: could not convert string to float:

I want to replace these " " by NaN values, in a large dataframe.

What float value are you expecting for `" "` ? – May 16 '19 at 14:53 — , May 16 '19 at 14:53
`df.apply(pd.to_numeric, args=('coerce',))` – VnC May 16 '19 at 14:59 — VnC, May 16 '19 at 14:59

score 3 · Accepted Answer · answered May 16 '19 at 14:54

3

You can use df.replace() function to perform this operation

df.replace(r'^\s*$', np.nan, regex=True)

answered May 16 '19 at 14:54

Asnim P Ansari

1,932
1
18
41

Pandas: "ValueError: could not convert string to float: " (empty string)

1 Answers1