The error is pretty clear. you are trying to replace characters in a float. x probably is a float. you might want to do str(x) which gets you

Copyf["text"] = [str(x).replace(':',' ') for x in df["text"]]

but i can't see a situation where a float contains a :

In pandas the object type is used when there is not a clear distinction between the types stored in the column.

So, I guess that in your column, some objects are float type and some objects are str type. Or maybe, you are also dealing with NaN objects, NaN objects are float objects.

a) Convert the column to string: Are you getting your DataFrame from a CSV or XLS format file? Then at the moment of reading the file, you can specify that that column is an str type or just make the type conversion of the column you are dealing with.

b) After that, you can apply the string changes and/or deal with the NaN objects.

c) Finally, you transform your column into float type`.

Well, I don't know how "smart" this is, but I "fixed" it like this, at least for the time being:

df.idh = df.idh.astype(str).apply(locale.atof)

Please, do let me know the smart answer to this.

Two things to fix:

First, when you apply a lambda function to a pandas Series, the lambda function is applied to each element of the Series. What I think you need is to apply your function to the entire Series in a vectorized manner.

Second, your function has multiple return statements. As a result, only the first statement, return source.replace('[^A-Za-z]',' '), will ever run. What you need to do is make your preprocessing changes on the variable source inside your function, and finally return the modified source (or an intermediate variable) at the very end.

To rewrite your function to operate on an entire pandas Series, replace every occurrence of source. with source.str.. The new function definition:

def data_preprocessing(source):
    source = source.str.replace('[^A-Za-z]',' ')
    #data['description'] = data['description'].str.replace('\W+',' ')
    source = source.str.lower()
    source = source.str.replace("\s\s+" , " ")
    source = source.str.replace('\s+[a-z]{1,2}(?!\S)',' ')
    source = source.str.replace("\s\s+" , " ")
    return source

Then, instead of this:

data['description'] = data['description'].apply(lambda row: data_preprocessing(row))
data['event_name'] = data['event_name'].apply(lambda row: data_preprocessing(row))

Try this:

data['description'] = data_preprocessing(data['description'])
data['event_name'] = data_preprocessing(data['event_name'])

Try this instead,

  print(
"{:.3f}% {} ({} sentences)".format(pcent, gender, nsents)
)

Refer the latest docs for more examples and check the Py version!

I just go to install_egg_info.py and modify this line as:

version = str(version).replace(' ','.')

Then, rerun the install command again and it works.