Pandas SQL Query: Create a boolean series, where True for not null and False for null values or missing values in specified column of locations file

Last update on April 08 2025 12:48:47 (UTC/GMT +8 hours)

12. Boolean Series for Non-Null state_province Values

Write a Pandas program to create and display a boolean series, where True for not null and False for null values or missing values in state_province column of locations file.

LOCATIONS.csv

Sample Solution :

Python Code :

import pandas as pd
pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)
employees = pd.read_csv(r"EMPLOYEES.csv")
departments = pd.read_csv(r"DEPARTMENTS.csv")
job_history = pd.read_csv(r"JOB_HISTORY.csv")
jobs = pd.read_csv(r"JOBS.csv")
countries = pd.read_csv(r"COUNTRIES.csv")
regions = pd.read_csv(r"REGIONS.csv")
locations = pd.read_csv(r"LOCATIONS.csv")
print("Original data / State Province")
print(locations.state_province)
print("\n\n   State Province(Not null / Null Series")
print(locations.state_province.notnull())

Sample Output:

Original data / State Province
0                   NaN
1                   NaN
2      Tokyo Prefecture
3                   NaN
4                 Texas
5            California
6            New Jersey
7            Washington
8               Ontario
9                 Yukon
10                  NaN
11          Maharashtra
12      New South Wales
13                  NaN
14                  NaN
15               Oxford
16           Manchester
17              Bavaria
18            Sao Paulo
19               Geneve
20                   BE
21              Utrecht
22    Distrito Federal,
Name: state_province, dtype: object


   State Province(Not null / Null Series
0     False
1     False
2      True
3     False
4      True
5      True
6      True
7      True
8      True
9      True
10    False
11     True
12     True
13    False
14    False
15     True
16     True
17     True
18     True
19     True
20     True
21     True
22     True
Name: state_province, dtype: bool

Click to view the table contain:

For more Practice: Solve these Related Problems:

Write a Pandas program to create and display a boolean series for the state_province column in LOCATIONS.csv, marking True for non-null values.
Write a Pandas program to add a boolean column to LOCATIONS.csv indicating non-null state_province values and then count the True values.
Write a Pandas program to invert the boolean series for state_province and display rows where the value is null.
Write a Pandas program to create a boolean mask for state_province, then filter and display only the rows with True values.

Python Code Editor:

Structure of HR database :

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

Previous: Write a Pandas program to display the first name, last name, salary and manger id where manager ids are not null.
Next: Write a Pandas program to create a boolean series selecting rows with one or more nulls from locations file.