Pandas: Replace arbitrary values with other values in a given DataFrame
21. Replace Arbitrary Values
Write a Pandas program to replace arbitrary values with other values in a given DataFrame.
Sample Solution:
Python Code :
Sample Output:
Original DataFrame: company_code date_of_sale sale_amount 0 A 12/05/2002 12348.5 1 B 16/02/1999 233331.2 2 C 25/09/1998 22.5 3 D 12/02/2022 2566552.0 4 A 15/09/1997 23.0 Replace A with c: company_code date_of_sale sale_amount 0 C 12/05/2002 12348.5 1 B 16/02/1999 233331.2 2 C 25/09/1998 22.5 3 D 12/02/2022 2566552.0 4 C 15/09/1997 23.0
For more Practice: Solve these Related Problems:
- Write a Pandas program to replace specific values in a DataFrame with new ones using the replace() method.
- Write a Pandas program to update a DataFrame by replacing a set of arbitrary values with corresponding alternatives.
- Write a Pandas program to substitute certain values in a DataFrame column based on a mapping dictionary.
- Write a Pandas program to replace given values in multiple columns simultaneously using a nested replacement mapping.
Go to:
Previous:Write a Pandas program to convert a specified character column in title case in a given DataFrame.
Next: Write a Pandas program to replace more than one value with other values in a given DataFrame.
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.