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.

Python Code Editor:

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

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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.