How to find blank cells in excel using pandas?

if your cell in excel is totally empty then print the Array variable will output a 'nan'. so if it contains nan then check:

import pandas as pd

if pd.isnull(Array):

if the above one is not working then there might be spaces, so try:

if Array.strip() == "":

Try using isnan() function from numpy library

import numpy as np

for Array in LastName:
    if np.isnan(Array):
        print('Cell is empty')

Based on the comments, OP wants to drop rows if there's empty cell (i.e. NaN in pandas).

Using modified version from OP's sample data (Note I added last row where column A has empty cell, too):

print(df)
       A          B
0  Name1  LastName1
1  Name2        
2  Name3  LastName3
3  Name4  LastName4
4         LastName5

Using df.dropna() will drop any row if any corresponding column has empty cell:

       A          B
0  Name1  LastName1
2  Name3  LastName3 <<< row 1 is dropped 
3  Name4  LastName4 <<< row 4 is dropped

Using df.dropna(subset=['B']) will drop only if column B has empty cell:

       A          B
0  Name1  LastName1
2  Name3  LastName3 <<< row 1 is dropped since (2, 'B') was empty
3  Name4  LastName4
4    NaN  LastName5 <<< row 4 is not dropped since dropna is only looking at 'B'