Extract two frist numbers form a column

2 visualizaciones (últimos 30 días)
Amina Ag
Amina Ag el 26 de Mayo de 2021
Comentada: Amina Ag el 27 de Mayo de 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.

Respuestas (2)

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

Iniciar sesión para comentar.


EmirBeg
EmirBeg el 26 de Mayo de 2021
Editada: EmirBeg el 26 de Mayo de 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 comentario
Amina Ag
Amina Ag el 27 de Mayo de 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.

Iniciar sesión para comentar.

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by