예제: 조회 함수에서 비교 옵션 사용

함수 > 벡터 및 행렬 > 기타 배열 함수 > 예제: 조회 함수에서 비교 옵션 사용

1. 치수가 동일한 두 행렬 A 및 B를 정의합니다.

2. 변수 z를 정의합니다.

3. match 함수를 사용하여 행렬 A에서 z와 정확하게 일치하는 요소를 구합니다.

이 함수는 행렬 A에서 일치하는 두 요소의 행-열 좌표를 구합니다.

4. match 함수로 찾은 요소를 표시하는 프로그램을 작성합니다.

<region id="ID0ECVYFB" actualWidth="247.09000000000003" actualHeight="258.4" top="460.80000000000007" left="38.400000000000006" xmlns="http://schemas.mathsoft.com/worksheet50">
 <math resultRef="101">
 <define xmlns="http://schemas.mathsoft.com/math50">
 <function>
 <id labels="VARIABLE" xml:space="preserve">F</id>
 <boundVars>
 <id labels="VARIABLE" xml:space="preserve">z</id>
 <id labels="VARIABLE" xml:space="preserve">f</id>
 </boundVars>
 </function>
 <program>
 <if>
 <test>
 <apply>
 <equal />
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">f</id>
 <real>0</real>
 </apply>
 </test>
 <then>
 <program>
 <localDefine>
 <id labels="VARIABLE" xml:space="preserve">M</id>
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">match</id>
 <sequence>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">z</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">A</id>
 </sequence>
 </apply>
 </localDefine>
 </program>
 </then>
 <else>
 <program>
 <localDefine>
 <id labels="VARIABLE" xml:space="preserve">M</id>
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">match</id>
 <sequence>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">z</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">A</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">f</id>
 </sequence>
 </apply>
 </localDefine>
 </program>
 </else>
 </if>
 <for>
 <id labels="VARIABLE" xml:space="preserve">p</id>
 <range>
 <real>0</real>
 <apply>
 <minus />
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">rows</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">M</id>
 </apply>
 <real>1</real>
 </apply>
 </range>
 <program>
 <localDefine>
 <id labels="VARIABLE" xml:space="preserve">r</id>
 <apply>
 <indexer />
 <parens>
 <apply>
 <indexer />
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">M</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">p</id>
 </apply>
 </parens>
 <real>0</real>
 </apply>
 </localDefine>
 <localDefine>
 <id labels="VARIABLE" xml:space="preserve">c</id>
 <apply>
 <indexer />
 <parens>
 <apply>
 <indexer />
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">M</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">p</id>
 </apply>
 </parens>
 <real>1</real>
 </apply>
 </localDefine>
 <localDefine>
 <apply>
 <indexer />
 <id labels="VARIABLE" xml:space="preserve">Q</id>
 <id labels="*" xml:space="preserve">p</id>
 </apply>
 <apply>
 <indexer />
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">A</id>
 <sequence>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">r</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">c</id>
 </sequence>
 </apply>
 </localDefine>
 </program>
 </for>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">Q</id>
 </program>
 </define>
 <resultFormat>
 <matrix size="12,1" offset="1,0" show-indices="false" expand-nested-arrays="false" />
 </resultFormat>
 </math>
</region>

5. 이 프로그램을 사용하여 z=57인 경우 정확하게 일치하는 요소를 표시합니다.

6. lookup 함수를 사용하여 행렬 B에서 행렬 A의 일치 요소에 대응하는 요소를 찾습니다.

이 함수는 일치하는 요소의 행-열 좌표가 아니라 일치하는 요소 자체를 구합니다.

7. lookup 함수로 찾은 요소를 표시하는 프로그램을 작성합니다.

<region id="ID0EW1YFB" actualWidth="267.36666666666673" actualHeight="102.4" top="1017.6000000000001" left="38.400000000000006" xmlns="http://schemas.mathsoft.com/worksheet50">
 <math resultRef="107">
 <define xmlns="http://schemas.mathsoft.com/math50">
 <function>
 <id labels="VARIABLE" xml:space="preserve">L</id>
 <boundVars>
 <id labels="VARIABLE" xml:space="preserve">z</id>
 <id labels="VARIABLE" xml:space="preserve">f</id>
 </boundVars>
 </function>
 <program>
 <if>
 <test>
 <apply>
 <equal />
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">f</id>
 <real>0</real>
 </apply>
 </test>
 <then>
 <program>
 <localDefine>
 <id labels="VARIABLE" xml:space="preserve">M</id>
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">lookup</id>
 <sequence>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">z</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">A</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">B</id>
 </sequence>
 </apply>
 </localDefine>
 </program>
 </then>
 <else>
 <program>
 <localDefine>
 <id labels="VARIABLE" xml:space="preserve">M</id>
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">lookup</id>
 <sequence>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">z</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">A</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">B</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">f</id>
 </sequence>
 </apply>
 </localDefine>
 </program>
 </else>
 </if>
 </program>
 </define>
 </math>
