T = readtable('SED_FULL_NE.xlsx')
T = 1300×34 table
EVENT_ID CZ_NAME_STR BEGIN_LOCATION BEGIN_DATE EVENT_TYPE MAGNITUDE TOR_F_SCALE DEATHS_DIRECT INJURIES_DIRECT DAMAGE_PROPERTY_NUM DAMAGE_CROPS_NUM STATE_ABBR CZ_TIMEZONE MAGNITUDE_TYPE EPISODE_ID CZ_TYPE CZ_FIPS WFO INJURIES_INDIRECT DEATHS_INDIRECT SOURCE FLOOD_CAUSE TOR_LENGTH TOR_WIDTH BEGIN_RANGE BEGIN_AZIMUTH END_RANGE END_AZIMUTH END_LOCATION END_DATE END_TIME BEGIN_LAT BEGIN_LON END_LAT
__________ ______________________________ ______________ ___________ ___________ __________ ___________ _____________ _______________ ___________________ ________________ __________ ___________ ______________ __________ _______ _______ _______ _________________ _______________ ________________________ ___________ __________ __________ ___________ _____________ __________ ___________ ____________ ___________ ________ __________ __________ __________
5.2897e+06 {'NORTHERN FAIRFIELD (ZONE)' } {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 5 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2897e+06 {'SOUTHERN NEW LONDON (ZONE)'} {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 12 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2897e+06 {'SOUTHERN MIDDLESEX (ZONE)' } {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 11 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2897e+06 {'SOUTHERN NEW HAVEN (ZONE)' } {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 10 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2897e+06 {'SOUTHERN FAIRFIELD (ZONE)' } {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 9 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2897e+06 {'NORTHERN NEW LONDON (ZONE)'} {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 8 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2897e+06 {'NORTHERN MIDDLESEX (ZONE)' } {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 7 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2897e+06 {'NORTHERN NEW HAVEN (ZONE)' } {0×0 char} 01-Apr-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1327e+06 {'Z'} 6 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 30-Apr-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'SOUTHERN FAIRFIELD (ZONE)' } {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 9 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'SOUTHERN MIDDLESEX (ZONE)' } {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 11 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'NORTHERN NEW LONDON (ZONE)'} {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 8 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'SOUTHERN NEW HAVEN (ZONE)' } {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 10 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'NORTHERN MIDDLESEX (ZONE)' } {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 7 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'NORTHERN NEW HAVEN (ZONE)' } {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 6 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'SOUTHERN NEW LONDON (ZONE)'} {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 12 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
5.2968e+06 {'NORTHERN FAIRFIELD (ZONE)' } {0×0 char} 01-May-2002 {'Drought'} {0×0 char} {0×0 char} 0 0 0 0 {'CT'} {'EST'} {0×0 char} 1.1349e+06 {'Z'} 5 {'OKX'} 0 0 {'OTHER FEDERAL AGENCY'} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} {0×0 char} 31-May-2002 2359 {0×0 char} {0×0 char} {0×0 char}
[G,YEAR,STATE_ABBR] = findgroups(year(T.BEGIN_DATE),T.STATE_ABBR);
COUNT = accumarray(G,ones(numel(G),1));
out = table(YEAR,COUNT,STATE_ABBR) % you can SORTROWS this if required
out = 39×3 table
YEAR COUNT STATE_ABBR
____ _____ __________
2000 4 {'DE'}
2000 5 {'MD'}
2000 20 {'NJ'}
2000 11 {'PA'}
2001 20 {'DE'}
2001 26 {'MD'}
2001 85 {'ME'}
2001 60 {'NH'}
2001 94 {'NJ'}
2001 29 {'NY'}
2001 41 {'PA'}
2002 24 {'CT'}
2002 44 {'DE'}
2002 55 {'MD'}
2002 61 {'NY'}
2005 4 {'DE'}