The Met Office has issued a yellow weather warning for heavy rainfall and thunderstorms as we head deeper into September.