w3resource

Pandas Practice Set-1: Print a concise summary of diamonds DataFrame


59. Print Concise Summary of Diamonds DataFrame

Write a Pandas program to print a concise summary 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("\nConcise summary of diamonds DataFrame:")
print(diamonds.info())

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

Concise summary of diamonds DataFrame:
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 53940 entries, 0 to 53939
Data columns (total 10 columns):
carat      53940 non-null float64
cut        53940 non-null object
color      53940 non-null object
clarity    53940 non-null object
depth      53940 non-null float64
table      53940 non-null float64
price      53940 non-null int64
x          53940 non-null float64
y          53940 non-null float64
z          53940 non-null float64
dtypes: float64(6), int64(1), object(3)
memory usage: 4.1+ MB
None

For more Practice: Solve these Related Problems:

  • Write a Pandas program to display a concise summary of the diamonds DataFrame using the info() method.
  • Write a Pandas program to print the memory usage, data types, and non-null counts of the diamonds DataFrame.
  • Write a Pandas program to generate and print a concise summary of the diamonds dataset that highlights column-wise details.
  • Write a Pandas program to display a summary report of the diamonds DataFrame and then export the summary to a text file.

Go to:


Previous: Write a Pandas program to read rows 2 through 5 (inclusive), columns in positions 0 through 2 (exclusive) of diamonds DataFrame.
Next: Write a Pandas program to get the true memory usage by 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.