Interpolate strings from an x y interval to a corresponding x y interval.
조회 수: 2 (최근 30일)
이전 댓글 표시
I am restructuring a database and I have two tables in different formats but with the same information. Table One is a combination of values and strings where the from-to data are in custom intervals rounded to the nearest '0.25' as follows:
.
Table two is the same range of values and contains all the same integers but is formatted as fixed incremental 'blocks' instead of custom intervals.
I want to take the strings from table 1 and interp them onto table 2 so that if the 'from-to' values of table 2 falls within the range of an interval in table 1 it will have the corresponding strings as imagined below.
I can not seem to find a function that will allow me to perform this task with strings.
Any help would would be very much appreciated, thanks!
댓글 수: 4
Jay
2023년 3월 15일
Can you share the code of the solution because I have the same question and not able to find answers anywhere else on this topic ?
채택된 답변
Jan
2022년 3월 6일
The solution is not to do this with strings directly, but with indices:
idx = interp1(table1{:, 1}, 1:height(table1), table2{:, 1});
Now use this index to fill the column of table2.
One problem is, that e.g. the 0.25 appears at final point of one interval and the start point of the next one. To which of the two does 0.25 belong?
댓글 수: 3
Jan
2022년 3월 7일
편집: Jan
2022년 3월 7일
This is failing:
load intervals
intervalfrom = intervals(:,1);
The MAT file intervals.mat contains a variable called lithdataint. blocks.mat contains a variable blocksft. Should I convert the names "intervals" and "blocks" accordingly?
I'd expect a simple solution as:
table2(:, 3) = table1(idx, 3)
추가 답변 (1개)
Peter Perkins
2022년 3월 7일
If you had timetables, ths would be a one-liner using synchronize. from and blocksFrom look suspiciously like time vectors. Timetables might make your life easier, but hard to tell.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Types에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!