MATLAB Answers

how to arrenge timeseries data ?

1 view (last 30 days)
pruth
pruth on 26 Nov 2017
Answered: KL on 26 Nov 2017
hi. I have created a mat file(attached). Here first column is date and second column is data.
dates here are poorly arranged.like as follow.
01-Apr-2012
01-Apr-2013
01-Apr-2014
01-Apr-2015
01-Apr-2016
.
.
.
.
01-Jul-2013
01-Jul-2014
01-Jul-2015
01-Jul-2016
01-Jun-2012
01-Jun-2013
01-Jun-2014
01-Jun-2015
01-Jun-2016
01-Mar-2012
01-Mar-2013
.
.
.
01-Oct-2014
01-Oct-2015
01-Sep-2012
01-Sep-2013
01-Sep-2014
01-Sep-2015
I want here data monthly arranged from Jan to December, from 2012 to 2015. any idea how to make it possible.? hope you understand.

Accepted Answer

KL
KL on 26 Nov 2017
use sort?
[~,indx] = sort(data(:,1));
sortedData = data(indx,:);

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!