tt10001 = readtable('10001.xlsx');
dsa = tt10001;
modelspec = 'Street ~ Catch*BackUp*PRCP - Catch:BackUp:Break:Manhole:PRCP';
mdl10001 = fitglm(dsa,modelspec,'Distribution','poisson')
I have multiple excel files (almost 200), such as "10001.xlsx" in a folder. The spreadsheets are of various zip codes, such as "10002.xlsx", "10003.xlsx"...
How can I run this code for every file in the folder?
And have the results "mdl10001.CoefficientCovariance" of each file exported to its own Excel spreadsheet, as in xlswrite?
Thanks. I'd very much appreciate any help with this.