# How to replace 1 column in table

15 vues (au cours des 30 derniers jours)
Cside le 2 Août 2023
Commenté : Sachin le 3 Août 2023
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 commentaireAfficher -1 commentaires plus anciensMasquer -1 commentaires plus anciens
Dyuman Joshi le 2 Août 2023

Connectez-vous pour commenter.

### 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 :
1. First find the unique values in Table B using "unique".
2. Find the count of those unique values using function "length".
3. Create a vector representation from 1 to count.
4. 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
unique_Age = 3×1
38 40 43
count_uniqueAge = length(unique_Age) % find the count of unique values
count_uniqueAge = 3
unique_ids = [1:1:count_uniqueAge] % create a vector
unique_ids = 1×3
1 2 3
dummyTableA
dummyTableA = 3×2
2 3 3 4 4 5
dummyTableA(:,1) = unique_ids; % update the value of column 1 in table A
dummyTableA
dummyTableA = 3×2
1 3 2 4 3 5
Thanks
Sachin
##### 2 commentairesAfficher AucuneMasquer Aucune
Cside le 2 Août 2023
Hi Sachin,
Thank you for your reply. I would like the first column of dummyTableA to be 38;40;43 instead, not the number of unique IDs
Sachin le 3 Août 2023
Hi Cside,
Then you can simply do :
dummyTableA(:,1) = unique_Age;

Connectez-vous pour commenter.

### Catégories

En savoir plus sur Data Preprocessing 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!

Translated by