CLN: correct in and not in

Also added tests for nan in and not in and disallowed ops like

    pd.eval('1 or 2')

since that should be performed in regular Python