Replacing "." in columns

[donnertrud]

Hi guys,

I got a data set with missing values, however, those cells contain a "." instead of being empty. Here is an example :



I want to resample the data to weeks with

df = df.resample('1W').mean()

But this gives me the error :
DataError: No numeric types to aggregate

I guess I have to replace the cells, but I don't know with what and moreover, I do know how replace the string "." in the column, but this will also replace the other already existing values. I appreciate any help!

Edit : I tried the following :

for i in range(len(df5["x"])):
    if df5["x"][i].isnumeric() is False:
        df5["x"][i] = df5["x][i].replace(".","")
    else:
        pass

But this still replaces all "."

[warnerarc]

This is due to the way GroupBy objects handle the different aggregation methods. In fact sum and mean are handled differently. GroupBy.mean dispatches to self._cython_agg_general which checks for numeric types and in case it doesn't find any it raises a DataError.