Pandas: Get the information of the DataFrame including data types and memory usage

Last update on May 28 2022 13:39:24 (UTC/GMT +8 hours)

Pandas: IMDb Movies Exercise-2 with Solution

Write a Pandas program to get the information of the DataFrame (movies_metadata.csv file) including data types and memory usage.

Sample Solution:

Python Code :

import pandas as pd
df = pd.read_csv('movies_metadata.csv')
result = df.info()
print("Details of the DataFrame:")
print(result)

Sample Output:


RangeIndex: 50 entries, 0 to 49
Data columns (total 24 columns):
adult                    50 non-null bool
belongs_to_collection    10 non-null object
budget                   50 non-null int64
genres                   50 non-null object
homepage                 5 non-null object
id                       50 non-null int64
imdb_id                  50 non-null object
original_language        50 non-null object
original_title           50 non-null object
overview                 49 non-null object
popularity               50 non-null float64
poster_path              50 non-null object
production_companies     50 non-null object
production_countries     50 non-null object
release_date             50 non-null object
revenue                  50 non-null int64
runtime                  50 non-null float64
spoken_languages         50 non-null object
status                   50 non-null object
tagline                  41 non-null object
title                    50 non-null object
video                    50 non-null bool
vote_average             50 non-null float64
vote_count               50 non-null int64
dtypes: bool(2), float64(3), int64(4), object(15)
memory usage: 8.8+ KB
Details of the DataFrame:
None

Python-Pandas Code Editor:

Sample Table:

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

Previous: Write a Pandas program to get the columns of the DataFrame (movies_metadata.csv file).
Next: Write a Pandas program to get the details of the third movie of the DataFrame (movies_metadata.csv file).

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

Python: Tips of the Day

Find current directory and file's directory:

To get the full path to the directory a Python file is contained in, write this in that file:

import os 
dir_path = os.path.dirname(os.path.realpath(__file__))

(Note that the incantation above won't work if you've already used os.chdir() to change your current working directory, since the value of the __file__ constant is relative to the current working directory and is not changed by an os.chdir() call.)

To get the current working directory use

import os
cwd = os.getcwd()

Documentation references for the modules, constants and functions used above:

The os and os.path modules.
The __file__ constant
os.path.realpath(path) (returns "the canonical path of the specified filename, eliminating any symbolic links encountered in the path")
os.path.dirname(path) (returns "the directory name of pathname path")
os.getcwd() (returns "a string representing the current working directory")
os.chdir(path) ("change the current working directory to path")

Ref: https://bit.ly/3fy0R6m