Extract two frist numbers form a column

2 次查看（过去 30 天）
Amina Ag
Amina Ag 2021-5-26
评论： Amina Ag 2021-5-27
Hi,
I have a column with 400 000 variables that look something like this:
68.092
67.011
76.949
etc.
I would like to extract the two first numbers into a new column such that I get a column that looks like this:
68
67
76
If it matters, the column is categorical.

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

回答（2 个）

KSSV
KSSV 2021-5-26
A = [68.092
67.011
76.949] ;
integ = floor(A);
fract = A-integ;
  1 个评论
Amina Ag
Amina Ag 2021-5-27
Thank you for your reply! Unfortunately the floor function only returns me NaNs.

请先登录，再进行评论。

EmirBeg
EmirBeg 2021-5-26
编辑：EmirBeg 2021-5-26
If it's categorical you need to convert it to doubles first.
A = categorical([68.092; 67.011; 76.949]); %Creating your categorical Array.
B = double(string(A)); %Converting and shortening it.
B = floor(B);
B =
68
67
76
Hope it works. Pozdrav.
  1 个评论
Amina Ag
Amina Ag 2021-5-27
Hi Emir,
Thank you for your reply. Converting to double only returnes me NaNs and therefore the floor function does not work either. I managed to do it in another program though but highly appreciate your time and response.
Hvala puno! Pozdrav.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by