linear regression with categorical independent variable

Ela597

Hey, I am trying to run a linear regression with my independent variable being a categorical. I used one hot encoding to make binary fields. But when I try the linear regression I get these 8 errors (see picture) : 

I've tried changing the data type from bool to string, and I converted every 'False' to 0 but nothing seems to work.

How can I solve this?

Capture.PNG

lin regression.yxmd

mceleavey

Hi @Ela597 ,

I've applied a few changes to the data by amending the boolean type to int16, and splitting out a test and train with only one record.

This allows the model to run correctly, but what I would say is you don't have enough variation in your data, and the data variation is fairly uniform. You also don't really have enough data to inform a particularly in-depth linear regression.

Anyway, I've attached the workflow and this is running now.

I hope this helps.

M.

lin regression (2).yxmd