Trying to get a list of the different variables in a column

I am trying to create an array which displays the different types of variables i have on one of my columns labelled 'Five' in a table i have. the variables are airport names so i just need to see how many different airports i am collecting different data from. The table is added here to show what i'm working with.

The code i cuurently have is this:

clc
clear all

raw_data = readtable('n10013911.csv');
i = 1;
acronym = zeros(10,1);


for loop = acronym
    for index = raw_data(:,'Five')
        ii=1
    
        if index == acronym(ii)
            ii=ii+1;
        else
            acronym(i,1) = raw_data(ii,'Five');
            i = i + 1;
            ii=ii+1;

        end
    end
end

I'm not the best at for loops and if statements, but this one just doesnt seem to want to work

Answer 1

[Cris LaPierre]

Turn your data into categoricals, then use the categories function to list the unique categories.

Five = {'LHR';'LHR';'PEK';'SYD'};
Five = categorical(Five);
categories(Five)

ans = 3×1 cell array
    {'LHR'}
    {'PEK'}
    {'SYD'}

Another option may be to use the unique function on the data as you currently have it.

Five = {'LHR';'LHR';'PEK';'SYD'};
unique(Five)

ans = 3×1 cell array
    {'LHR'}
    {'PEK'}
    {'SYD'}

[Alice Brenton]

Thank you, both of these options worked for me, and I just went with the first way.

Answer 2

[Mathieu NOE]

hello

if I understand correctly, you want to extract the list of unique values of the "five" column and store that in an array

you can easily get this by doing :

Five_array = unique(T.Five); % assuming your table is T 

[Alice Brenton]

This one works as well, i just have to turn it into a categorical first. Thank you!

[Cris LaPierre]

Unique will also work on strings and character arrays, meaning you do not have to convert your data into a categorical first if you use this approach.