Pandas Practice Set-1: Rename two of the columns of the diamonds Dataframe
Pandas Practice Set-1: Exercise-7 with Solution
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]
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
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.
What is the difficulty level of this exercise?
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://w3resource.com/python-exercises/pandas/practice-set1/pandas-practice-set1-exercise-7.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics