How to convert categorical data to double with unique rows

5 views (last 30 days)
Hello, please assist me with converting categorical data to double data. Would a if statement do this?
Under Vertical Steering Column, replace unique categoriacal text to a unique double value.
rows with Altitude to '0'
rows with Limbo to '6'

Accepted Answer

David Hill
David Hill on 19 Jan 2023
Edited: David Hill on 19 Jan 2023
a=readtable('Book1.xlsx');
b=zeros(size(a));
b(ismember(a.Vertical_Steering,'Limbo'))=6
b = 1045×1
0 0 0 0 0 0 0 0 0 0
  1 Comment
Deborah Johnson
Deborah Johnson on 19 Jan 2023
I did it in Excel but wanted to learn an easy way in MATLAB. Thanks!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!