How to replace value in entire column in Pandas?

How to replace all values in a column in DataFrame?

I have this DataFrame where one of the columns has a value with three periods.

The goal is to replace those periods with other values.apply(lambda x: 'a' if '.' in x else x) # Returns ValueError: Unable to convert strings to floats

How can I do this? This is my exact data frame: import pandas as pd. Df = pd. My data frame looks like this: id col1. 0 1.234 1 3.4e-6 2 5.4567 3 8.5556 If I apply lambda function on column or create a new column, then it doesn't work. Because I just want to replace all those values that has '.' for an other value.

I am still new in python and pandas but I have already spent hours trying to make it work. Can someone help me

Use Series.str'', '').replace('^', '')

id col1. 0 1.234567 0.116443
1 3.4567890 -0.

How do I change the entire column value in Pandas?

You can use DataFrame.

Apply, but first create new column by DataFrame.loc, add one row to df1, then reorder by sorting values index - because order of MultiIndex is determined by order of tuples in MultiIndex.last:
Df1 = df.index = df1.sortindex(ascending=False)
Print (df1). A B C D E. 2014-01 0.14356620 1 3 2 1 2014-01 0.14395940 4 3 1 0 2014-01-02 0.13949720 4 1 4 0 2014-01-02 0.13959940 4 2 3 2014-01-03 0.14154830 5 4 3 0 print (df.setindex, so possible solution is assign back to df1.rename:
Df1.rename(columns=, inplace=True)