Run Linear Regression for parts of data based on distinct values in a column

[PoojaPrasadUTD]

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

[AngelosPachis]

Hi @PoojaPrasadUTD ,

I would suggest creating a batch macro for that task, using the "City" field as control parameter.