Replace string/value in entire DataFrame Replace string/value in entire DataFrame pandas pandas

Replace string/value in entire DataFrame


python replace dataframe pandas

Use replace

In [126]: df.replace(['very bad', 'bad', 'poor', 'good', 'very good'],                      [1, 2, 3, 4, 5]) Out[126]:       resp  A  B  C   0     1  3  3  4   1     2  4  3  4   2     3  5  5  5   3     4  2  3  2   4     5  1  1  1   5     6  3  4  1   6     7  4  4  4   7     8  5  5  5   8     9  2  2  1   9    10  1  1  1

python replace dataframe pandas

Considering data is your pandas DataFrame you can also use:

data.replace({'very bad': 1, 'bad': 2, 'poor': 3, 'good': 4, 'very good': 5}, inplace=True)

python replace dataframe pandas

data = data.replace(['very bad', 'bad', 'poor', 'good', 'very good'], [1, 2, 3, 4, 5])

You must state where the result should be saved. If you say only data.replace(...) it is only shown as a change in preview, not in the envirable itself.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last