Why any(0) does not work here?

[scidam]

By default [] (__getitem__) operation applied by rows (when the argument is boolean array). You can use loc,e.g.

data.loc[:, (np.abs(data) > 2).any(0)]