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.

Python Code Editor:

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

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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.