How to convert categorical data to double with unique rows

4 visualizzazioni (ultimi 30 giorni)
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'

Risposta accettata

David Hill
David Hill il 19 Gen 2023
Modificato: David Hill il 19 Gen 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 Commento
Deborah Johnson
Deborah Johnson il 19 Gen 2023
I did it in Excel but wanted to learn an easy way in MATLAB. Thanks!

Accedi per commentare.

Più risposte (0)

Prodotti


Release

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by