</region>

8. 이 프로그램을 사용하여 z=57인 경우 행렬 B의 일치하는 요소를 표시합니다.

9. 두 프로그램을 사용하여 match 및 lookup 함수로 찾은 요소를 비교 함수 f1을 사용하여 표시합니다.

이 비교 옵션은 행렬 A 요소 값을 r1 범위 내부에서 일치시킵니다.

10. 두 프로그램을 사용하여 match 및 lookup 함수로 찾은 요소를 비교 함수 f2을 사용하여 표시합니다.

이 비교 옵션은 행렬 A 요소 값을 r2 범위 외부에서 일치시킵니다.

11. 행렬을 벡터로 변환하는 프로그램을 작성합니다.

<region id="ID0EELZFB" actualWidth="279.74666666666667" actualHeight="165.152" top="1977.6000000000004" left="38.400000000000006" xmlns="http://schemas.mathsoft.com/worksheet50">
 <math resultRef="135">
 <define xmlns="http://schemas.mathsoft.com/math50">
 <function>
 <id labels="VARIABLE" xml:space="preserve">S</id>
 <boundVars>
 <id labels="VARIABLE" xml:space="preserve">M</id>
 </boundVars>
 </function>
 <program>
 <localDefine>
 <apply>
 <indexer />
 <id labels="VARIABLE" xml:space="preserve">T</id>
 <real>0</real>
 </apply>
 <real>0</real>
 </localDefine>
 <for>
 <id labels="VARIABLE" xml:space="preserve">c</id>
 <range>
 <real>0</real>
 <apply>
 <minus />
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">cols</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">M</id>
 </apply>
 <real>1</real>
 </apply>
 </range>
 <program>
 <localDefine>
 <id labels="VARIABLE" xml:space="preserve">T</id>
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">stack</id>
 <sequence>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">T</id>
 <apply>
 <matcol />
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">M</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">c</id>
 </apply>
 </sequence>
 </apply>
 </localDefine>
 </program>
 </for>
 <for>
 <id labels="VARIABLE" xml:space="preserve">d</id>
 <range>
 <real>1</real>
 <apply>
 <mult />
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">rows</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">M</id>
 </apply>
 <apply>
 <id labels="FUNCTION" xml:space="preserve" label-is-contextual="true">cols</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">M</id>
 </apply>
 </apply>
 </range>
 <program>
 <localDefine>
 <apply>
 <indexer />
 <id labels="VARIABLE" xml:space="preserve">S</id>
 <apply>
 <minus />
 <id labels="*" xml:space="preserve">d</id>
 <real>1</real>
 </apply>
 </apply>
 <apply>
 <indexer />
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">T</id>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">d</id>
 </apply>
 </localDefine>
 </program>
 </for>
 <id labels="VARIABLE" xml:space="preserve" label-is-contextual="true">S</id>
 </program>
 </define>
 <resultFormat>
 <matrix size="13,1" offset="5,0" show-indices="false" expand-nested-arrays="false" />
 </resultFormat>
 </math>
</region>

12. 이 프로그램을 사용하여 행렬 A를 벡터 V로 변환합니다.

13. 행렬 A에서 일치하는 점으로 구성된 벡터의 길이를 구합니다.

14. 일치하는 점을 V와 길이가 동일한 새 벡터에 삽입하는 프로그램을 작성합니다. 이 프로그램은 채워지지 않은 위치에 -100을 기록합니다.

15. MV에서 -100 점을 숨기는 방식으로 두 벡터를 도표화합니다. 가로 마커를 사용하여 r2의 두 레벨을 표시합니다.

