How to remove the year from a datetime table column
조회 수: 36 (최근 30일)
이전 댓글 표시
I have a datetime table with
'01-Oct-2014'
'02-Oct-2014'
'03-Oct-2014'
'04-Oct-2014'
'05-Oct-2014'
and I would like to get the same table (or an additional column in that table) but with day-month only for each row
댓글 수: 7
Dyuman Joshi
2023년 9월 18일
이동: Dyuman Joshi
2023년 9월 20일
How about this?
%Data
y = datetime(["01-Oct-2014";
"02-Oct-2014"
"03-Oct-2014"
"04-Oct-2014"
"05-Oct-2014"])
%Get the day
d = day(y)
%Get the month, with the name in short form
m = month(y,'shortname')
%Single Quotation marks gives cell array
%Double Quotation marks gives string array
z = compose("%d-%s", d, string(m))
채택된 답변
Star Strider
2023년 9월 18일
편집: Star Strider
2023년 9월 18일
EDIT — (18 Sep 2023 at 23:08)
Here is an example that also includes a scatter plot —
DT = datetime(['01-Oct-2014'
'02-Oct-2014'
'03-Oct-2014'
'04-Oct-2014'
'05-Oct-2018'
'01-Oct-2018'
'02-Oct-2018'
'03-Oct-2018'
'04-Oct-2018'
'05-Oct-2018']);
T1 = table(DT,randn(size(DT))+[zeros(5,1);4*ones(5,1)])
[y,m,d] = ymd(DT); % Date Components
ix = findgroups(m, d); % Indices Of Months & Days
scattery = accumarray(ix, T1{:,2}, [], @(x){x}); % Accumulate 'Var2' Values By Day & Month
mc = month(DT,'shortname');
% compose('%s-%02d',string(mc),day(DT))
x = unique(compose('%s-%02d',string(mc),day(DT)),'stable');
dtx = datetime(x,'InputFormat','MMM-dd');
y = cell2mat(scattery.'); % Convert Cell Array To Numeric Array & Transpose
figure
scatter(dtx, y(1,:), 's', 'filled', 'DisplayName','2014')
hold on
scatter(dtx, y(2,:), 's', 'filled', 'DisplayName','2018')
hold off
grid
legend('Location','best')
I am not certain what you want to do.
.
댓글 수: 2
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Time Series Events에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!