w3resource

Pandas Practice Set-1: Rename two of the columns of the diamonds Dataframe


7. Rename Two Columns

Write a Pandas program to rename two of the columns of the diamonds Dataframe.

Sample Solution :

Python Code :

import pandas as pd
diamonds = pd.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/diamonds.csv')
print("Original Dataframe:")
print(diamonds.head())
print("\nAfter renaming two of the columns of the said dataframe:")
diamonds.rename(columns={'color':'diamond_color', 'clarity':'dimaond_clarity'}, inplace=True)
print(diamonds.head())

Sample Output:

Original Dataframe:
   carat      cut color clarity  depth  table  price     x     y     z
0   0.23    Ideal     E     SI2   61.5   55.0    326  3.95  3.98  2.43
1   0.21  Premium     E     SI1   59.8   61.0    326  3.89  3.84  2.31
2   0.23     Good     E     VS1   56.9   65.0    327  4.05  4.07  2.31
3   0.29  Premium     I     VS2   62.4   58.0    334  4.20  4.23  2.63
4   0.31     Good     J     SI2   63.3   58.0    335  4.34  4.35  2.75

After renaming two of the columns of the said dataframe:
   carat      cut diamond_color dimaond_clarity  ...   price     x     y     z
0   0.23    Ideal             E             SI2  ...     326  3.95  3.98  2.43
1   0.21  Premium             E             SI1  ...     326  3.89  3.84  2.31
2   0.23     Good             E             VS1  ...     327  4.05  4.07  2.31
3   0.29  Premium             I             VS2  ...     334  4.20  4.23  2.63
4   0.31     Good             J             SI2  ...     335  4.34  4.35  2.75

[5 rows x 10 columns]

For more Practice: Solve these Related Problems:

  • Write a Pandas program to rename two specified columns in the diamonds DataFrame using the rename() function.
  • Write a Pandas program to update the names of the 'cut' and 'color' columns and display the DataFrame head.
  • Write a Pandas program to rename two columns by passing a dictionary to the rename() method and verify the change.
  • Write a Pandas program to rename columns 'x' and 'y' in the diamonds DataFrame and then print the new column names.

Go to:


Previous: Write a Pandas program to summarize only 'object' columns of the diamonds Dataframe.
Next: Write a Pandas program to rename all the columns of the diamonds 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?



Follow us on Facebook and Twitter for latest update.