Extracting text frequency to compare large datasets

2019 6 13
1 个回答
更新时间：2019 6 14
3 次查看（30 天）

0 个投票

Please can you help me to extract the frequency at which each port receives each gear type. The data set is huge, so I need MATLAB to read through and give results for the frequency of Appledoor "Pots and Traps", for example, so that can then be compared with Appledoor "Demersal trawl/seine" or Arbroath "Pots and traps" if needed. They are currently in two columns in an Excel workbook.
Port of Landing Gear Category
Appledore Pots and traps
Appledore Pots and traps
Arbroath Demersal trawl/seine
Arbroath Pots and traps
Arbroath Pots and traps
Arbroath Demersal trawl/seine
Ardglass Demersal trawl/seine
Ardglass Demersal trawl/seine
Ardglass Demersal trawl/seine
Ardglass Pots and traps
Ardglass Pots and traps
Aberdaran Pots and traps
Aberdaran Pots and traps
Aberdeen Pots and traps

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

回答（1 个）

Image Analyst
Image Analyst 2019-6-14

0 个投票

Try histogram2():
clc; % Clear the command window.
close all; % Close all figures (except those of imtool.)
clear; % Erase all existing variables. Or clearvars if you want.
workspace; % Make sure the workspace panel is showing.
format short g;
format compact;
fontSize = 20;
ca = {...
'Appledore' 'Pots and traps'; ...
'Appledore' 'Pots and traps'; ...
'Arbroath' 'Demersal trawl/seine'; ...
'Arbroath' 'Pots and traps'; ...
'Arbroath' 'Pots and traps'; ...
'Arbroath' 'Demersal trawl/seine'; ...
'Ardglass' 'Demersal trawl/seine'; ...
'Ardglass' 'Demersal trawl/seine'; ...
'Ardglass' 'Demersal trawl/seine'; ...
'Ardglass' 'Pots and traps'; ...
'Ardglass' 'Pots and traps'; ...
'Aberdaran' 'Pots and traps'; ...
'Aberdaran' 'Pots and traps'; ...
'Aberdeen' 'Pots and traps'}
ports = ca(:, 1)
gear = ca(:, 2)
[portGroups, portNames] = findgroups(ports)
[gearGroups, gearNames] = findgroups(gear)
h = histogram2(portGroups, gearGroups)
xticks(unique(portGroups));
yticks(unique(gearGroups));
zticks(1:max(h.BinCounts(:)))
xticklabels(portNames);
yticklabels(gearNames);
xlabel('Port', 'FontSize', fontSize)
ylabel('Gear', 'FontSize', fontSize);
0000 Screenshot.png

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Amelia Newman
Amelia Newman 2019-6-14
Thank you for your help.
I was hoping to extract number comparison, something like:
'Appledoor = 2 pots and traps, 0 Demersal trawl/seine'
'Arbroath = 2 pots and traps, 2 Demersal trawl/seine'
As the dataset is huge!

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by