<region id="ID0EEWZFB" actualWidth="576.8" actualHeight="288" top="3072.0000000000005" left="38.400000000000006" height="288" width="576.8" xmlns="http://schemas.mathsoft.com/worksheet50">
 <plot background-type="white">
 <xyPlot>
 <title class="- topic/title " wwtype:type="Paragraph" xmlns:wwtype="urn:WebWorks-Type-Schema" />
 <legend />
 <traces>
 <trace resultRef="151">
 <traceStyle color="#FF2E3192" symbol="rectangle" line-weight="1" line-style="None">lines</traceStyle>
 </trace>
 <trace resultRef="152">
 <traceStyle color="#FFED1D2F" symbol="circle" line-weight="1" line-style="None">lines</traceStyle>
 </trace>
 </traces>
 <graph-size width="438.4" height="230.4" />
 <axes>
 <xAxis rank="1" legend-position="PlotBoundaryBottom" start="0" end="11">
 <axisLine position="ticknumberlock" positionticmark="1" legendWidth="61.7533333333333" />
 <axisGrid>
 <gridFrequency>12</gridFrequency>
 <gridLabels display="true" />
 <gridLines />
 <tickMarks display="true" />
 </axisGrid>
 <axisLabel />
 <markers />
 <plotEquations>
 <plotEquation>
 <math resultRef="157">
 <id xml:space="preserve" xmlns="http://schemas.mathsoft.com/math50">n</id>
 </math>
 <math resultRef="158">
 <placeholder xmlns="http://schemas.mathsoft.com/math50" />
 </math>
 </plotEquation>
 </plotEquations>
 <xyDomain scale-type="linear" auto-scale="true">
 <startValue resultRef="154">
 <real xmlns="http://schemas.mathsoft.com/math50">0</real>
 </startValue>
 <endValue resultRef="156">
 <apply xmlns="http://schemas.mathsoft.com/math50">
 <minus />
 <id xml:space="preserve">l1</id>
 <real>1</real>
 </apply>
 </endValue>
 </xyDomain>
 </xAxis>
 <yAxis rank="1" legend-position="PlotBoundaryLeft" start="-20" end="180">
 <axisLine position="left" positionticmark="-1" legendWidth="96.53" />
 <axisGrid>
 <gridFrequency>11</gridFrequency>
 <gridLabels display="true" />
 <gridLines />
 <tickMarks display="true" />
 </axisGrid>
 <axisLabel />
 <markers>
 <marker resultRef="159" display="true" color="#FFED1D2F" line-style="Dash" value="28.5">
 <id xml:space="preserve" xmlns="http://schemas.mathsoft.com/math50">
 r2<Subscript xmlns="clr-namespace:Ptc.Wpf;assembly=Ptc.Core">lo</Subscript>
 </id>
 </marker>
 <marker resultRef="161" display="true" color="#FFED1D2F" line-style="Dash" value="85.5">
 <id xml:space="preserve" xmlns="http://schemas.mathsoft.com/math50">
 r2<Subscript xmlns="clr-namespace:Ptc.Wpf;assembly=Ptc.Core">hi</Subscript>
 </id>
 </marker>
 </markers>
 <plotEquations>
 <plotEquation>
 <math resultRef="169">
 <apply xmlns="http://schemas.mathsoft.com/math50">
 <indexer />
 <parens>
 <id xml:space="preserve">V</id>
 </parens>
 <id xml:space="preserve">n</id>
 </apply>
 </math>
 <math resultRef="170">
 <placeholder xmlns="http://schemas.mathsoft.com/math50" />
 </math>
 </plotEquation>
 <plotEquation>
 <math resultRef="171">
 <apply xmlns="http://schemas.mathsoft.com/math50">
 <indexer />
 <parens>
 <id xml:space="preserve">MV</id>
 </parens>
 <id xml:space="preserve">n</id>
 </apply>
 </math>
 <math resultRef="172">
 <placeholder xmlns="http://schemas.mathsoft.com/math50" />
 </math>
 </plotEquation>
 </plotEquations>
 <xyDomain scale-type="linear" auto-scale="true">
 <startValue resultRef="164">
 <apply xmlns="http://schemas.mathsoft.com/math50">
 <neg />
 <id xml:space="preserve">offset</id>
 </apply>
 </startValue>
 <secondTickValue resultRef="166">
 <real xmlns="http://schemas.mathsoft.com/math50">0</real>
 </secondTickValue>
 <endValue resultRef="168">
 <apply xmlns="http://schemas.mathsoft.com/math50">
 <plus />
 <apply>
 <id xml:space="preserve">max</id>
 <id xml:space="preserve">A</id>
 </apply>
 <id xml:space="preserve">offset</id>
 </apply>
 </endValue>
 </xyDomain>
 </yAxis>
 </axes>
 </xyPlot>
 </plot>
</region>

벡터 V(또는 행렬 A)의 12개 요소 중 일치하는 5개 요소가 r2의 지정된 범위를 벗어납니다.