Pandas DEPR: NDFrame.bool

We recently deprecated Series.__int__ and Series.__float__, let's do NFrame.bool too.

xref #32923

Comment From: phofl

+1

This is funny, @rhshadrach and I talked about this while answering questions for the AMA yesterday :)

Comment From: MarcoGorelli

yes, please

then we can get rid of the confusing bool_t in that file as well 😄

Comment From: topper-123

+1

Comment From: jorisvandenbossche

+1

Comment From: jorisvandenbossche

For Series.bool, we can point to Series.item() as an alternative. The main difference is that item() will just in general give you the scalar value (if Series is length 1), while bool() will only do that if it's actually a boolean.