w3resource

Pandas Datetime: Check the empty values of UFO Dataframe


19. Check Missing Values in UFO DataFrame

Write a Pandas program to check the empty values of UFO (unidentified flying object) Dataframe.

Sample Solution:

Python Code:

import pandas as pd
df = pd.read_csv(r'ufo.csv')
print(df.isnull().sum())

Sample Output:

Date_time                          0
city                               0
state/province                     0
country                            0
UFO_shape                          0
length_of_encounter_seconds        0
described_duration_of_encounter    0
description                        0
date_documented                    0
latitude                           0
longitude                          0
dtype: int64

For more Practice: Solve these Related Problems:

  • Write a Pandas program to verify the presence of empty values in the UFO dataset and display the result as a boolean DataFrame.
  • Write a Pandas program to count the number of missing entries in the UFO DataFrame and print a summary.
  • Write a Pandas program to use isnull() to check for empty values in the UFO dataset and then display columns with missing data.
  • Write a Pandas program to create a concise report of missing value statistics for the entire UFO DataFrame.

Go to:


PREV : Graphical Analysis of UFO Sightings by Year.
NEXT : Plot Distribution of UFO Observation Time.

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.