Need to create a script to find the longest period of rainy days and sunny days
So I have this database with precipitation data from 06-24-2009 to 04/26/2024.
I need a script to find the longest period of consecutive days without rain (precipitation = 0) and the longest period of consecutive days with rain (precipitation ≠ 0). I also need the script to tell the days the period starts and ends. How can I solve this exercise?