Pandas Practice Set-1: Pass a list of data types to only describe certain types of diamonds DataFrame

Last update on September 13 2025 12:47:13 (UTC/GMT +8 hours)

25. Describe Only Certain Data Types

Write a Pandas program to pass a list of data types to only describe certain types of 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("\nList of data types to only describe certain types:")
print(diamonds.describe(include=['object', 'float64']))

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

List of data types to only describe certain types:
               carat    cut      ...                  y             z
count   53940.000000  53940      ...       53940.000000  53940.000000
unique           NaN      5      ...                NaN           NaN
top              NaN  Ideal      ...                NaN           NaN
freq             NaN  21551      ...                NaN           NaN
mean        0.797940    NaN      ...           5.734526      3.538734
std         0.474011    NaN      ...           1.142135      0.705699
min         0.200000    NaN      ...           0.000000      0.000000
25%         0.400000    NaN      ...           4.720000      2.910000
50%         0.700000    NaN      ...           5.710000      3.530000
75%         1.040000    NaN      ...           6.540000      4.040000
max         5.010000    NaN      ...          58.900000     31.800000

[11 rows x 9 columns]

For more Practice: Solve these Related Problems:

Write a Pandas program to describe only the numeric columns of the diamonds DataFrame by passing a list of data types.
Write a Pandas program to filter the diamonds DataFrame for object columns and use describe() on them.
Write a Pandas program to apply the describe() function to columns of type float in the diamonds DataFrame.
Write a Pandas program to generate summary statistics for specific data types by passing a list of types to the describe() method.

Go to:

PREV : Include Only Numeric Columns.
NEXT : Calculate Mean of Each Numeric Column.

Python Code Editor:

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