I'm reading and processing on a cron job a daily spreadsheet from the state of Texas tracking COVID vaccination data. I'm having issues because some columns tend to come and go, which rename does not like. For example, I have this statement:
readxl::read_excel(Vaccine_path, sheet=2) %>%
rename(County="County Name",
Region="Public Health Region (PHR)",
Doses_Alloc="Total Doses Allocated",
Doses_Admin="Vaccine Doses Administered",
People_one_dose="People Vaccinated with at least One Dose",
People_fully="People Fully Vaccinated")
which works fine except when for a few random days the Allocated Doses column disappeared.
Suggestions on the cleanest way to deal with this inconsistent behavior in an automatic job?