You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
How to add sequence data into a sequence database
1 view (last 30 days)
Show older comments
I wish to add new data into a sequence database (49x1 cell). I have the database created as presented below from dataset D2 (72x6). I wish to add new dataset D3(72x6) into the seqhence database to have (121x1 cells). Please How do I proceed. I am a novice at the moment.
clear,clc;
L1 = xlsread("D2.xlsx")
L1 = 72×6
24.6000 0 0 0 0 149.0000
24.6000 0 0 0 0 139.0000
24.8000 0 0 0 0 127.0000
25.1000 0 0 0 0 114.0000
25.2000 0 0 0 0 100.0000
25.1000 26.0000 0 0 77.9730 86.0000
25.1000 125.0000 145.0000 9.0000 276.9108 72.0000
25.5000 236.0000 228.0000 82.0000 351.5500 58.0000
26.2000 325.0000 252.0000 150.0000 623.3732 45.0000
26.7000 398.0000 261.0000 83.0000 707.3739 32.0000
Q= flip(L1)
Q = 72×6
23.7000 0 0 0 0 153.0000
23.6000 0 0 0 0 151.0000
23.8000 0 0 0 0 142.0000
24.4000 0 0 0 0 131.0000
24.8000 75.0000 0 0 185.7448 118.0000
25.5000 89.0000 0 0 277.4559 104.0000
26.2000 98.0000 0 2.0000 332.6769 91.0000
26.3000 97.0000 35.0000 1.0000 325.8987 77.0000
26.1000 198.0000 83.0000 7.0000 332.8428 63.0000
26.0000 320.0000 25.0000 12.0000 411.8349 49.0000
A= Q(:,1)
A = 72×1
23.7000
23.6000
23.8000
24.4000
24.8000
25.5000
26.2000
26.3000
26.1000
26.0000
B= Q(:,2)
B = 72×1
0
0
0
0
75
89
98
97
198
320
C= Q(:,3)
C = 72×1
0
0
0
0
0
0
0
35
83
25
D= Q(:,4)
D = 72×1
0
0
0
0
0
0
2
1
7
12
E= Q(:,5)
E = 72×1
0
0
0
0
185.7448
277.4559
332.6769
325.8987
332.8428
411.8349
F= Q(:,6)
F = 72×1
153
151
142
131
118
104
91
77
63
49
[row colo]= size(Q)
row = 72
colo = 6
SequenceLength= 24;
Database= {};
resultDatabase =[];
count=0;
for i= row:-1: SequenceLength
count=count+1;
a1 = A(i-SequenceLength+1:i)';
a2 = B(i-SequenceLength+1:i)';
a3 = C(i-SequenceLength+1:i)';
a4 = D(i-SequenceLength+1:i)';
a5 = E(i-SequenceLength+1:i)';
a6 = F(i-SequenceLength+1:i)';
Database{count,1}=[a1;a2;a3;a4;a5;a6]
end
Database = 1×1 cell array
{6×24 double}
Database = 2×1 cell array
{6×24 double}
{6×24 double}
Database = 3×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
Database = 4×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 5×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 6×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 7×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 8×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 9×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 10×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 11×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 12×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 13×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 14×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 15×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 16×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 17×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 18×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 19×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 20×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 21×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 22×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 23×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 24×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 25×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 26×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 27×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 28×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 29×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 30×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 31×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 32×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 33×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 34×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 35×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 36×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 37×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 38×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 39×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 40×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 41×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 42×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 43×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 44×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 45×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 46×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 47×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 48×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
Database = 49×1 cell array
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
{6×24 double}
[rt,ct] = size(Database)
rt = 49
ct = 1
count=0;
for i=1: rt-1
count=count+1;
a5= Database{count+1,1};
resultDatabase(count,1)= a5(5,end);
end
LDatabase = Database;
save LDatabase
1 Comment
Jon
on 14 Jul 2023
I can't follow from initial explanation and your code what you are actually trying to accomplish. Can you please provide a simple example illustrating what are your inputs, and what is your desired output.
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)