I have a database consisting of three tables like this: I want to make a machine learning model in R using that database, and the data I need is like this: I can use one hot encoding to convert categorical variable from t_pengolahan (such as “Pengupasan, Fermentasi, etc”) into attributes. But, how…
Tag: one-hot-encoding
Transform table to one-hot encoding for many rows
I have a SQL table of the following format: ID Cat 1 A 1 B 1 D 1 F 2 B 2 C 2 D 3 A 3 F Now, I want to create a table with one ID per row, and multiple Cat’s in a row. My …