Arrange data of an array in certain order.

3 ビュー (過去 30 日間)
arifahazwani AY
arifahazwani AY 2020 年 3 月 12 日
回答済み: Piyush Lakhani 2020 年 3 月 12 日
Hi, currently I have a datasheet in alphabetic order (3 column X, Y and Z for each variable). how I want to rearrange the datasheet in certain specific order.?
Attached herewith the txt.file and xlsx.file.
The order in the datasheet is
C1, C2....FAM, FCC,...
However, i need to arrange it
FM2,FCC,..C1,...
Thank you in advance!

回答 (1 件)

Piyush Lakhani
Piyush Lakhani 2020 年 3 月 12 日
Hi,
First read the text file and X,Y,Z data for indiviual variables.
D=xlsread('DynamicDW.xlsx')
C1=D(:,[1:3]);
C2=D(:,[4:6]);
%Like wise all the variables
FAM=D(:,[start:end])
% Then
Rearrage=[FM2 FCC C1 C2 ] %Write all variables

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by