Hi,
I have following dataset format where I need to predict Price for each city using Linear Regression. How can I create a loop based on distinct values of city and run Linear Regression for each city and save the predictions in the a single table as an output.
Input data
City | Beds | Area | Price |
ABC | 2 | 3 | 100 |
ABC | 3 | 4 | 120 |
ABC | 1 | 2 | 90 |
DEF | 2 | 3 | 200 |
DEF | 3 | 4 | 220 |
DEF | 1 | 2 | 190 |
Any suggestions would be appreciated.
Thanks
Hi @PoojaPrasadUTD ,
I would suggest creating a batch macro for that task, using the "City" field as control parameter.