How to replace 1 column in table
22 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello!
I have a NaN table (100x200), lets call it A, and a large dataset with first column being participants ID (eg 123AJH), lets call this B. I want to find the unique participant ID in B (:,1) (eg there are 100 unique IDs as many of them are repeated) and replace the unique IDs as the first column of A. However, the result is 1,2,...100 (the number of unique ID) rather than the ID itself (123AJH).
Anyone knows how to replace 1st column of A with the column of unique IDs found in B (123AJH; 232AJH, ...) ?
Much appreciated thank you. The code I wrote is below:
A (:,1) = unique (B(:,1));
1 commentaire
Réponses (1)
Sachin
le 2 Août 2023
Hi Cside,
I understand that you want to replace 1 column in table.
Following steps might be helpful to you :
- First find the unique values in Table B using "unique".
- Find the count of those unique values using function "length".
- Create a vector representation from 1 to count.
- Then assign the values to the Table A.
dummyTableA = [2,3;3,4;4,5]; %dummy table a
Age = [38;43;38;40;38];
unique_Age = unique(Age) % find the unique values
count_uniqueAge = length(unique_Age) % find the count of unique values
unique_ids = [1:1:count_uniqueAge] % create a vector
dummyTableA
dummyTableA(:,1) = unique_ids; % update the value of column 1 in table A
dummyTableA
You can refer the following MATLAB Documentations for more information about above functions :
Thanks
Sachin
2 commentaires
Sachin
le 3 Août 2023
Hi Cside,
Then you can simply do :
dummyTableA(:,1) = unique_Age;
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!