w3resource

Pandas Practice Set-1: Summarize only 'object' columns of the diamonds Dataframe


6. Summarize Only 'Object' Columns

Write a Pandas program to summarize only 'object' 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("Summarize of 'object' columns:")
print(diamonds.describe(include=['object']))

Sample Output:

Summarize of 'object' columns:
          cut  color clarity
count   53940  53940   53940
unique      5      7       8
top     Ideal      G     SI1
freq    21551  11292   13065

For more Practice: Solve these Related Problems:

  • Write a Pandas program to display descriptive statistics for all object-type columns in the diamonds DataFrame.
  • Write a Pandas program to filter the diamonds DataFrame to only object columns and summarize their unique values and counts.
  • Write a Pandas program to generate a summary of the object columns including count, unique, top, and frequency.
  • Write a Pandas program to isolate object columns from the diamonds DataFrame and print their info and descriptive statistics.

Go to:


Previous: Write a Pandas program to find the number of rows and columns and data type of each column of diamonds Dataframe.
Next: Write a Pandas program to rename two of 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.