﻿ Pandas HR database: Count the NaN values of all the columns of locations file - w3resource

# Pandas HR database: Count the NaN values of all the columns of locations file

## Pandas HR database Queries: Exercise-14 with Solution

Write a Pandas program to count the NaN values of all the columns of locations file.

Sample Solution :

Python Code :

``````import pandas as pd
pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)
print("\nNaN values of all the columns of locations file:" )
print(locations.isna().sum())
``````

Sample Output:

```NaN values of all the columns of locations file:
location_id       0
postal_code       1
city              0
state_province    6
country_id        0
dtype: int64
```

Click to view the table contain:

Employees Table

Departments Table

Countries Table

Job_History Table

Jobs Table

Locations Table

Regions Table

Python Code Editor:

Structure of HR database :

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

What is the difficulty level of this exercise?

﻿

## Python: Tips of the Day

Python: The Zip() Function

```>>> students = ('John', 'Mary', 'Mike')
>>> ages = (15, 17, 16)
>>> scores = (90, 88, 82, 17, 14)
>>> for student, age, score in zip(students, ages, scores):
...     print(f'{student}, age: {age}, score: {score}')
...
John, age: 15, score: 90
Mary, age: 17, score: 88
Mike, age: 16, score: 82
>>> zipped = zip(students, ages, scores)
>>> a, b, c = zip(*zipped)
>>> print(b)
(15, 17, 16)
```