试用软件

How to convert categorical data to double with unique rows

3 次查看（过去 30 天）

显示更早的评论

Deborah Johnson 2023-1-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1897265-how-to-convert-categorical-data-to-double-with-unique-rows

评论： Deborah Johnson 2023-1-19

采纳的回答： David Hill

Book1.xlsx

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'

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

David Hill 2023-1-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1897265-how-to-convert-categorical-data-to-double-with-unique-rows#answer_1152325

编辑：David Hill 2023-1-19

在 MATLAB Online 中打开

Book1.xlsx

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Deborah Johnson 2023-1-19

I did it in Excel but wanted to learn an easy way in MATLAB. Thanks!

请先登录，再进行评论。

更多回答（0 个）

请先登录，再回答此问题。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

MATLAB

版本

R2022b

Community Treasure Hunt

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

Translated by

试用软件