w3resource

Pandas Practice Set-1: Create a new 'Quality -color' Series of the diamonds DataFrame

Pandas Practice Set-1: Exercise-4 with Solution

Write a Pandas program to create a new 'Quality -color' Series (use bracket notation to define the Series name) 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(diamonds['carat'])
diamonds['Quality–color'] = diamonds.cut + ', ' + diamonds.color
print(diamonds.head())

Sample Output:

   carat      cut color clarity      ...           x     y     z  Quality–color
0   0.23    Ideal     E     SI2      ...        3.95  3.98  2.43       Ideal, E
1   0.21  Premium     E     SI1      ...        3.89  3.84  2.31     Premium, E
2   0.23     Good     E     VS1      ...        4.05  4.07  2.31        Good, E
3   0.29  Premium     I     VS2      ...        4.20  4.23  2.63     Premium, I
4   0.31     Good     J     SI2      ...        4.34  4.35  2.75        Good, J

[5 rows x 11 columns]

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to select a series from a DataFrame. Print the content of the series.
Next: Write a Pandas program to find the number of rows and columns and data type of each column of diamonds Dataframe.

What is the difficulty level of this exercise?



Become a Patron!

Follow us on Facebook and Twitter for latest update.

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-4.php