Backport PR #45287 on branch 1.4.x (BUG: frame[x].loc[y] inconsistent with frame.at[x, y]) (#45287)
Backport PR #45287, see https://github.com/pandas-dev/pandas/issues/47867#issuecomment-1198412271

Lets see if this works
don't worry about the mypy failures. imo it is main that is wrong since we have traditionally always run the typing validation against the latest numpy release, which is what's happening here. Yep thx > Lets see if this works

Thanks @phofl merge when ready. Failure unrelated, see #47945