STYLE enable pylint: fix use-implicit-booleaness-not-comparison warnings
Related to [#48855](https://github.com/pandas-dev/pandas/issues/48855). Enables the Pylint type "C" warning `use-implicit-booleaness-not-comparison`

- [] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).


sorry, this duplicates https://github.com/pandas-dev/pandas/pull/49654 , and I'm not sure it's a safe one to enable in general (it's also listed as one of the ones to not turn off in the issue)

closing for now  then Ah my mistake, I thought I had searched through all the comments and didn't see this warning get addressed. Apologies for the duplication