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:


Previous: Write a Pandas program to create a graphical analysis of UFO (unidentified flying object) Sightings year.
Next: Write a Pandas program to create a plot of distribution of UFO (unidentified flying object) 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.