Localization in Periodic Potentials. From Schrödinger operators to the Gross-Pitaevskii equationPrévenez-moi