I am trying to drop records/ Rows in a dataframe with special characters. I have tried many things like:
df1['Day'] = df1['Day'].str.replace(r"[\"\'\|\?\=\.\@\#\*\,]", '')
df.drop(df[df.ID.str.contains(r'[^0-9a-zA-Z]')].index
But i am getting the following recurssion error.
Also, is there any way to impute the records with special characters with mean/median/mode
---------------------------------------------------------------------------
RecursionError Traceback (most recent call last)
/usr/local/lib/python3.7/dist-packages/IPython/core/formatters.py in __call__(self, obj)
697 type_pprinters=self.type_printers,
698 deferred_pprinters=self.deferred_printers)
--> 699 printer.pretty(obj)
700 printer.flush()
701 return stream.getvalue()
18 frames
... last 15 frames repeated, from the frame below ...
/usr/local/lib/python3.7/dist-packages/pandas/core/frame.py in __repr__(self)
1000 line_width=width,
1001 max_colwidth=max_colwidth,
-> 1002 show_dimensions=show_dimensions,
1003 )
1004
RecursionError: maximum recursion depth exceeded
---------------------------------------------------------------------------
RecursionError Traceback (most recent call last)
/usr/local/lib/python3.7/dist-packages/IPython/core/formatters.py in __call__(self, obj)
332 pass
333 else:
--> 334 return printer(obj)
335 # Finally look for special method names
336 method = get_real_method(obj, self.print_method)
26 frames
... last 15 frames repeated, from the frame below ...
/usr/local/lib/python3.7/dist-packages/pandas/io/formats/format.py in format_col(self, i)
823 space=self.col_space.get(frame.columns[i]),
824 decimal=self.decimal,
--> 825 leading_space=self.index,
826 )
827
RecursionError: maximum recursion depth exceeded while calling a Python object
source https://stackoverflow.com/questions/71188780/how-to-drop-records-with-special-characters-in-a-dataframe
Comments
Post a Comment