RE: Altair personal slc add a columm called date containing the last day of the previous month
Too long to post in listserv, see github
github
https://github.com/rogerjdeangelis/utl-altair-personal-slc-add-a-columm-called-date-containing-the-last-day-of-the-previous-month
I received an excel workbook today, 2025-11-01, and I need to add a column called last_day_prev_month that contains the last
day of the previous month, 2025-10-31.
Although you can update an excel sheet inplace using SAS, Python or R, I suggest you add a new sheet with the last_day_prev_month.added.
R and Python also have the ability to preserve styles, even read formats and excel color coding.
community.altair
https://community.altair.com/discussion/24183
