I have a csv file. The column name is balance and I want to remove the '$' sign from this column. How can I do that?
I have a csv file. The column name is balance and I want to remove the '$' sign from this column. How can I do that?
You can do it like this in Python:
data["balance"] = data["balance"].apply(lambda x:float(x[-1:]))