calculate the number of rows in a column that meet certain criteria (specific word and empty rows) by using Panda

Question

From data in a csv file, I try to obtain using Panda, the sum of the rows of a specific column ("Status_Issue") of the csv file that are:

• empty rows and
• rows containing the word "Pending".

Here is the code I used but unfortunately it doesn't work, can you please help me to correct my error.

def count_pending_TaxRegulatory():
df = pd.read_csv("sortdata.csv", header=1)
count1 = (df["Status_Issue"]=="Pending").sum()
count2 = df["Status_Issue"].isna().sum()
result1 = count1 + count2

Answer 1

sum() function return the sum of the values for the requested axis, so unless "Status_Issue" is only either 1 or 0 (where isna is making things 1 or 0 thus working), it won't work as you wanted. check this out Count number of rows when row contains certain text