MATLAB Answers

Extract two frist numbers form a column

1 view (last 30 days)
Amina Ag
Amina Ag on 26 May 2021
Commented: Amina Ag on 27 May 2021
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.

Answers (2)

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

Sign in to comment.


EmirBeg
EmirBeg on 26 May 2021
Edited: EmirBeg on 26 May 2021
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 Comment
Amina Ag
Amina Ag on 27 May 2021
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.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!