write number next to each other + return value 0/1

Hello,

i have a tablehave imported from Excel.

In the ID column I want the values ​​from hod + min + s + CasVSekundach but as text so that it doesn't add up for me (T.ID = (T.hod) + (T.min) + (T.s). It should look like in the first column: not 25 but 002525(h/min/s/CasVSekundach).

And I want to create a new column (ID_H), where the distance from the column according to criterion> 5 returns 0 and if = <5 returns 1

I try ID_H=(ID(ID>5)=1), but it doesn´t works...

Thank you for any help.

[ILoveMATLAB]

For your first question.

1. Convert each column of intrest to an array of strings. sCol1 =strings(T.hod)
2. Concatenate all the strings arrays using the + operator T.ID = sCol1 + sCol2+ sCol3

For your second question

ID_H = double(ID>5);

Answer 1

[Jon]

Let us say your table is called T, then you can use:

T.ID =  string(T.hod) + string(T.min) + string(T.s) + string(CasVSekundach)

[Zuzana Pániková]

Thanks you for your answer.

With hod,min and s works but with CasVSekundach deosn´t. CasVSekundach i created in matlab.

[Walter Roberson]

What shows up for

whos CasVSekundach T

[Jon]

I'm not sure what you mean by " but with CasVSekundach deosn´t."

Please attach files to allow me to recreate the issue and explain further exactly what output you want and what errors or problems you are still having

[Zuzana Pániková]

I=imread(´vzorovymat.mat´)

imshow(I)

works it?

[Jon]

Sorry, I don't understand

[Stephen23]

S = load('vzorvymat.mat')

S = struct with fields:
       T: [12645×9 table]
    x3_5: [12645×7 table]

It is unclear why you want to IMREAD() a .mat file, or what you expect IMSHOW() to do with table data.

[Zuzana Pániková]

Sorry, I didn't understand the principle of the example attachment here on the site.

[Zuzana Pániková]

T.ID = string(T.hod) + string(T.min) + string(T.s)+(T.CasVSekundach)

I got it, I'm slow. Thanks a lot for your help.

Answer 2

[ILoveMATLAB]

(Forgot to submit as an anwser)

For your first question.

1. Convert each column of interest to an array of strings. sCol1 =strings(T.hod)
2. Concatenate all the strings arrays using the + operator T.ID = sCol1 + sCol2+ sCol3

For your second question

ID_H = double(ID>5);

[Zuzana Pániková]

Thank you for your answer, but i try it and matlab writed: Size vector should be a row vector with real elements.

by second: T.ID_H = double(odstup>5);

Unrecognized function or variable 'odstup'.

after i try: O=T(:,"odstup")

T.ID_H = double(O>5)

Operator '>' is not supported for operands of type 'table'.

[ILoveMATLAB]

I don't understand what your doing. What is odstup? You need to define the odstup variable.

%Try this
ID_H = double(T.ID>5);

%Or this
ID = T.ID
ID_H = double(ID>5);

[Walter Roberson]

O = T.odstup

[Zuzana Pániková]

Thank you,now it works