Lyapunov conditions for logarithmic Sobolev and Super Poincar\'e inequality