이 질문을 팔로우합니다.
- 팔로우하는 게시물 피드에서 업데이트를 확인할 수 있습니다.
- 정보 수신 기본 설정에 따라 이메일을 받을 수 있습니다.
How to add sequence data into a sequence database
조회 수: 1 (최근 30일)
이전 댓글 표시
MBUNYA NERVILLE ANYANG
2023년 7월 14일
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
Jon
2023년 7월 14일
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.
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Database Toolbox에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!오류 발생
페이지가 변경되었기 때문에 동작을 완료할 수 없습니다. 업데이트된 상태를 보려면 페이지를 다시 불러오십시오.
웹사이트 선택
번역된 콘텐츠를 보고 지역별 이벤트와 혜택을 살펴보려면 웹사이트를 선택하십시오. 현재 계신 지역에 따라 다음 웹사이트를 권장합니다:
또한 다음 목록에서 웹사이트를 선택하실 수도 있습니다.
사이트 성능 최적화 방법
최고의 사이트 성능을 위해 중국 사이트(중국어 또는 영어)를 선택하십시오. 현재 계신 지역에서는 다른 국가의 MathWorks 사이트 방문이 최적화되지 않았습니다.
미주
- América Latina (Español)
- Canada (English)
- United States (English)
유럽
- 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)
아시아 태평양
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)