ENH: add DataFrame.is_unique method
Currently, to see columns with unique values, we have to do `df.apply(lambda x: x.is_unique)`, which is a bit awkward.

IMO checking for unique columns in a DataFrame is a common enough need to justify a method for that specific purpose.

Xref: #11948