I have a sample raster of my area which is unclassified, and I have a MS-Excel file with the first column for the day of the year and the second column showing the corresponding daily value in %. This % value will vary from day to day, hence for 365 days, I will have 365 rows for each day & its respective % value. Normally, I would use the Reclassify tool in ArcGIS to manually define the breaks (by referring to the MS-Excel %value column) for instance-Please note that the old values column in the screen-shot were taken from the MS-Excel file % value column for that particular day:
Thus, for each day in a year, I will have to do this manually in ArcGIS, so is there a way to automate this in R (maybe the raster package!) or in Python? Please note that the Excel file is not gridded!
UPDATE The % values of each day will vary from each other, so in the script (R or Python), I will have to manually enter the ranges using a loop and If-else for each day. Basically, New values 1 i.e.Old values 0-39 remain constant for each day, so this break value of 39 will stay the same for each day. It is the New values 2 that change in accordance with the % value in the Excel file (96% for the day seen in the screenshot) of that day. And, New value 3 is the remainder %. But, If I could read the MS-Excel file into the script that basically would automate the break values for New values 2. I hope this further clarifies the question!