Pandas replace with blanks

Asked Aug 13 '19 at 13:21

Active Aug 13 '19 at 13:24

Viewed 17 times

I have a dataframe that I read in from an excel using pandas.read_excel. One of the columns has numbers but in excel it shows as text, and the null values have a . in them. I need to cast it to a float in pandas, but first need to replace the . with a blank or else it cannot cast to a float. I try:

df['EMP_NUM']=np.where(df['EMP_NUM'] == '.','', df['EMP_NUM'])

I get:

TypeError: invalid type comparison

asked Aug 13 '19 at 13:21

Victor

16,609
71
229
409

1

`df['EMP_NUM'] = df['EMP_NUM'].str.replace('.', '')`? – Erfan Aug 13 '19 at 13:24
1

maybe you can pass `thousands='.'` to `read_excel`. – Quang Hoang Aug 13 '19 at 13:25
1

Yes, what @QuangHoang suggests is even better: `df = pd.read_excel('filename.xlsx', thousands='.')` – Erfan Aug 13 '19 at 13:26
principe similar, so closed like dupe. I suggest use `thousands` parameter too. – jezrael Aug 13 '19 at 13:28

Pandas replace with blanks

0 Answers0