Python pandas check if dataframe is not empty

Just do

if not dataframe.empty:
     # insert code here

The reason this works is because dataframe.empty returns True if dataframe is empty. To invert this, we can use the negation operator not, which flips True to False and vice-versa.

.empty returns a boolean value

>>> df_empty.empty
True

So if not empty can be written as

if not df.empty:
    #Your code

Check pandas.DataFrame.empty , might help someone.

You can use the attribute dataframe.empty to check whether it's empty or not:

if not dataframe.empty:
    #do something

Or

if len(dataframe) != 0:
   #do something

Or

if len(dataframe.index) != 0:
   #do something

As already clearly explained by other commentators, you can negate a boolean expression in Python by simply prepending the not operator, hence:

if not df.empty:
  # do something

does the trick.

I only want to clarify the meaning of "empty" in this context, because it was a bit confusing for me at first.

According to the Pandas documentation, the DataFrame.empty method returns True if any of the axes in the DataFrame are of length 0.

As a consequence, "empty" doesn't mean zero rows and zero columns, like someone might expect. A dataframe with zero rows (axis 1 is empty) but non-zero columns (axis 2 is not empty) is still considered empty:

> df = pd.DataFrame(columns=["A", "B", "C"])
> df.empty
True

Another interesting point highlighted in the documentation is a DataFrame that only contains NaNs is not considered empty.

> df = pd.DataFrame(columns=["A", "B", "C"], index=['a', 'b', 'c'])
> df
     A    B    C
a  NaN  NaN  NaN
b  NaN  NaN  NaN
c  NaN  NaN  NaN
> df.empty
False

Another way:

if dataframe.empty == False:
    #do something`