I see Vaex as a last resort when the data is too big to be processed with pandas. There is a tradeoff as all pandas functions are not supported by Vaex like the median is calculated as an approximation.