How to Add custom Excel column values in Excel file based on conditional contents?

3 次查看（过去 30 天）
ahmed obaid
ahmed obaid 2017-4-2
回答： Andrei Bobrov 2017-4-3
Dear all
i have a large Excel file involve (1000+) countries and their states and variables ... i need to to add column in the last called (label) which involve numeric values based on column A content .. for example if column A include UK then, the values of label column is (1) for all UK rows ... and label value is (2) for all USA rows...and so on for others..
Country-name(A1) State-name(B1) ..... variables names.... (Lables)
UK WSG ....values .............. 1
USA FLO ......................... 2
UK SLE ......................... 1
PLG SEO ......................... 3
etc.. etc..
So kindly is this possible to be implement in matlab? thanks

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-4-3
T = readtable('yourdataexcel.xlsx');
[~,~,c] = unique(T(:,1),'stable');
Tout = [T,table(c,'Variablenames',{'Label'})];

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by