hsDatab/docs/data/src/hsDatab/Data.html at master · HelpfulScripts/hsDatab

637 lines (635 loc) · 92.1 KB
                <html><style>body { overflow:hidden;}
            h1 { font-family: Arial, sans-serif; font-size: 24px; color: #44a; }
            p { margin:0; padding:0; }
            br  { margin:0; padding:0; }
            .line { 
                white-space: nowrap;
                height:16px; 
            .line>span { 
                display:inline-block; background-color:#eef; height:100%; 
                margin: 0 5px 0 0; padding-right: 5px; color:#999;   
            comment {color: #080;} module {color: #804;} 
            quote {color: #008;} comment>quote {color: #080;}
            .listing { margin: 10px; border: 1px solid #ccc; 
                    font-family: SFMono-Regular, Consolas, 'Liberation Mono', Menlo, Courier, monospace;
                    font-size: 14px;  
                    overflow:scroll;
                    height:90%;
            code { padding: 5px 0;}</style></html><body>
                <h1>Data.ts</h1>
                <div class='listing'><code><p id=1 class="line"><span>&nbsp;&nbsp;&nbsp;1</span><comment>/**</comment></p>
<p id=2 class="line"><span>&nbsp;&nbsp;&nbsp;2</span><comment>&nbsp;*/</comment></p>
<p id=3 class="line"><span>&nbsp;&nbsp;&nbsp;3</span></p>
<p id=4 class="line"><span>&nbsp;&nbsp;&nbsp;4</span>&nbsp;<comment>/**&nbsp;*/</comment></p>
<p id=5 class="line"><span>&nbsp;&nbsp;&nbsp;5</span>import&nbsp;{&nbsp;Condition,&nbsp;filter&nbsp;}&nbsp;from&nbsp;<quote>'./DataFilters'</quote>;</p>
<p id=6 class="line"><span>&nbsp;&nbsp;&nbsp;6</span>import&nbsp;{&nbsp;Log&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from&nbsp;<quote>'hsutil'</quote>;&nbsp;const&nbsp;log&nbsp;=&nbsp;new&nbsp;Log(<quote>'Data'</quote>);</p>
<p id=7 class="line"><span>&nbsp;&nbsp;&nbsp;7</span></p>
<p id=8 class="line"><span>&nbsp;&nbsp;&nbsp;8</span><comment>/**&nbsp;defines&nbsp;a&nbsp;[min-max]&nbsp;range&nbsp;*/</comment></p>
<p id=9 class="line"><span>&nbsp;&nbsp;&nbsp;9</span>export&nbsp;type&nbsp;NumRange&nbsp;=&nbsp;[number,&nbsp;number];</p>
<p id=10 class="line"><span>&nbsp;&nbsp;10</span></p>
<p id=11 class="line"><span>&nbsp;&nbsp;11</span><comment>/**&nbsp;defines&nbsp;a&nbsp;numeric&nbsp;domain&nbsp;that&nbsp;includes&nbsp;all&nbsp;values&nbsp;of&nbsp;a&nbsp;column&nbsp;*/</comment></p>
<p id=12 class="line"><span>&nbsp;&nbsp;12</span>export&nbsp;type&nbsp;NumDomain&nbsp;=&nbsp;[number,&nbsp;number];</p>
<p id=13 class="line"><span>&nbsp;&nbsp;13</span></p>
<p id=14 class="line"><span>&nbsp;&nbsp;14</span><comment>/**&nbsp;defines&nbsp;a&nbsp;Date&nbsp;domain&nbsp;that&nbsp;includes&nbsp;all&nbsp;values&nbsp;of&nbsp;a&nbsp;column&nbsp;*/</comment></p>
<p id=15 class="line"><span>&nbsp;&nbsp;15</span>export&nbsp;type&nbsp;DateDomain&nbsp;=&nbsp;[Date,&nbsp;Date];</p>
<p id=16 class="line"><span>&nbsp;&nbsp;16</span></p>
<p id=17 class="line"><span>&nbsp;&nbsp;17</span><comment>/**&nbsp;defines&nbsp;a&nbsp;categorical&nbsp;domain&nbsp;that&nbsp;includes&nbsp;all&nbsp;values&nbsp;of&nbsp;a&nbsp;column&nbsp;*/</comment></p>
<p id=18 class="line"><span>&nbsp;&nbsp;18</span>export&nbsp;type&nbsp;NameDomain&nbsp;=&nbsp;string[];</p>
<p id=19 class="line"><span>&nbsp;&nbsp;19</span></p>
<p id=20 class="line"><span>&nbsp;&nbsp;20</span><comment>/**&nbsp;defines&nbsp;a&nbsp;generic&nbsp;domain&nbsp;that&nbsp;can&nbsp;be&nbsp;any&nbsp;of&nbsp;the&nbsp;typed&nbsp;domains.&nbsp;*/</comment></p>
<p id=21 class="line"><span>&nbsp;&nbsp;21</span>export&nbsp;type&nbsp;Domain&nbsp;=&nbsp;NumDomain&nbsp;|&nbsp;DateDomain&nbsp;|&nbsp;NameDomain;</p>
<p id=22 class="line"><span>&nbsp;&nbsp;22</span></p>
<p id=23 class="line"><span>&nbsp;&nbsp;23</span><comment>/**&nbsp;defines&nbsp;a&nbsp;Column&nbsp;Reference,&nbsp;either&nbsp;as&nbsp;column&nbsp;name&nbsp;or&nbsp;index&nbsp;in&nbsp;the&nbsp;{@link&nbsp;Data.DataRow&nbsp;`DataRow`}&nbsp;array&nbsp;*/</comment></p>
<p id=24 class="line"><span>&nbsp;&nbsp;24</span>export&nbsp;type&nbsp;ColumnReference&nbsp;=&nbsp;number|string;</p>
<p id=25 class="line"><span>&nbsp;&nbsp;25</span></p>
<p id=26 class="line"><span>&nbsp;&nbsp;26</span><comment>/**&nbsp;a&nbsp;generic&nbsp;data&nbsp;value&nbsp;type,&nbsp;used&nbsp;in&nbsp;the&nbsp;{@link&nbsp;Data.DataRow&nbsp;`DataRow`}&nbsp;array&nbsp;*/</comment></p>
<p id=27 class="line"><span>&nbsp;&nbsp;27</span>export&nbsp;type&nbsp;DataVal&nbsp;=&nbsp;number|string|Date;</p>
<p id=28 class="line"><span>&nbsp;&nbsp;28</span></p>
<p id=29 class="line"><span>&nbsp;&nbsp;29</span><comment>/**&nbsp;a&nbsp;single&nbsp;row&nbsp;of&nbsp;column&nbsp;values&nbsp;*/</comment></p>
<p id=30 class="line"><span>&nbsp;&nbsp;30</span>export&nbsp;type&nbsp;DataRow&nbsp;=&nbsp;DataVal[];</p>
<p id=31 class="line"><span>&nbsp;&nbsp;31</span></p>
<p id=32 class="line"><span>&nbsp;&nbsp;32</span><comment>/**&nbsp;a&nbsp;JSON&nbsp;format&nbsp;data&nbsp;set,&nbsp;using&nbsp;arrays&nbsp;of&nbsp;names&nbsp;and&nbsp;rows&nbsp;*/</comment></p>
<p id=33 class="line"><span>&nbsp;&nbsp;33</span>export&nbsp;interface&nbsp;DataSet&nbsp;{</p>
<p id=34 class="line"><span>&nbsp;&nbsp;34</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;an&nbsp;optional&nbsp;name&nbsp;for&nbsp;the&nbsp;data&nbsp;set&nbsp;*/</comment></p>
<p id=35 class="line"><span>&nbsp;&nbsp;35</span>&nbsp;&nbsp;&nbsp;&nbsp;name?:&nbsp;&nbsp;string;</p>
<p id=36 class="line"><span>&nbsp;&nbsp;36</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;an&nbsp;array&nbsp;of&nbsp;column&nbsp;names.&nbsp;Each&nbsp;name&nbsp;matches&nbsp;the&nbsp;column&nbsp;with&nbsp;the&nbsp;same&nbsp;index&nbsp;in&nbsp;DataRow&nbsp;*/</comment></p>
<p id=37 class="line"><span>&nbsp;&nbsp;37</span>&nbsp;&nbsp;&nbsp;&nbsp;colNames:&nbsp;&nbsp;string[];&nbsp;&nbsp;&nbsp;</p>
<p id=38 class="line"><span>&nbsp;&nbsp;38</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;rows&nbsp;of&nbsp;data&nbsp;*/</comment></p>
<p id=39 class="line"><span>&nbsp;&nbsp;39</span>&nbsp;&nbsp;&nbsp;&nbsp;rows:&nbsp;&nbsp;&nbsp;DataRow[];</p>
<p id=40 class="line"><span>&nbsp;&nbsp;40</span>}</p>
<p id=41 class="line"><span>&nbsp;&nbsp;41</span></p>
<p id=42 class="line"><span>&nbsp;&nbsp;42</span><comment>/**&nbsp;a&nbsp;data&nbsp;set&nbsp;in&nbsp;table&nbsp;format.&nbsp;The&nbsp;first&nbsp;row&nbsp;contains&nbsp;the&nbsp;column&nbsp;names.&nbsp;*/</comment></p>
<p id=43 class="line"><span>&nbsp;&nbsp;43</span>export&nbsp;type&nbsp;DataTable&nbsp;=&nbsp;(string|number)[][];</p>
<p id=44 class="line"><span>&nbsp;&nbsp;44</span></p>
<p id=45 class="line"><span>&nbsp;&nbsp;45</span>interface&nbsp;TypeStruct&nbsp;{&nbsp;type:&nbsp;Type;&nbsp;count:&nbsp;number;}</p>
<p id=46 class="line"><span>&nbsp;&nbsp;46</span></p>
<p id=47 class="line"><span>&nbsp;&nbsp;47</span>interface&nbsp;MetaStruct&nbsp;{</p>
<p id=48 class="line"><span>&nbsp;&nbsp;48</span>&nbsp;&nbsp;&nbsp;&nbsp;name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;string;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;column&nbsp;name</comment></p>
<p id=49 class="line"><span>&nbsp;&nbsp;49</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;column:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;number;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;column&nbsp;index</comment></p>
<p id=50 class="line"><span>&nbsp;&nbsp;50</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;accessed:&nbsp;&nbsp;&nbsp;boolean;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;has&nbsp;column&nbsp;data&nbsp;been&nbsp;accessed?</comment></p>
<p id=51 class="line"><span>&nbsp;&nbsp;51</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;cast:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;boolean;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;has&nbsp;column&nbsp;data&nbsp;been&nbsp;cast&nbsp;</comment></p>
<p id=52 class="line"><span>&nbsp;&nbsp;52</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;types:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TypeStruct[];&nbsp;&nbsp;&nbsp;<comment>//&nbsp;data&nbsp;types,&nbsp;sorted&nbsp;by&nbsp;likelihood</comment></p>
<p id=53 class="line"><span>&nbsp;&nbsp;53</span><comment></comment>}</p>
<p id=54 class="line"><span>&nbsp;&nbsp;54</span></p>
<p id=55 class="line"><span>&nbsp;&nbsp;55</span></p>
<p id=56 class="line"><span>&nbsp;&nbsp;56</span>export&nbsp;type&nbsp;sortFn&nbsp;&nbsp;&nbsp;=&nbsp;(x:any,&nbsp;y:any)&nbsp;=&gt;&nbsp;number;</p>
<p id=57 class="line"><span>&nbsp;&nbsp;57</span>export&nbsp;type&nbsp;mapFn&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;(colVal:DataVal,&nbsp;colIndex:number,&nbsp;rowIndex:number,&nbsp;rows:DataRow[])&nbsp;=&gt;&nbsp;DataVal;</p>
<p id=58 class="line"><span>&nbsp;&nbsp;58</span>export&nbsp;type&nbsp;mapRowFn&nbsp;=&nbsp;(row:DataRow,&nbsp;rowIndex:number,&nbsp;rows:DataRow[])&nbsp;=&gt;&nbsp;DataRow;</p>
<p id=59 class="line"><span>&nbsp;&nbsp;59</span>export&nbsp;type&nbsp;initFn&nbsp;&nbsp;&nbsp;=&nbsp;(colVal:&nbsp;DataVal,&nbsp;colIndex:number,&nbsp;row:DataRow)&nbsp;=&gt;&nbsp;DataVal;</p>
<p id=60 class="line"><span>&nbsp;&nbsp;60</span>&nbsp;&nbsp;&nbsp;&nbsp;</p>
<p id=61 class="line"><span>&nbsp;&nbsp;61</span><comment>/**</comment></p>
<p id=62 class="line"><span>&nbsp;&nbsp;62</span><comment>&nbsp;*&nbsp;Type&nbsp;definition.&nbsp;Can&nbsp;be&nbsp;one&nbsp;of&nbsp;</comment></p>
<p id=63 class="line"><span>&nbsp;&nbsp;63</span><comment>&nbsp;*&nbsp;-&nbsp;<quote>'number'</quote>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;numeric&nbsp;values</comment></p>
<p id=64 class="line"><span>&nbsp;&nbsp;64</span><comment>&nbsp;*&nbsp;-&nbsp;<quote>'name'</quote>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;nominal&nbsp;values,&nbsp;represented&nbsp;by&nbsp;arbitrary&nbsp;words</comment></p>
<p id=65 class="line"><span>&nbsp;&nbsp;65</span><comment>&nbsp;*&nbsp;-&nbsp;<quote>'date'</quote>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;date&nbsp;values&nbsp;</comment></p>
<p id=66 class="line"><span>&nbsp;&nbsp;66</span><comment>&nbsp;*&nbsp;-&nbsp;<quote>'currency'</quote>&nbsp;&nbsp;&nbsp;:&nbsp;currency&nbsp;values.&nbsp;Currently&nbsp;supported&nbsp;are&nbsp;values&nbsp;ofg&nbsp;the&nbsp;format&nbsp;<quote>'$dd[,ddd]'</quote></comment></p>
<p id=67 class="line"><span>&nbsp;&nbsp;67</span><comment>&nbsp;*&nbsp;-&nbsp;<quote>'percent'</quote>;&nbsp;&nbsp;&nbsp;:&nbsp;percent&nbsp;values:&nbsp;<quote>'d%'</quote></comment></p>
<p id=68 class="line"><span>&nbsp;&nbsp;68</span><comment>&nbsp;*/</comment></p>
<p id=69 class="line"><span>&nbsp;&nbsp;69</span>export&nbsp;type&nbsp;Type&nbsp;=&nbsp;<quote>'number'</quote>&nbsp;|&nbsp;<quote>'name'</quote>&nbsp;|&nbsp;<quote>'date'</quote>&nbsp;|&nbsp;<quote>'currency'</quote>&nbsp;|&nbsp;<quote>'percent'</quote>;</p>
<p id=70 class="line"><span>&nbsp;&nbsp;70</span></p>
<p id=71 class="line"><span>&nbsp;&nbsp;71</span>export&nbsp;enum&nbsp;Types&nbsp;{</p>
<p id=72 class="line"><span>&nbsp;&nbsp;72</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;numeric&nbsp;values&nbsp;*/</comment></p>
<p id=73 class="line"><span>&nbsp;&nbsp;73</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;number&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<quote>'number'</quote>,</p>
<p id=74 class="line"><span>&nbsp;&nbsp;74</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;nominal&nbsp;values,&nbsp;represented&nbsp;by&nbsp;arbitrary&nbsp;words&nbsp;*/</comment></p>
<p id=75 class="line"><span>&nbsp;&nbsp;75</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<quote>'name'</quote>,</p>
<p id=76 class="line"><span>&nbsp;&nbsp;76</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;date&nbsp;values&nbsp;*/</comment></p>
<p id=77 class="line"><span>&nbsp;&nbsp;77</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;date&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<quote>'date'</quote>,</p>
<p id=78 class="line"><span>&nbsp;&nbsp;78</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;currency&nbsp;values.&nbsp;Currently&nbsp;support6ed&nbsp;are&nbsp;values&nbsp;ofg&nbsp;the&nbsp;format&nbsp;<quote>'$dd[,ddd]'</quote>&nbsp;*/</comment></p>
<p id=79 class="line"><span>&nbsp;&nbsp;79</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currency&nbsp;=&nbsp;&nbsp;&nbsp;<quote>'currency'</quote>,</p>
<p id=80 class="line"><span>&nbsp;&nbsp;80</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;percent&nbsp;values:&nbsp;<quote>'d%'</quote>&nbsp;*/</comment></p>
<p id=81 class="line"><span>&nbsp;&nbsp;81</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;percent&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;<quote>'percent'</quote>,</p>
<p id=82 class="line"><span>&nbsp;&nbsp;82</span>}&nbsp;</p>
<p id=83 class="line"><span>&nbsp;&nbsp;83</span></p>
<p id=84 class="line"><span>&nbsp;&nbsp;84</span><comment>/**</comment></p>
<p id=85 class="line"><span>&nbsp;&nbsp;85</span><comment>&nbsp;*&nbsp;@param&nbsp;val&nbsp;the&nbsp;string&nbsp;to&nbsp;convert&nbsp;to&nbsp;a&nbsp;date</comment></p>
<p id=86 class="line"><span>&nbsp;&nbsp;86</span><comment>&nbsp;*&nbsp;@param&nbsp;limitYear&nbsp;the&nbsp;year&nbsp;below&nbsp;which&nbsp;the&nbsp;century&nbsp;is&nbsp;corrected.&nbsp;Defaults&nbsp;to&nbsp;1970.</comment></p>
<p id=87 class="line"><span>&nbsp;&nbsp;87</span><comment>&nbsp;*&nbsp;@returns&nbsp;a&nbsp;new&nbsp;Date&nbsp;object&nbsp;parsed&nbsp;from&nbsp;`str`.</comment></p>
<p id=88 class="line"><span>&nbsp;&nbsp;88</span><comment>&nbsp;*&nbsp;@description&nbsp;returns&nbsp;a&nbsp;new&nbsp;Date&nbsp;object&nbsp;parsed&nbsp;from&nbsp;`str`&nbsp;and&nbsp;corrects&nbsp;for&nbsp;a&nbsp;difference&nbsp;in&nbsp;</comment></p>
<p id=89 class="line"><span>&nbsp;&nbsp;89</span><comment>&nbsp;*&nbsp;interpreting&nbsp;centuries&nbsp;between&nbsp;webkit&nbsp;and&nbsp;mozilla&nbsp;in&nbsp;converting&nbsp;strings&nbsp;to&nbsp;Dates:</comment></p>
<p id=90 class="line"><span>&nbsp;&nbsp;90</span><comment>&nbsp;*&nbsp;The&nbsp;string&nbsp;<quote>"15/7/03"</quote>&nbsp;will&nbsp;convert&nbsp;to&nbsp;Jul&nbsp;15&nbsp;1903&nbsp;in&nbsp;Mozilla&nbsp;and&nbsp;July&nbsp;15&nbsp;2003&nbsp;in&nbsp;Webkit.</comment></p>
<p id=91 class="line"><span>&nbsp;&nbsp;91</span><comment>&nbsp;*&nbsp;If&nbsp;`limitYear`&nbsp;is&nbsp;not&nbsp;specified&nbsp;this&nbsp;method&nbsp;uses&nbsp;1970&nbsp;as&nbsp;the&nbsp;decision&nbsp;date:&nbsp;</comment></p>
<p id=92 class="line"><span>&nbsp;&nbsp;92</span><comment>&nbsp;*&nbsp;years&nbsp;00-69&nbsp;will&nbsp;be&nbsp;interpreted&nbsp;as&nbsp;2000-2069,&nbsp;years&nbsp;70-99&nbsp;as&nbsp;1970-1999.</comment></p>
<p id=93 class="line"><span>&nbsp;&nbsp;93</span><comment>&nbsp;*&nbsp;Specifying&nbsp;a&nbsp;century&nbsp;in&nbsp;the&nbsp;string&nbsp;leads&nbsp;to&nbsp;a&nbsp;correct&nbsp;parse,&nbsp;e.g.&nbsp;<quote>"15/7/1903"</quote></comment></p>
<p id=94 class="line"><span>&nbsp;&nbsp;94</span><comment>&nbsp;*/</comment></p>
<p id=95 class="line"><span>&nbsp;&nbsp;95</span>function&nbsp;toDate(val:DataVal,&nbsp;limitYear=1970):Date&nbsp;{</p>
<p id=96 class="line"><span>&nbsp;&nbsp;96</span>&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;d:Date;</p>
<p id=97 class="line"><span>&nbsp;&nbsp;97</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(val&nbsp;instanceof&nbsp;Date)&nbsp;{&nbsp;return&nbsp;&lt;Date&gt;val;&nbsp;}</p>
<p id=98 class="line"><span>&nbsp;&nbsp;98</span>&nbsp;&nbsp;&nbsp;&nbsp;d&nbsp;=&nbsp;new&nbsp;Date(&lt;string&gt;val);&nbsp;</p>
<p id=99 class="line"><span>&nbsp;&nbsp;99</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!isNaN(d.getTime()))&nbsp;{</p>
<p id=100 class="line"><span>&nbsp;100</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;r&nbsp;=&nbsp;new&nbsp;RegExp(`\\d\\d${d.getFullYear()&nbsp;%&nbsp;100}`,&nbsp;<quote>'g'</quote>);</p>
<p id=101 class="line"><span>&nbsp;101</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!(&lt;string&gt;val).match(r))&nbsp;{</p>
<p id=102 class="line"><span>&nbsp;102</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;yr&nbsp;=&nbsp;1900&nbsp;+&nbsp;d.getFullYear()&nbsp;%&nbsp;100;</p>
<p id=103 class="line"><span>&nbsp;103</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;d.setFullYear(&nbsp;(yr&nbsp;&lt;&nbsp;limitYear)?&nbsp;yr+100&nbsp;:&nbsp;yr);&nbsp;</p>
<p id=104 class="line"><span>&nbsp;104</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=105 class="line"><span>&nbsp;105</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=106 class="line"><span>&nbsp;106</span>&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;d;</p>
<p id=107 class="line"><span>&nbsp;107</span>}</p>
<p id=108 class="line"><span>&nbsp;108</span></p>
<p id=109 class="line"><span>&nbsp;109</span><comment>/**</comment></p>
<p id=110 class="line"><span>&nbsp;110</span><comment>&nbsp;*&nbsp;@param&nbsp;type&nbsp;[<quote>'date'</quote>&nbsp;|&nbsp;<quote>'percent'</quote>&nbsp;|&nbsp;<quote>'real'</quote>&nbsp;|&nbsp;_any_]&nbsp;The&nbsp;type&nbsp;to&nbsp;cast&nbsp;into.&nbsp;In&nbsp;case&nbsp;of&nbsp;_any_&nbsp;-&nbsp;i.e.&nbsp;`type`&nbsp;</comment></p>
<p id=111 class="line"><span>&nbsp;111</span><comment>&nbsp;*&nbsp;does&nbsp;not&nbsp;match&nbsp;any&nbsp;of&nbsp;the&nbsp;previous&nbsp;keywords,&nbsp;no&nbsp;casting&nbsp;occurs.</comment></p>
<p id=112 class="line"><span>&nbsp;112</span><comment>&nbsp;*&nbsp;@param&nbsp;sample&nbsp;The&nbsp;value&nbsp;to&nbsp;cast.</comment></p>
<p id=113 class="line"><span>&nbsp;113</span><comment>&nbsp;*&nbsp;@returns&nbsp;The&nbsp;result&nbsp;of&nbsp;the&nbsp;cast.&nbsp;</comment></p>
<p id=114 class="line"><span>&nbsp;114</span><comment>&nbsp;*&nbsp;@description&nbsp;Casts&nbsp;the&nbsp;sample&nbsp;to&nbsp;the&nbsp;specified&nbsp;data&nbsp;type.</comment></p>
<p id=115 class="line"><span>&nbsp;115</span><comment>&nbsp;*/</comment></p>
<p id=116 class="line"><span>&nbsp;116</span>function&nbsp;castVal(type:Type,&nbsp;val:DataVal):DataVal&nbsp;{</p>
<p id=117 class="line"><span>&nbsp;117</span>&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;result:DataVal&nbsp;=&nbsp;val;</p>
<p id=118 class="line"><span>&nbsp;118</span>&nbsp;&nbsp;&nbsp;&nbsp;switch&nbsp;(type)&nbsp;{</p>
<p id=119 class="line"><span>&nbsp;119</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>'date'</quote>:&nbsp;&nbsp;&nbsp;&nbsp;</p>
<p id=120 class="line"><span>&nbsp;120</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(val&nbsp;instanceof&nbsp;Date)&nbsp;{&nbsp;return&nbsp;val;&nbsp;}</p>
<p id=121 class="line"><span>&nbsp;121</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result&nbsp;=&nbsp;toDate(val);</p>
<p id=122 class="line"><span>&nbsp;122</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(isNaN(result.getTime()))&nbsp;{&nbsp;result&nbsp;=&nbsp;null;&nbsp;}</p>
<p id=123 class="line"><span>&nbsp;123</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;result;</p>
<p id=124 class="line"><span>&nbsp;124</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>'percent'</quote>:&nbsp;</p>
<p id=125 class="line"><span>&nbsp;125</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(typeof&nbsp;val&nbsp;===&nbsp;<quote>'string'</quote>)&nbsp;{</p>
<p id=126 class="line"><span>&nbsp;126</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;num&nbsp;=&nbsp;parseFloat(val);</p>
<p id=127 class="line"><span>&nbsp;127</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;(&lt;string&gt;val).endsWith(<quote>'%'</quote>)?&nbsp;num/100&nbsp;:&nbsp;num;</p>
<p id=128 class="line"><span>&nbsp;128</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{</p>
<p id=129 class="line"><span>&nbsp;129</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;val;</p>
<p id=130 class="line"><span>&nbsp;130</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=131 class="line"><span>&nbsp;131</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;if&nbsp;(isNaN(&lt;number&gt;result))&nbsp;{&nbsp;result&nbsp;=&nbsp;null;&nbsp;}</comment></p>
<p id=132 class="line"><span>&nbsp;132</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;break;</comment></p>
<p id=133 class="line"><span>&nbsp;133</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>'currency'</quote>:</p>
<p id=134 class="line"><span>&nbsp;134</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;replace&nbsp;all&nbsp;except&nbsp;<quote>'e/E'</quote>,&nbsp;<quote>'.'</quote>,&nbsp;<quote>'+/-'</quote>&nbsp;and&nbsp;digits</comment></p>
<p id=135 class="line"><span>&nbsp;135</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result&nbsp;=&nbsp;(typeof&nbsp;val&nbsp;===&nbsp;<quote>'string'</quote>)?&nbsp;val.replace(/[^eE\+\-\.\d]/g,&nbsp;<quote>''</quote>)&nbsp;:&nbsp;val;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;				</p>
<p id=136 class="line"><span>&nbsp;136</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/*&nbsp;falls&nbsp;through&nbsp;*/</comment></p>
<p id=137 class="line"><span>&nbsp;137</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>'number'</quote>:&nbsp;&nbsp;</p>
<p id=138 class="line"><span>&nbsp;138</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(typeof&nbsp;result&nbsp;===&nbsp;<quote>'string'</quote>)&nbsp;{&nbsp;result&nbsp;=&nbsp;parseFloat(result);&nbsp;}</p>
<p id=139 class="line"><span>&nbsp;139</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(isNaN(&lt;number&gt;result))&nbsp;{&nbsp;result&nbsp;=&nbsp;null;&nbsp;}</p>
<p id=140 class="line"><span>&nbsp;140</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;result;</p>
<p id=141 class="line"><span>&nbsp;141</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;default:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;<quote>''</quote>+val;</p>
<p id=142 class="line"><span>&nbsp;142</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=143 class="line"><span>&nbsp;143</span>}&nbsp;&nbsp;&nbsp;</p>
<p id=144 class="line"><span>&nbsp;144</span></p>
<p id=145 class="line"><span>&nbsp;145</span>export&nbsp;function&nbsp;findDomain(data:&nbsp;DataRow[],&nbsp;col:number,&nbsp;type:Type,&nbsp;domain:Domain):Domain&nbsp;{</p>
<p id=146 class="line"><span>&nbsp;146</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(domain===undefined)&nbsp;{&nbsp;domain&nbsp;=&nbsp;&lt;Domain&gt;[];&nbsp;}</p>
<p id=147 class="line"><span>&nbsp;147</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(col&nbsp;===&nbsp;undefined)&nbsp;{&nbsp;<comment>//&nbsp;use&nbsp;array&nbsp;index&nbsp;as&nbsp;domain</comment></p>
<p id=148 class="line"><span>&nbsp;148</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;domain[0]&nbsp;=&nbsp;0;</p>
<p id=149 class="line"><span>&nbsp;149</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;domain[1]&nbsp;=&nbsp;data.length-1;</p>
<p id=150 class="line"><span>&nbsp;150</span>&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{</p>
<p id=151 class="line"><span>&nbsp;151</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;expand:(r:DataRow)&nbsp;=&gt;&nbsp;void;</p>
<p id=152 class="line"><span>&nbsp;152</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;switch(type)&nbsp;{</p>
<p id=153 class="line"><span>&nbsp;153</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;Types.name:&nbsp;</p>
<p id=154 class="line"><span>&nbsp;154</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expand&nbsp;=&nbsp;(r:DataRow)&nbsp;=&gt;&nbsp;(&lt;string[]&gt;domain).indexOf(<quote>''</quote>+r[col])&nbsp;&lt;&nbsp;0?&nbsp;&nbsp;(&lt;string[]&gt;domain).push(<quote>''</quote>+r[col])&nbsp;:&nbsp;<quote>''</quote>;</p>
<p id=155 class="line"><span>&nbsp;155</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;</p>
<p id=156 class="line"><span>&nbsp;156</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;Types.date:&nbsp;</p>
<p id=157 class="line"><span>&nbsp;157</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expand&nbsp;=&nbsp;(r:DataRow)&nbsp;=&gt;&nbsp;{</p>
<p id=158 class="line"><span>&nbsp;158</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;v:Date&nbsp;=&nbsp;toDate(r[col]);</p>
<p id=159 class="line"><span>&nbsp;159</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(domain[0]===undefined)&nbsp;{&nbsp;domain[0]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=160 class="line"><span>&nbsp;160</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(domain[1]===undefined)&nbsp;{&nbsp;domain[1]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=161 class="line"><span>&nbsp;161</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(v!==undefined&nbsp;&&&nbsp;v!==null)&nbsp;{</p>
<p id=162 class="line"><span>&nbsp;162</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(v&lt;domain[0])&nbsp;{&nbsp;domain[0]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=163 class="line"><span>&nbsp;163</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else&nbsp;if&nbsp;(v&gt;domain[1])&nbsp;{&nbsp;domain[1]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=164 class="line"><span>&nbsp;164</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=165 class="line"><span>&nbsp;165</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};</p>
<p id=166 class="line"><span>&nbsp;166</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;</p>
<p id=167 class="line"><span>&nbsp;167</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;Types.number:</p>
<p id=168 class="line"><span>&nbsp;168</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;Types.percent:</p>
<p id=169 class="line"><span>&nbsp;169</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;default:&nbsp;</p>
<p id=170 class="line"><span>&nbsp;170</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expand&nbsp;=&nbsp;(r:DataRow)&nbsp;=&gt;&nbsp;{</p>
<p id=171 class="line"><span>&nbsp;171</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;v:number&nbsp;=&nbsp;parseFloat(r[col].toString());</p>
<p id=172 class="line"><span>&nbsp;172</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(domain[0]===undefined)&nbsp;{&nbsp;domain[0]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=173 class="line"><span>&nbsp;173</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(domain[1]===undefined)&nbsp;{&nbsp;domain[1]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=174 class="line"><span>&nbsp;174</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(v!==undefined&nbsp;&&&nbsp;v!==null)&nbsp;{</p>
<p id=175 class="line"><span>&nbsp;175</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(v&lt;domain[0])&nbsp;{&nbsp;domain[0]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=176 class="line"><span>&nbsp;176</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else&nbsp;if&nbsp;(v&gt;domain[1])&nbsp;{&nbsp;domain[1]&nbsp;=&nbsp;v;&nbsp;}</p>
<p id=177 class="line"><span>&nbsp;177</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=178 class="line"><span>&nbsp;178</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};</p>
<p id=179 class="line"><span>&nbsp;179</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=180 class="line"><span>&nbsp;180</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;data.forEach(expand);</p>
<p id=181 class="line"><span>&nbsp;181</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=182 class="line"><span>&nbsp;182</span>&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;domain;</p>
<p id=183 class="line"><span>&nbsp;183</span>}</p>
<p id=184 class="line"><span>&nbsp;184</span></p>
<p id=185 class="line"><span>&nbsp;185</span><comment>/**</comment></p>
<p id=186 class="line"><span>&nbsp;186</span><comment>&nbsp;*&nbsp;@description&nbsp;determines&nbsp;the&nbsp;data&nbsp;type.&nbsp;Supported&nbsp;types&nbsp;are&nbsp;</comment></p>
<p id=187 class="line"><span>&nbsp;187</span><comment>&nbsp;*&nbsp;```</comment></p>
<p id=188 class="line"><span>&nbsp;188</span><comment>&nbsp;*&nbsp;<quote>'date'</quote>:&nbsp;&nbsp;&nbsp;&nbsp;sample&nbsp;represents&nbsp;a&nbsp;Date,&nbsp;either&nbsp;as&nbsp;a&nbsp;Date&nbsp;object&nbsp;or&nbsp;a&nbsp;String&nbsp;</comment></p>
<p id=189 class="line"><span>&nbsp;189</span><comment>&nbsp;*&nbsp;<quote>'number'</quote>:&nbsp;&nbsp;sample&nbsp;represents&nbsp;a&nbsp;number</comment></p>
<p id=190 class="line"><span>&nbsp;190</span><comment>&nbsp;*&nbsp;<quote>'percent'</quote>:&nbsp;sample&nbsp;represents&nbsp;a&nbsp;percentage&nbsp;(special&nbsp;case&nbsp;of&nbsp;a&nbsp;real&nbsp;number)</comment></p>
<p id=191 class="line"><span>&nbsp;191</span><comment>&nbsp;*&nbsp;<quote>'nominal'</quote>:&nbsp;sample&nbsp;represents&nbsp;a&nbsp;nominal&nbsp;(ordinal&nbsp;or&nbsp;categorical)&nbsp;value</comment></p>
<p id=192 class="line"><span>&nbsp;192</span><comment>&nbsp;*&nbsp;```</comment></p>
<p id=193 class="line"><span>&nbsp;193</span><comment>&nbsp;*&nbsp;@param&nbsp;val&nbsp;the&nbsp;value&nbsp;to&nbsp;bve&nbsp;typed.</comment></p>
<p id=194 class="line"><span>&nbsp;194</span><comment>&nbsp;*&nbsp;@returns&nbsp;the&nbsp;type&nbsp;(<quote>'number'</quote>,&nbsp;<quote>'date'</quote>,&nbsp;<quote>'percent'</quote>,&nbsp;<quote>'nominal'</quote>,&nbsp;<quote>'currency'</quote>)&nbsp;corresponding&nbsp;to&nbsp;the&nbsp;sample</comment></p>
<p id=195 class="line"><span>&nbsp;195</span><comment>&nbsp;*/</comment></p>
<p id=196 class="line"><span>&nbsp;196</span>function&nbsp;findType(val:DataVal):Type&nbsp;{</p>
<p id=197 class="line"><span>&nbsp;197</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!val&nbsp;||&nbsp;val===<quote>''</quote>)&nbsp;{&nbsp;return&nbsp;null;&nbsp;}</p>
<p id=198 class="line"><span>&nbsp;198</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(val&nbsp;instanceof&nbsp;Date)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;return&nbsp;<quote>'date'</quote>;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;if&nbsp;val&nbsp;is&nbsp;already&nbsp;a&nbsp;date</comment></p>
<p id=199 class="line"><span>&nbsp;199</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(typeof&nbsp;val&nbsp;===&nbsp;<quote>'number'</quote>)&nbsp;{&nbsp;return&nbsp;<quote>'number'</quote>;&nbsp;}&nbsp;&nbsp;&nbsp;<comment>//&nbsp;if&nbsp;val&nbsp;is&nbsp;already&nbsp;a&nbsp;number</comment></p>
<p id=200 class="line"><span>&nbsp;200</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;</p>
<p id=201 class="line"><span>&nbsp;201</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;else:&nbsp;val&nbsp;is&nbsp;a&nbsp;string:</comment></p>
<p id=202 class="line"><span>&nbsp;202</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;strVal&nbsp;=&nbsp;&lt;string&gt;val;</p>
<p id=203 class="line"><span>&nbsp;203</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(<quote>''</quote>+parseFloat(strVal)&nbsp;===&nbsp;strVal)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;return&nbsp;<quote>'number'</quote>;&nbsp;}</p>
<p id=204 class="line"><span>&nbsp;204</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(strVal.startsWith(<quote>'$'</quote>)&nbsp;&&&nbsp;!isNaN(parseFloat(strVal.slice(1))))&nbsp;{&nbsp;return&nbsp;<quote>'currency'</quote>;&nbsp;}</p>
<p id=205 class="line"><span>&nbsp;205</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(strVal.endsWith(<quote>'%'</quote>)&nbsp;&&&nbsp;!isNaN(parseFloat(strVal)))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;return&nbsp;<quote>'percent'</quote>;&nbsp;}</p>
<p id=206 class="line"><span>&nbsp;206</span>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!isNaN(toDate(strVal).getTime()))	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;return&nbsp;<quote>'date'</quote>;&nbsp;}</p>
<p id=207 class="line"><span>&nbsp;207</span></p>
<p id=208 class="line"><span>&nbsp;208</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;//&nbsp;european&nbsp;large&nbsp;number&nbsp;currency&nbsp;representation:&nbsp;<quote>'$dd[,ddd]'</quote></comment></p>
<p id=209 class="line"><span>&nbsp;209</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;if&nbsp;((/^\$\d{0,2}((,\d\d\d)*)/g).test(val))&nbsp;{&nbsp;</comment></p>
<p id=210 class="line"><span>&nbsp;210</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!isNaN(parseFloat(val.trim().replace(/[^eE\+\-\.\d]/g,&nbsp;<quote>''</quote>).replace(/,/g,&nbsp;<quote>''</quote>))))&nbsp;{&nbsp;</comment></p>
<p id=211 class="line"><span>&nbsp;211</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;Data.type.currency;&nbsp;</comment></p>
<p id=212 class="line"><span>&nbsp;212</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</comment></p>
<p id=213 class="line"><span>&nbsp;213</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;}</comment></p>
<p id=214 class="line"><span>&nbsp;214</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;switch&nbsp;(strVal.toLowerCase())&nbsp;{</p>
<p id=215 class="line"><span>&nbsp;215</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>"null"</quote>:&nbsp;break;</p>
<p id=216 class="line"><span>&nbsp;216</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>"#ref!"</quote>:&nbsp;break;</p>
<p id=217 class="line"><span>&nbsp;217</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;default:&nbsp;if&nbsp;(val.length&gt;0)&nbsp;{&nbsp;return&nbsp;<quote>'name'</quote>;&nbsp;}</p>
<p id=218 class="line"><span>&nbsp;218</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=219 class="line"><span>&nbsp;219</span>&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;null;</p>
<p id=220 class="line"><span>&nbsp;220</span>}&nbsp;&nbsp;&nbsp;&nbsp;</p>
<p id=221 class="line"><span>&nbsp;221</span></p>
<p id=222 class="line"><span>&nbsp;222</span><comment>/**</comment></p>
<p id=223 class="line"><span>&nbsp;223</span><comment>&nbsp;*&nbsp;#&nbsp;Data</comment></p>
<p id=224 class="line"><span>&nbsp;224</span><comment>&nbsp;*&nbsp;A&nbsp;simple&nbsp;in-memory&nbsp;database&nbsp;that&nbsp;holds&nbsp;data&nbsp;in&nbsp;rows&nbsp;of&nbsp;columns.</comment></p>
<p id=225 class="line"><span>&nbsp;225</span><comment>&nbsp;*&nbsp;</comment></p>
<p id=226 class="line"><span>&nbsp;226</span><comment>&nbsp;*/</comment></p>
<p id=227 class="line"><span>&nbsp;227</span>export&nbsp;class&nbsp;Data&nbsp;{</p>
<p id=228 class="line"><span>&nbsp;228</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//----------------------------</comment></p>
<p id=229 class="line"><span>&nbsp;229</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;public&nbsp;part</comment></p>
<p id=230 class="line"><span>&nbsp;230</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//----------------------------</comment></p>
<p id=231 class="line"><span>&nbsp;231</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;static&nbsp;type&nbsp;=&nbsp;{</p>
<p id=232 class="line"><span>&nbsp;232</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;numeric&nbsp;values&nbsp;*/</comment></p>
<p id=233 class="line"><span>&nbsp;233</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;number:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Type&gt;<quote>'number'</quote>,</p>
<p id=234 class="line"><span>&nbsp;234</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;nominal&nbsp;values,&nbsp;represented&nbsp;by&nbsp;arbitrary&nbsp;words&nbsp;*/</comment></p>
<p id=235 class="line"><span>&nbsp;235</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Type&gt;<quote>'name'</quote>,</p>
<p id=236 class="line"><span>&nbsp;236</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;date&nbsp;values&nbsp;*/</comment></p>
<p id=237 class="line"><span>&nbsp;237</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Type&gt;<quote>'date'</quote>,</p>
<p id=238 class="line"><span>&nbsp;238</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;currency&nbsp;values.&nbsp;Currently&nbsp;support6ed&nbsp;are&nbsp;values&nbsp;ofg&nbsp;the&nbsp;format&nbsp;<quote>'$dd[,ddd]'</quote>&nbsp;*/</comment></p>
<p id=239 class="line"><span>&nbsp;239</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currency:&nbsp;&nbsp;&nbsp;&lt;Type&gt;<quote>'currency'</quote>,</p>
<p id=240 class="line"><span>&nbsp;240</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;percent&nbsp;values:&nbsp;<quote>'d%'</quote>&nbsp;*/</comment></p>
<p id=241 class="line"><span>&nbsp;241</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;percent:&nbsp;&nbsp;&nbsp;&nbsp;&lt;Type&gt;<quote>'percent'</quote>,</p>
<p id=242 class="line"><span>&nbsp;242</span><comment>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nominal:&nbsp;&nbsp;&nbsp;&nbsp;<quote>'nominal'</quote></comment></p>
<p id=243 class="line"><span>&nbsp;243</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;};</p>
<p id=244 class="line"><span>&nbsp;244</span></p>
<p id=245 class="line"><span>&nbsp;245</span>&nbsp;&nbsp;&nbsp;&nbsp;constructor(dataset?:DataSet|DataTable)&nbsp;{</p>
<p id=246 class="line"><span>&nbsp;246</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(dataset)&nbsp;{&nbsp;this.importData(dataset);&nbsp;}</p>
<p id=247 class="line"><span>&nbsp;247</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=248 class="line"><span>&nbsp;248</span></p>
<p id=249 class="line"><span>&nbsp;249</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=250 class="line"><span>&nbsp;250</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;`name`&nbsp;field&nbsp;for&nbsp;this&nbsp;data&nbsp;base,&nbsp;if&nbsp;any</comment></p>
<p id=251 class="line"><span>&nbsp;251</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=252 class="line"><span>&nbsp;252</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;getName():string&nbsp;{</p>
<p id=253 class="line"><span>&nbsp;253</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this.name;</p>
<p id=254 class="line"><span>&nbsp;254</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=255 class="line"><span>&nbsp;255</span></p>
<p id=256 class="line"><span>&nbsp;256</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=257 class="line"><span>&nbsp;257</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Imports&nbsp;data&nbsp;from&nbsp;an&nbsp;object&nbsp;literal&nbsp;or&nbsp;an&nbsp;array&nbsp;whos&nbsp;header&nbsp;row&nbsp;contains&nbsp;the&nbsp;column&nbsp;numbers</comment></p>
<p id=258 class="line"><span>&nbsp;258</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;data&nbsp;the&nbsp;data&nbsp;set&nbsp;to&nbsp;import</comment></p>
<p id=259 class="line"><span>&nbsp;259</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=260 class="line"><span>&nbsp;260</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;importData(dataset:DataSet|DataTable)&nbsp;{</p>
<p id=261 class="line"><span>&nbsp;261</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.name&nbsp;=&nbsp;<quote>'data'</quote>+(Math.round(1000*Math.random()));</p>
<p id=262 class="line"><span>&nbsp;262</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(dataset)&nbsp;{</p>
<p id=263 class="line"><span>&nbsp;263</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(dataset&nbsp;instanceof&nbsp;Array)&nbsp;{</p>
<p id=264 class="line"><span>&nbsp;264</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;names&nbsp;=&nbsp;&lt;string[]&gt;dataset[0];</p>
<p id=265 class="line"><span>&nbsp;265</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;rows&nbsp;=&nbsp;dataset.slice(1);</p>
<p id=266 class="line"><span>&nbsp;266</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.setData(rows,&nbsp;names);</p>
<p id=267 class="line"><span>&nbsp;267</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{</p>
<p id=268 class="line"><span>&nbsp;268</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(dataset.name)&nbsp;{&nbsp;this.name&nbsp;=&nbsp;dataset.name;&nbsp;}</p>
<p id=269 class="line"><span>&nbsp;269</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.setData(dataset.rows,&nbsp;dataset.colNames);</p>
<p id=270 class="line"><span>&nbsp;270</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=271 class="line"><span>&nbsp;271</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=272 class="line"><span>&nbsp;272</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=273 class="line"><span>&nbsp;273</span></p>
<p id=274 class="line"><span>&nbsp;274</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=275 class="line"><span>&nbsp;275</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Exports&nbsp;to&nbsp;an&nbsp;object&nbsp;literal</comment></p>
<p id=276 class="line"><span>&nbsp;276</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=277 class="line"><span>&nbsp;277</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;export():DataSet&nbsp;{</p>
<p id=278 class="line"><span>&nbsp;278</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;{</p>
<p id=279 class="line"><span>&nbsp;279</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rows:&nbsp;this.getData(),</p>
<p id=280 class="line"><span>&nbsp;280</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;colNames:this.colNames()</p>
<p id=281 class="line"><span>&nbsp;281</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};</p>
<p id=282 class="line"><span>&nbsp;282</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=283 class="line"><span>&nbsp;283</span></p>
<p id=284 class="line"><span>&nbsp;284</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=285 class="line"><span>&nbsp;285</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;returns&nbsp;the&nbsp;2D&nbsp;array&nbsp;underlying&nbsp;the&nbsp;data&nbsp;base.</comment></p>
<p id=286 class="line"><span>&nbsp;286</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=287 class="line"><span>&nbsp;287</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;getData():DataRow[]&nbsp;{</p>
<p id=288 class="line"><span>&nbsp;288</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this.data;</p>
<p id=289 class="line"><span>&nbsp;289</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=290 class="line"><span>&nbsp;290</span></p>
<p id=291 class="line"><span>&nbsp;291</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=292 class="line"><span>&nbsp;292</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Returns&nbsp;the&nbsp;values&nbsp;in&nbsp;the&nbsp;specified&nbsp;column&nbsp;as&nbsp;a&nbsp;new&nbsp;array.</comment></p>
<p id=293 class="line"><span>&nbsp;293</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;col&nbsp;the&nbsp;column&nbsp;to&nbsp;return.</comment></p>
<p id=294 class="line"><span>&nbsp;294</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=295 class="line"><span>&nbsp;295</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;getColumn(col:ColumnReference):&nbsp;DataVal[]&nbsp;{</p>
<p id=296 class="line"><span>&nbsp;296</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;cn&nbsp;=&nbsp;this.colNumber(col);</p>
<p id=297 class="line"><span>&nbsp;297</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this.data.map((row:DataRow)&nbsp;=&gt;&nbsp;row[cn]);</p>
<p id=298 class="line"><span>&nbsp;298</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=299 class="line"><span>&nbsp;299</span></p>
<p id=300 class="line"><span>&nbsp;300</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=301 class="line"><span>&nbsp;301</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;adds&nbsp;a&nbsp;new&nbsp;column&nbsp;to&nbsp;the&nbsp;data&nbsp;set.&nbsp;if&nbsp;`newCol`&nbsp;already&nbsp;exists,&nbsp;</comment></p>
<p id=302 class="line"><span>&nbsp;302</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;the&nbsp;column&nbsp;index&nbsp;is&nbsp;returned&nbsp;without&nbsp;change.</comment></p>
<p id=303 class="line"><span>&nbsp;303</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;col&nbsp;the&nbsp;name&nbsp;of&nbsp;the&nbsp;new&nbsp;column</comment></p>
<p id=304 class="line"><span>&nbsp;304</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;index&nbsp;for&nbsp;the&nbsp;new&nbsp;column</comment></p>
<p id=305 class="line"><span>&nbsp;305</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=306 class="line"><span>&nbsp;306</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;colAdd(col:string):MetaStruct&nbsp;{</p>
<p id=307 class="line"><span>&nbsp;307</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;m&nbsp;=&nbsp;this.getMeta(col);</p>
<p id=308 class="line"><span>&nbsp;308</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(m&nbsp;===&nbsp;undefined)&nbsp;{&nbsp;</p>
<p id=309 class="line"><span>&nbsp;309</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m&nbsp;=&nbsp;this.meta[col]&nbsp;=&nbsp;&lt;MetaStruct&gt;{};</p>
<p id=310 class="line"><span>&nbsp;310</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m.name&nbsp;&nbsp;&nbsp;=&nbsp;col;&nbsp;</p>
<p id=311 class="line"><span>&nbsp;311</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m.column&nbsp;=&nbsp;this.meta.length;</p>
<p id=312 class="line"><span>&nbsp;312</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.meta.push(m);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;access&nbsp;name&nbsp;by&nbsp;both&nbsp;column&nbsp;name&nbsp;and&nbsp;index</comment></p>
<p id=313 class="line"><span>&nbsp;313</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m.cast&nbsp;	&nbsp;&nbsp;&nbsp;=&nbsp;false;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;has&nbsp;not&nbsp;been&nbsp;cast&nbsp;yet</comment></p>
<p id=314 class="line"><span>&nbsp;314</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m.accessed&nbsp;=&nbsp;false;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;has&nbsp;not&nbsp;been&nbsp;accessed&nbsp;yet</comment></p>
<p id=315 class="line"><span>&nbsp;315</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=316 class="line"><span>&nbsp;316</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;m;</p>
<p id=317 class="line"><span>&nbsp;317</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=318 class="line"><span>&nbsp;318</span></p>
<p id=319 class="line"><span>&nbsp;319</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=320 class="line"><span>&nbsp;320</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;initializes&nbsp;the&nbsp;specifed&nbsp;column&nbsp;with&nbsp;values,&nbsp;adding&nbsp;a&nbsp;new&nbsp;column&nbsp;if&nbsp;needed.&nbsp;</comment></p>
<p id=321 class="line"><span>&nbsp;321</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;If&nbsp;`val`is&nbsp;a&nbsp;function,&nbsp;it&nbsp;is&nbsp;called&nbsp;as&nbsp;```</comment></p>
<p id=322 class="line"><span>&nbsp;322</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;val(colValue:DataVal,&nbsp;rowIndex:number,&nbsp;row:DataRow)</comment></p>
<p id=323 class="line"><span>&nbsp;323</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=324 class="line"><span>&nbsp;324</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;col&nbsp;the&nbsp;column&nbsp;to&nbsp;initialize</comment></p>
<p id=325 class="line"><span>&nbsp;325</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;initializer&nbsp;the&nbsp;value&nbsp;to&nbsp;initialize&nbsp;with,&nbsp;or&nbsp;a&nbsp;function&nbsp;whose&nbsp;return</comment></p>
<p id=326 class="line"><span>&nbsp;326</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;value&nbsp;is&nbsp;used&nbsp;to&nbsp;initialize&nbsp;the&nbsp;column</comment></p>
<p id=327 class="line"><span>&nbsp;327</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;initialized&nbsp;column&nbsp;number</comment></p>
<p id=328 class="line"><span>&nbsp;328</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=329 class="line"><span>&nbsp;329</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;colInitialize(col:ColumnReference,&nbsp;initializer:initFn|DataVal):number&nbsp;{</p>
<p id=330 class="line"><span>&nbsp;330</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;fn&nbsp;=&nbsp;typeof&nbsp;initializer&nbsp;===&nbsp;<quote>'function'</quote>;</p>
<p id=331 class="line"><span>&nbsp;331</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;cn:MetaStruct&nbsp;=&nbsp;this.getMeta(col);</p>
<p id=332 class="line"><span>&nbsp;332</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!cn)&nbsp;{</p>
<p id=333 class="line"><span>&nbsp;333</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(typeof&nbsp;col&nbsp;===&nbsp;<quote>'string'</quote>)&nbsp;{&nbsp;cn&nbsp;=&nbsp;this.colAdd(col);&nbsp;}</p>
<p id=334 class="line"><span>&nbsp;334</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else&nbsp;{&nbsp;throw&nbsp;new&nbsp;Error(`column&nbsp;${col}&nbsp;does&nbsp;not&nbsp;exist&nbsp;in&nbsp;Data`);&nbsp;}</p>
<p id=335 class="line"><span>&nbsp;335</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=336 class="line"><span>&nbsp;336</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.data.map((row:DataRow,&nbsp;rowIndex:number)&nbsp;=&gt;</p>
<p id=337 class="line"><span>&nbsp;337</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;row[cn.column]&nbsp;=&nbsp;fn?&nbsp;(&lt;initFn&gt;initializer)(row[cn.column],&nbsp;rowIndex,&nbsp;row)&nbsp;:&nbsp;&lt;DataVal&gt;initializer</p>
<p id=338 class="line"><span>&nbsp;338</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</p>
<p id=339 class="line"><span>&nbsp;339</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;cn.column;</p>
<p id=340 class="line"><span>&nbsp;340</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=341 class="line"><span>&nbsp;341</span></p>
<p id=342 class="line"><span>&nbsp;342</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=343 class="line"><span>&nbsp;343</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;returns&nbsp;the&nbsp;column&nbsp;index&nbsp;of&nbsp;the&nbsp;specified&nbsp;column.&nbsp;</comment></p>
<p id=344 class="line"><span>&nbsp;344</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;`col`&nbsp;can&nbsp;be&nbsp;either&nbsp;an&nbsp;index&nbsp;or&nbsp;a&nbsp;name.</comment></p>
<p id=345 class="line"><span>&nbsp;345</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;column&nbsp;the&nbsp;data&nbsp;column,&nbsp;name&nbsp;or&nbsp;index,&nbsp;for&nbsp;which&nbsp;to&nbsp;return&nbsp;the&nbsp;index.&nbsp;</comment></p>
<p id=346 class="line"><span>&nbsp;346</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;column&nbsp;number&nbsp;or&nbsp;`undefined`.</comment></p>
<p id=347 class="line"><span>&nbsp;347</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=348 class="line"><span>&nbsp;348</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;colNumber(col:ColumnReference)&nbsp;{</p>
<p id=349 class="line"><span>&nbsp;349</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;m&nbsp;=&nbsp;this.getMeta(col);</p>
<p id=350 class="line"><span>&nbsp;350</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!m)&nbsp;{&nbsp;return&nbsp;undefined;&nbsp;}</p>
<p id=351 class="line"><span>&nbsp;351</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else&nbsp;{</p>
<p id=352 class="line"><span>&nbsp;352</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m.accessed&nbsp;=&nbsp;true;&nbsp;</p>
<p id=353 class="line"><span>&nbsp;353</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;m.column;&nbsp;</p>
<p id=354 class="line"><span>&nbsp;354</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=355 class="line"><span>&nbsp;355</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=356 class="line"><span>&nbsp;356</span>&nbsp;&nbsp;&nbsp;&nbsp;</p>
<p id=357 class="line"><span>&nbsp;357</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=358 class="line"><span>&nbsp;358</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;returns&nbsp;the&nbsp;column&nbsp;name&nbsp;for&nbsp;the&nbsp;specified&nbsp;column.&nbsp;</comment></p>
<p id=359 class="line"><span>&nbsp;359</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;`col`&nbsp;can&nbsp;be&nbsp;either&nbsp;an&nbsp;index&nbsp;or&nbsp;a&nbsp;name.</comment></p>
<p id=360 class="line"><span>&nbsp;360</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;column&nbsp;the&nbsp;data&nbsp;column,&nbsp;name&nbsp;or&nbsp;index.&nbsp;</comment></p>
<p id=361 class="line"><span>&nbsp;361</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;column&nbsp;name&nbsp;or&nbsp;`undefined`.</comment></p>
<p id=362 class="line"><span>&nbsp;362</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=363 class="line"><span>&nbsp;363</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;colName(col:ColumnReference):string&nbsp;{</p>
<p id=364 class="line"><span>&nbsp;364</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;m&nbsp;=&nbsp;this.getMeta(col);</p>
<p id=365 class="line"><span>&nbsp;365</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!m)&nbsp;{&nbsp;return&nbsp;undefined;&nbsp;}</p>
<p id=366 class="line"><span>&nbsp;366</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m.accessed&nbsp;=&nbsp;true;&nbsp;</p>
<p id=367 class="line"><span>&nbsp;367</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;m.name;&nbsp;</p>
<p id=368 class="line"><span>&nbsp;368</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=369 class="line"><span>&nbsp;369</span></p>
<p id=370 class="line"><span>&nbsp;370</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=371 class="line"><span>&nbsp;371</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;returns&nbsp;the&nbsp;names&nbsp;for&nbsp;all&nbsp;columns.&nbsp;</comment></p>
<p id=372 class="line"><span>&nbsp;372</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;an&nbsp;array&nbsp;of&nbsp;strings&nbsp;with&nbsp;the&nbsp;names.</comment></p>
<p id=373 class="line"><span>&nbsp;373</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=374 class="line"><span>&nbsp;374</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;colNames():string[]&nbsp;{</p>
<p id=375 class="line"><span>&nbsp;375</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this.meta.map((m:MetaStruct)&nbsp;=&gt;&nbsp;m.name);&nbsp;</p>
<p id=376 class="line"><span>&nbsp;376</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=377 class="line"><span>&nbsp;377</span></p>
<p id=378 class="line"><span>&nbsp;378</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=379 class="line"><span>&nbsp;379</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;returns&nbsp;the&nbsp;column&nbsp;type&nbsp;for&nbsp;the&nbsp;specified&nbsp;column.&nbsp;</comment></p>
<p id=380 class="line"><span>&nbsp;380</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;`col`&nbsp;can&nbsp;be&nbsp;either&nbsp;an&nbsp;index&nbsp;or&nbsp;a&nbsp;name.</comment></p>
<p id=381 class="line"><span>&nbsp;381</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;column&nbsp;the&nbsp;data&nbsp;column,&nbsp;name&nbsp;or&nbsp;index.&nbsp;</comment></p>
<p id=382 class="line"><span>&nbsp;382</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;column&nbsp;type.</comment></p>
<p id=383 class="line"><span>&nbsp;383</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=384 class="line"><span>&nbsp;384</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;colType(col:ColumnReference):Type&nbsp;{&nbsp;</p>
<p id=385 class="line"><span>&nbsp;385</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;meta&nbsp;=&nbsp;this.getMeta(col);</p>
<p id=386 class="line"><span>&nbsp;386</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;meta?&nbsp;meta.types[0].type&nbsp;:&nbsp;<quote>'name'</quote>;</p>
<p id=387 class="line"><span>&nbsp;387</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=388 class="line"><span>&nbsp;388</span></p>
<p id=389 class="line"><span>&nbsp;389</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=390 class="line"><span>&nbsp;390</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;modifies&nbsp;`domain`&nbsp;to&nbsp;include&nbsp;all&nbsp;values&nbsp;in&nbsp;column&nbsp;`col`.</comment></p>
<p id=391 class="line"><span>&nbsp;391</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;If&nbsp;no&nbsp;`col`&nbsp;is&nbsp;specified,&nbsp;the&nbsp;range&nbsp;of&nbsp;data&nbsp;indexes&nbsp;is&nbsp;returned.</comment></p>
<p id=392 class="line"><span>&nbsp;392</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;col&nbsp;optional;&nbsp;the&nbsp;column&nbsp;name&nbsp;or&nbsp;index&nbsp;</comment></p>
<p id=393 class="line"><span>&nbsp;393</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;domain&nbsp;optional;&nbsp;the&nbsp;Domain&nbsp;range&nbsp;to&nbsp;update</comment></p>
<p id=394 class="line"><span>&nbsp;394</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;updated&nbsp;domain</comment></p>
<p id=395 class="line"><span>&nbsp;395</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=396 class="line"><span>&nbsp;396</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;findDomain(col?:ColumnReference,&nbsp;domain?:Domain):Domain&nbsp;{</p>
<p id=397 class="line"><span>&nbsp;397</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;findDomain(this.data,&nbsp;this.colNumber(col),&nbsp;this.colType(col),&nbsp;domain);</p>
<p id=398 class="line"><span>&nbsp;398</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=399 class="line"><span>&nbsp;399</span></p>
<p id=400 class="line"><span>&nbsp;400</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;castData()&nbsp;{</p>
<p id=401 class="line"><span>&nbsp;401</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.meta.forEach((c:MetaStruct)&nbsp;=&gt;&nbsp;{</p>
<p id=402 class="line"><span>&nbsp;402</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;col&nbsp;=&nbsp;c.column;</p>
<p id=403 class="line"><span>&nbsp;403</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!c.cast)&nbsp;{</p>
<p id=404 class="line"><span>&nbsp;404</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.data.forEach((row:DataRow)&nbsp;=&gt;&nbsp;row[col]&nbsp;=&nbsp;castVal(c.types[0].type,&nbsp;row[col]));</p>
<p id=405 class="line"><span>&nbsp;405</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=406 class="line"><span>&nbsp;406</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c.cast&nbsp;=&nbsp;true;</p>
<p id=407 class="line"><span>&nbsp;407</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});</p>
<p id=408 class="line"><span>&nbsp;408</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=409 class="line"><span>&nbsp;409</span></p>
<p id=410 class="line"><span>&nbsp;410</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=411 class="line"><span>&nbsp;411</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;filters&nbsp;this&nbsp;data&nbsp;set&nbsp;and&nbsp;returns&nbsp;a&nbsp;new&nbsp;data&nbsp;set&nbsp;with&nbsp;a&nbsp;</comment></p>
<p id=412 class="line"><span>&nbsp;412</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;shallow&nbsp;copy&nbsp;of&nbsp;rows&nbsp;that&nbsp;pass&nbsp;the&nbsp;`condition`.</comment></p>
<p id=413 class="line"><span>&nbsp;413</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;See&nbsp;{@link&nbsp;DataFilters&nbsp;DataFilters}&nbsp;for&nbsp;rules&nbsp;and&nbsp;examples&nbsp;on&nbsp;how&nbsp;to&nbsp;construct&nbsp;conditions.</comment></p>
<p id=414 class="line"><span>&nbsp;414</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;condition&nbsp;filters&nbsp;</comment></p>
<p id=415 class="line"><span>&nbsp;415</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;a&nbsp;new&nbsp;Data&nbsp;object&nbsp;with&nbsp;rows&nbsp;that&nbsp;pass&nbsp;the&nbsp;filter</comment></p>
<p id=416 class="line"><span>&nbsp;416</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=417 class="line"><span>&nbsp;417</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;filter(condition:Condition):Data&nbsp;{</p>
<p id=418 class="line"><span>&nbsp;418</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;filter(this,&nbsp;condition);</p>
<p id=419 class="line"><span>&nbsp;419</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=420 class="line"><span>&nbsp;420</span></p>
<p id=421 class="line"><span>&nbsp;421</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=422 class="line"><span>&nbsp;422</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@description&nbsp;Sorts&nbsp;the&nbsp;rows&nbsp;of&nbsp;values&nbsp;based&nbsp;on&nbsp;the&nbsp;result&nbsp;of&nbsp;the&nbsp;`sortFn`,&nbsp;</comment></p>
<p id=423 class="line"><span>&nbsp;423</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;which&nbsp;behaves&nbsp;similarly&nbsp;to&nbsp;the&nbsp;Array.sort&nbsp;method.&nbsp;&nbsp;</comment></p>
<p id=424 class="line"><span>&nbsp;424</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Two&nbsp;modes&nbsp;are&nbsp;supported:</comment></p>
<p id=425 class="line"><span>&nbsp;425</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;#&nbsp;Array&nbsp;Mode</comment></p>
<p id=426 class="line"><span>&nbsp;426</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;If&nbsp;`col`&nbsp;is&nbsp;omitted,&nbsp;the&nbsp;column&nbsp;arrays&nbsp;are&nbsp;passed&nbsp;as&nbsp;samples&nbsp;into&nbsp;the&nbsp;`sortFn`.&nbsp;</comment></p>
<p id=427 class="line"><span>&nbsp;427</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;This&nbsp;allows&nbsp;for&nbsp;complex&nbsp;sorts,&nbsp;combining&nbsp;conditions&nbsp;across&nbsp;multiple&nbsp;columns.</comment></p>
<p id=428 class="line"><span>&nbsp;428</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=429 class="line"><span>&nbsp;429</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;data.sort((row1,&nbsp;row2)&nbsp;=&gt;&nbsp;row1[5]&nbsp;-&nbsp;row2[5]&nbsp;);</comment></p>
<p id=430 class="line"><span>&nbsp;430</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=431 class="line"><span>&nbsp;431</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;#&nbsp;Column&nbsp;mode</comment></p>
<p id=432 class="line"><span>&nbsp;432</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;If&nbsp;`col`&nbsp;is&nbsp;specified,&nbsp;either&nbsp;as&nbsp;index&nbsp;or&nbsp;by&nbsp;column&nbsp;name,&nbsp;the&nbsp;respective&nbsp;column&nbsp;value&nbsp;is&nbsp;passed</comment></p>
<p id=433 class="line"><span>&nbsp;433</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;into&nbsp;`sortFn`.&nbsp;This&nbsp;allows&nbsp;filtering&nbsp;for&nbsp;simple&nbsp;conditions.</comment></p>
<p id=434 class="line"><span>&nbsp;434</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;**The&nbsp;specified&nbsp;column&nbsp;will&nbsp;be&nbsp;automatically&nbsp;cast&nbsp;prior&nbsp;to&nbsp;sorting**&lt;br&gt;</comment></p>
<p id=435 class="line"><span>&nbsp;435</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=436 class="line"><span>&nbsp;436</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;data.sort(<quote>'ascending'</quote>,&nbsp;<quote>'Date'</quote>);</comment></p>
<p id=437 class="line"><span>&nbsp;437</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;data.sort(<quote>'decending'</quote>,&nbsp;<quote>'Date'</quote>);</comment></p>
<p id=438 class="line"><span>&nbsp;438</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;data.sort(function(val1,&nbsp;val2)&nbsp;{&nbsp;return&nbsp;val1&nbsp;-&nbsp;val2;&nbsp;},&nbsp;<quote>'Date'</quote>);</comment></p>
<p id=439 class="line"><span>&nbsp;439</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=440 class="line"><span>&nbsp;440</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;col&nbsp;optional;&nbsp;the&nbsp;data&nbsp;column&nbsp;to&nbsp;use&nbsp;for&nbsp;sorting.&nbsp;</comment></p>
<p id=441 class="line"><span>&nbsp;441</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;sortFn&nbsp;a&nbsp;function&nbsp;to&nbsp;implement&nbsp;the&nbsp;conditions,&nbsp;</comment></p>
<p id=442 class="line"><span>&nbsp;442</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;follows&nbsp;the&nbsp;same&nbsp;specifications&nbsp;as&nbsp;the&nbsp;function&nbsp;passed&nbsp;to&nbsp;Array.sort().&nbsp;</comment></p>
<p id=443 class="line"><span>&nbsp;443</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Some&nbsp;predefined&nbsp;sort&nbsp;function&nbsp;can&nbsp;be&nbsp;invoked&nbsp;by&nbsp;providing&nbsp;a&nbsp;</comment></p>
<p id=444 class="line"><span>&nbsp;444</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;respective&nbsp;string&nbsp;instead&nbsp;of&nbsp;a&nbsp;function.&nbsp;The&nbsp;following&nbsp;functions&nbsp;are&nbsp;defined:</comment></p>
<p id=445 class="line"><span>&nbsp;445</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```</comment></p>
<p id=446 class="line"><span>&nbsp;446</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ascending&nbsp;&nbsp;&nbsp;&nbsp;sort&nbsp;in&nbsp;ascending&nbsp;order.</comment></p>
<p id=447 class="line"><span>&nbsp;447</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;descending&nbsp;&nbsp;&nbsp;sort&nbsp;in&nbsp;decending&nbsp;order.</comment></p>
<p id=448 class="line"><span>&nbsp;448</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```</comment></p>
<p id=449 class="line"><span>&nbsp;449</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;Data&nbsp;object&nbsp;in&nbsp;order&nbsp;to&nbsp;allow&nbsp;for&nbsp;chaining.</comment></p>
<p id=450 class="line"><span>&nbsp;450</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=451 class="line"><span>&nbsp;451</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;sort(sortFn:string|sortFn,&nbsp;col?:ColumnReference):Data&nbsp;{</p>
<p id=452 class="line"><span>&nbsp;452</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;fn&nbsp;=&nbsp;&lt;sortFn&gt;sortFn;</p>
<p id=453 class="line"><span>&nbsp;453</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!col)&nbsp;{</p>
<p id=454 class="line"><span>&nbsp;454</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.data.sort(fn);</p>
<p id=455 class="line"><span>&nbsp;455</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{</p>
<p id=456 class="line"><span>&nbsp;456</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;col&nbsp;=&nbsp;this.colNumber(col);</p>
<p id=457 class="line"><span>&nbsp;457</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(sortFn&nbsp;===&nbsp;<quote>'descending'</quote>)&nbsp;{&nbsp;fn&nbsp;=&nbsp;(a:any,&nbsp;b:any)&nbsp;&nbsp;=&gt;&nbsp;(b&gt;a)?1:((b&lt;a)?-1:0);&nbsp;}</p>
<p id=458 class="line"><span>&nbsp;458</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(sortFn&nbsp;===&nbsp;<quote>'ascending'</quote>)&nbsp;&nbsp;{&nbsp;fn&nbsp;=&nbsp;(a:any,&nbsp;b:any)&nbsp;&nbsp;=&gt;&nbsp;(b&lt;a)?1:((b&gt;a)?-1:0);&nbsp;}</p>
<p id=459 class="line"><span>&nbsp;459</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.data.sort((r1:any[],&nbsp;r2:any[])&nbsp;=&gt;&nbsp;fn(r1[col],&nbsp;r2[col]));&nbsp;</p>
<p id=460 class="line"><span>&nbsp;460</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=461 class="line"><span>&nbsp;461</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;</p>
<p id=462 class="line"><span>&nbsp;462</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=463 class="line"><span>&nbsp;463</span></p>
<p id=464 class="line"><span>&nbsp;464</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**&nbsp;</comment></p>
<p id=465 class="line"><span>&nbsp;465</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;Maps&nbsp;one&nbsp;or&nbsp;more&nbsp;columns&nbsp;in&nbsp;each&nbsp;rows&nbsp;of&nbsp;values&nbsp;based&nbsp;</comment></p>
<p id=466 class="line"><span>&nbsp;466</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;on&nbsp;the&nbsp;result&nbsp;of&nbsp;the&nbsp;`mapFn`,&nbsp;which&nbsp;behaves&nbsp;similarly&nbsp;to&nbsp;the&nbsp;Array.map()&nbsp;method.</comment></p>
<p id=467 class="line"><span>&nbsp;467</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Two&nbsp;modes&nbsp;are&nbsp;supported:</comment></p>
<p id=468 class="line"><span>&nbsp;468</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;</comment></p>
<p id=469 class="line"><span>&nbsp;469</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;##&nbsp;Array&nbsp;Mode</comment></p>
<p id=470 class="line"><span>&nbsp;470</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;If&nbsp;`col`&nbsp;is&nbsp;omitted,&nbsp;the&nbsp;`mapFn`&nbsp;is&nbsp;passed&nbsp;the&nbsp;column&nbsp;arrays&nbsp;per&nbsp;row&nbsp;as&nbsp;parameter.&nbsp;</comment></p>
<p id=471 class="line"><span>&nbsp;471</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;This&nbsp;allows&nbsp;for&nbsp;complex&nbsp;mapping&nbsp;combining&nbsp;conditions&nbsp;across&nbsp;multiple&nbsp;columns.</comment></p>
<p id=472 class="line"><span>&nbsp;472</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=473 class="line"><span>&nbsp;473</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;data.map(function(values){&nbsp;</comment></p>
<p id=474 class="line"><span>&nbsp;474</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;values[1]&nbsp;=&nbsp;values[3]&nbsp;*&nbsp;values[5];&nbsp;</comment></p>
<p id=475 class="line"><span>&nbsp;475</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;values;&nbsp;</comment></p>
<p id=476 class="line"><span>&nbsp;476</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;});</comment></p>
<p id=477 class="line"><span>&nbsp;477</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=478 class="line"><span>&nbsp;478</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Be&nbsp;sure&nbsp;to&nbsp;return&nbsp;the&nbsp;`values`&nbsp;array&nbsp;as&nbsp;a&nbsp;result.</comment></p>
<p id=479 class="line"><span>&nbsp;479</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;</comment></p>
<p id=480 class="line"><span>&nbsp;480</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;##&nbsp;Column&nbsp;mode</comment></p>
<p id=481 class="line"><span>&nbsp;481</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;If&nbsp;`col`&nbsp;is&nbsp;specified,&nbsp;either&nbsp;as&nbsp;index&nbsp;or&nbsp;by&nbsp;column&nbsp;name,&nbsp;the&nbsp;respective&nbsp;column&nbsp;value&nbsp;is&nbsp;passed</comment></p>
<p id=482 class="line"><span>&nbsp;482</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;into&nbsp;`mapFn`,&nbsp;along&nbsp;with&nbsp;the&nbsp;row&nbsp;index&nbsp;and&nbsp;the&nbsp;entire&nbsp;row&nbsp;array.&nbsp;This&nbsp;allows&nbsp;for&nbsp;simple&nbsp;mapping.</comment></p>
<p id=483 class="line"><span>&nbsp;483</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=484 class="line"><span>&nbsp;484</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;data.map(<quote>'Price'</quote>,&nbsp;function(value,&nbsp;i,&nbsp;values)&nbsp;{&nbsp;</comment></p>
<p id=485 class="line"><span>&nbsp;485</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;value&nbsp;*&nbsp;2;&nbsp;</comment></p>
<p id=486 class="line"><span>&nbsp;486</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;});</comment></p>
<p id=487 class="line"><span>&nbsp;487</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;```</comment></p>
<p id=488 class="line"><span>&nbsp;488</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;col&nbsp;the&nbsp;data&nbsp;column,&nbsp;or&nbsp;columns,&nbsp;to&nbsp;apply&nbsp;the&nbsp;mapping&nbsp;to.&nbsp;</comment></p>
<p id=489 class="line"><span>&nbsp;489</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;mapFn&nbsp;a&nbsp;function&nbsp;to&nbsp;implement&nbsp;the&nbsp;mapping,</comment></p>
<p id=490 class="line"><span>&nbsp;490</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;called&nbsp;on&nbsp;each&nbsp;row&nbsp;of&nbsp;the&nbsp;data&nbsp;set&nbsp;in&nbsp;turn&nbsp;as&nbsp;`mapFn(val,&nbsp;i,&nbsp;c,&nbsp;rows)`,&nbsp;where</comment></p>
<p id=491 class="line"><span>&nbsp;491</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;-&nbsp;`val`:&nbsp;the&nbsp;column&nbsp;value&nbsp;in&nbsp;the&nbsp;current&nbsp;row</comment></p>
<p id=492 class="line"><span>&nbsp;492</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;-&nbsp;`c`:&nbsp;the&nbsp;column&nbsp;index&nbsp;in&nbsp;the&nbsp;current&nbsp;row</comment></p>
<p id=493 class="line"><span>&nbsp;493</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;-&nbsp;`i`:&nbsp;the&nbsp;row&nbsp;index&nbsp;</comment></p>
<p id=494 class="line"><span>&nbsp;494</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;-&nbsp;`rows`:&nbsp;the&nbsp;rows&nbsp;being&nbsp;iterated&nbsp;over</comment></p>
<p id=495 class="line"><span>&nbsp;495</span><comment>`&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;</comment></p>
<p id=496 class="line"><span>&nbsp;496</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;follows&nbsp;the&nbsp;same&nbsp;specifications&nbsp;as&nbsp;the&nbsp;function&nbsp;passed&nbsp;to&nbsp;Array.map().&lt;br&gt;</comment></p>
<p id=497 class="line"><span>&nbsp;497</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;For&nbsp;column&nbsp;mode,&nbsp;some&nbsp;predefined&nbsp;map&nbsp;functions&nbsp;can&nbsp;be&nbsp;invoked&nbsp;by&nbsp;providing&nbsp;a&nbsp;</comment></p>
<p id=498 class="line"><span>&nbsp;498</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;respective&nbsp;string&nbsp;instead&nbsp;of&nbsp;a&nbsp;function.&nbsp;The&nbsp;following&nbsp;functions&nbsp;are&nbsp;defined:</comment></p>
<p id=499 class="line"><span>&nbsp;499</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&lt;table&gt;</comment></p>
<p id=500 class="line"><span>&nbsp;500</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&lt;tr&gt;&lt;td&gt;<quote>'noop'</quote>&lt;/td&gt;&lt;td&gt;replace&nbsp;value&nbsp;with&nbsp;itself,&nbsp;performing&nbsp;no&nbsp;operation.&lt;/td&gt;&lt;/tr&gt;</comment></p>
<p id=501 class="line"><span>&nbsp;501</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&lt;tr&gt;&lt;td&gt;<quote>'cumulate'</quote>&lt;/td&gt;&lt;td&gt;replace&nbsp;value&nbsp;with&nbsp;the&nbsp;cumulative&nbsp;sum&nbsp;of&nbsp;values&nbsp;up&nbsp;to&nbsp;the&nbsp;current&nbsp;element.&lt;/td&gt;&lt;/tr&gt;</comment></p>
<p id=502 class="line"><span>&nbsp;502</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&lt;/table&gt;</comment></p>
<p id=503 class="line"><span>&nbsp;503</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*</comment></p>
<p id=504 class="line"><span>&nbsp;504</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;a&nbsp;new&nbsp;Data&nbsp;object&nbsp;containing&nbsp;the&nbsp;mapping.</comment></p>
<p id=505 class="line"><span>&nbsp;505</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=506 class="line"><span>&nbsp;506</span>&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;map(mapFn:string|mapFn|mapRowFn,&nbsp;col?:ColumnReference):Data&nbsp;{</p>
<p id=507 class="line"><span>&nbsp;507</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;noop&nbsp;=&nbsp;(val:any)&nbsp;=&gt;&nbsp;val;</p>
<p id=508 class="line"><span>&nbsp;508</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;cumulate&nbsp;=&nbsp;()&nbsp;=&gt;&nbsp;{&nbsp;</p>
<p id=509 class="line"><span>&nbsp;509</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;sum=0;&nbsp;</p>
<p id=510 class="line"><span>&nbsp;510</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;(val:number,&nbsp;i:number)&nbsp;=&gt;&nbsp;{&nbsp;sum&nbsp;+=&nbsp;+val;&nbsp;return&nbsp;sum;&nbsp;};</p>
<p id=511 class="line"><span>&nbsp;511</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};</p>
<p id=512 class="line"><span>&nbsp;512</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;getFn():mapFn|mapRowFn&nbsp;{</p>
<p id=513 class="line"><span>&nbsp;513</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;fn;&nbsp;<comment>//&nbsp;define&nbsp;fn&nbsp;inside&nbsp;each&nbsp;col&nbsp;loop&nbsp;to&nbsp;ensure&nbsp;initialization</comment></p>
<p id=514 class="line"><span>&nbsp;514</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;switch&nbsp;(mapFn)&nbsp;{</p>
<p id=515 class="line"><span>&nbsp;515</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>'cumulate'</quote>:&nbsp;fn&nbsp;=&nbsp;cumulate();&nbsp;break;</p>
<p id=516 class="line"><span>&nbsp;516</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;<quote>'noop'</quote>:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fn&nbsp;=&nbsp;noop;&nbsp;break;</p>
<p id=517 class="line"><span>&nbsp;517</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;default:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fn&nbsp;=&nbsp;&lt;mapFn|mapRowFn&gt;mapFn;</p>
<p id=518 class="line"><span>&nbsp;518</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=519 class="line"><span>&nbsp;519</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;fn;</p>
<p id=520 class="line"><span>&nbsp;520</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=521 class="line"><span>&nbsp;521</span></p>
<p id=522 class="line"><span>&nbsp;522</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;fn&nbsp;=&nbsp;getFn();&nbsp;<comment>//&nbsp;define&nbsp;fn&nbsp;inside&nbsp;each&nbsp;col&nbsp;loop&nbsp;to&nbsp;ensure&nbsp;initialization</comment></p>
<p id=523 class="line"><span>&nbsp;523</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;c&nbsp;=&nbsp;col?&nbsp;this.colNumber(col)&nbsp;:&nbsp;undefined;</p>
<p id=524 class="line"><span>&nbsp;524</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;result&nbsp;=&nbsp;new&nbsp;Data({</p>
<p id=525 class="line"><span>&nbsp;525</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;colNames:this.colNames(),&nbsp;</p>
<p id=526 class="line"><span>&nbsp;526</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rows:this.data.map((row:any[],&nbsp;rowIndex:number,&nbsp;rows:any[][])&nbsp;=&gt;&nbsp;{&nbsp;</p>
<p id=527 class="line"><span>&nbsp;527</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(c)&nbsp;{</p>
<p id=528 class="line"><span>&nbsp;528</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;row[c]&nbsp;=&nbsp;(&lt;mapFn&gt;fn)(row[c],&nbsp;c,&nbsp;rowIndex,&nbsp;rows);&nbsp;</p>
<p id=529 class="line"><span>&nbsp;529</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{</p>
<p id=530 class="line"><span>&nbsp;530</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rows[rowIndex]&nbsp;=&nbsp;(&lt;mapRowFn&gt;fn)(row,&nbsp;rowIndex,&nbsp;rows);</p>
<p id=531 class="line"><span>&nbsp;531</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=532 class="line"><span>&nbsp;532</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;row;</p>
<p id=533 class="line"><span>&nbsp;533</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}),&nbsp;</p>
<p id=534 class="line"><span>&nbsp;534</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name:this.getName()</p>
<p id=535 class="line"><span>&nbsp;535</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});</p>
<p id=536 class="line"><span>&nbsp;536</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;result;</p>
<p id=537 class="line"><span>&nbsp;537</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=538 class="line"><span>&nbsp;538</span></p>
<p id=539 class="line"><span>&nbsp;539</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//----------------------------</comment></p>
<p id=540 class="line"><span>&nbsp;540</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;private&nbsp;part</comment></p>
<p id=541 class="line"><span>&nbsp;541</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;<comment>//----------------------------</comment></p>
<p id=542 class="line"><span>&nbsp;542</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;data:&nbsp;DataRow[]&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;[];</p>
<p id=543 class="line"><span>&nbsp;543</span>&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;meta:&nbsp;MetaStruct[]&nbsp;=&nbsp;[];</p>
<p id=544 class="line"><span>&nbsp;544</span>&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;name:&nbsp;string;</p>
<p id=545 class="line"><span>&nbsp;545</span></p>
<p id=546 class="line"><span>&nbsp;546</span>&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;getMeta(col:ColumnReference):MetaStruct&nbsp;{&nbsp;</p>
<p id=547 class="line"><span>&nbsp;547</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<comment>//&nbsp;if&nbsp;(!this.meta)&nbsp;{&nbsp;this.meta&nbsp;=&nbsp;[];&nbsp;}</comment></p>
<p id=548 class="line"><span>&nbsp;548</span><comment></comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(!this.meta[col])&nbsp;{&nbsp;return&nbsp;undefined;&nbsp;}</p>
<p id=549 class="line"><span>&nbsp;549</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;	this.meta[col].accessed&nbsp;=&nbsp;true;</p>
<p id=550 class="line"><span>&nbsp;550</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this.meta[col];&nbsp;</p>
<p id=551 class="line"><span>&nbsp;551</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=552 class="line"><span>&nbsp;552</span></p>
<p id=553 class="line"><span>&nbsp;553</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=554 class="line"><span>&nbsp;554</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;sets&nbsp;`rows`&nbsp;as&nbsp;the&nbsp;data&nbsp;set.&nbsp;A&nbsp;copy&nbsp;of&nbsp;the&nbsp;rows&nbsp;array&nbsp;will&nbsp;be&nbsp;set.</comment></p>
<p id=555 class="line"><span>&nbsp;555</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;data&nbsp;the&nbsp;data&nbsp;to&nbsp;add</comment></p>
<p id=556 class="line"><span>&nbsp;556</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;names&nbsp;an&nbsp;array&nbsp;of&nbsp;names&nbsp;that&nbsp;match&nbsp;the&nbsp;columns</comment></p>
<p id=557 class="line"><span>&nbsp;557</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;autoType&nbsp;unless&nbsp;set&nbsp;to&nbsp;false,&nbsp;the&nbsp;method&nbsp;will&nbsp;attempt&nbsp;to&nbsp;determine&nbsp;the&nbsp;</comment></p>
<p id=558 class="line"><span>&nbsp;558</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;type&nbsp;of&nbsp;data&nbsp;and&nbsp;automatically&nbsp;cast&nbsp;data&nbsp;points&nbsp;to&nbsp;their&nbsp;correct&nbsp;value</comment></p>
<p id=559 class="line"><span>&nbsp;559</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=560 class="line"><span>&nbsp;560</span>&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;setData(rows:DataRow[],&nbsp;names:string[],&nbsp;autoType=true):void&nbsp;{</p>
<p id=561 class="line"><span>&nbsp;561</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.meta&nbsp;=&nbsp;[];</p>
<p id=562 class="line"><span>&nbsp;562</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.data&nbsp;=&nbsp;rows.slice();</p>
<p id=563 class="line"><span>&nbsp;563</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(names&nbsp;&&&nbsp;names.forEach)&nbsp;{</p>
<p id=564 class="line"><span>&nbsp;564</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;names.forEach((col:string)&nbsp;=&gt;&nbsp;this.colAdd(col));</p>
<p id=565 class="line"><span>&nbsp;565</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(autoType)&nbsp;{&nbsp;</p>
<p id=566 class="line"><span>&nbsp;566</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;names.forEach((col:string)&nbsp;=&gt;&nbsp;this.findTypes(col));&nbsp;</p>
<p id=567 class="line"><span>&nbsp;567</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.castData();</p>
<p id=568 class="line"><span>&nbsp;568</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=569 class="line"><span>&nbsp;569</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{</p>
<p id=570 class="line"><span>&nbsp;570</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.warn(`invalid&nbsp;names&nbsp;setData:\n${log.inspect(names,&nbsp;{depth:5})}`);</p>
<p id=571 class="line"><span>&nbsp;571</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=572 class="line"><span>&nbsp;572</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=573 class="line"><span>&nbsp;573</span></p>
<p id=574 class="line"><span>&nbsp;574</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=575 class="line"><span>&nbsp;575</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;Determines&nbsp;the&nbsp;type&nbsp;of&nbsp;data&nbsp;in&nbsp;`col`.&nbsp;An&nbsp;array&nbsp;of&nbsp;counts&nbsp;is&nbsp;created&nbsp;for&nbsp;all</comment></p>
<p id=576 class="line"><span>&nbsp;576</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;encountered&nbsp;types,&nbsp;sorted&nbsp;by&nbsp;descending&nbsp;frequency.&nbsp;THe&nbsp;most&nbsp;likely&nbsp;type&nbsp;in&nbsp;position&nbsp;0</comment></p>
<p id=577 class="line"><span>&nbsp;577</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;of&nbsp;the&nbsp;array&nbsp;is&nbsp;returned.</comment></p>
<p id=578 class="line"><span>&nbsp;578</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;col&nbsp;the&nbsp;index&nbsp;of&nbsp;the&nbsp;column&nbsp;to&nbsp;be&nbsp;typed.&nbsp;</comment></p>
<p id=579 class="line"><span>&nbsp;579</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;the&nbsp;most&nbsp;likely&nbsp;type&nbsp;of&nbsp;data&nbsp;in&nbsp;`col`.</comment></p>
<p id=580 class="line"><span>&nbsp;580</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=581 class="line"><span>&nbsp;581</span>&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;findTypes(col:ColumnReference):string&nbsp;{</p>
<p id=582 class="line"><span>&nbsp;582</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;m&nbsp;=&nbsp;this.getMeta(col);</p>
<p id=583 class="line"><span>&nbsp;583</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;types:TypeStruct[]&nbsp;=&nbsp;[];</p>
<p id=584 class="line"><span>&nbsp;584</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Object.keys(Data.type).forEach((t:string)&nbsp;=&gt;&nbsp;{</p>
<p id=585 class="line"><span>&nbsp;585</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;ts&nbsp;=&nbsp;{&nbsp;type:&nbsp;Data.type[t],&nbsp;count:&nbsp;0&nbsp;};&nbsp;</p>
<p id=586 class="line"><span>&nbsp;586</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;types.push(ts);</p>
<p id=587 class="line"><span>&nbsp;587</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;types[Data.type[t]]&nbsp;=&nbsp;ts;</p>
<p id=588 class="line"><span>&nbsp;588</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});</p>
<p id=589 class="line"><span>&nbsp;589</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;(let&nbsp;v&nbsp;of&nbsp;this.allRows(col))&nbsp;{</p>
<p id=590 class="line"><span>&nbsp;590</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;t&nbsp;=&nbsp;findType(v);</p>
<p id=591 class="line"><span>&nbsp;591</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(t&nbsp;!==&nbsp;null)&nbsp;{&nbsp;types[t].count++;&nbsp;}</p>
<p id=592 class="line"><span>&nbsp;592</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=593 class="line"><span>&nbsp;593</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;types.sort(function(a:TypeStruct,&nbsp;b:TypeStruct)&nbsp;{&nbsp;</p>
<p id=594 class="line"><span>&nbsp;594</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(a.type===<quote>'currency'</quote>&&a.count&gt;0)&nbsp;{&nbsp;return&nbsp;-1;&nbsp;}</p>
<p id=595 class="line"><span>&nbsp;595</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(b.type===<quote>'currency'</quote>&&b.count&gt;0)&nbsp;{&nbsp;return&nbsp;1;&nbsp;}</p>
<p id=596 class="line"><span>&nbsp;596</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;b.count&nbsp;-&nbsp;a.count;</p>
<p id=597 class="line"><span>&nbsp;597</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});</p>
<p id=598 class="line"><span>&nbsp;598</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m.types&nbsp;=&nbsp;types;</p>
<p id=599 class="line"><span>&nbsp;599</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;types[0].type;</p>
<p id=600 class="line"><span>&nbsp;600</span>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=601 class="line"><span>&nbsp;601</span></p>
<p id=602 class="line"><span>&nbsp;602</span>&nbsp;&nbsp;&nbsp;&nbsp;<comment>/**</comment></p>
<p id=603 class="line"><span>&nbsp;603</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;A&nbsp;generator&nbsp;that&nbsp;provides&nbsp;the&nbsp;specified&nbsp;column&nbsp;value&nbsp;for&nbsp;each&nbsp;row&nbsp;in&nbsp;`Data`&nbsp;in&nbsp;sequence.&nbsp;</comment></p>
<p id=604 class="line"><span>&nbsp;604</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;column&nbsp;</comment></p>
<p id=605 class="line"><span>&nbsp;605</span><comment>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</comment></p>
<p id=606 class="line"><span>&nbsp;606</span>&nbsp;&nbsp;&nbsp;&nbsp;private&nbsp;*&nbsp;allRows(column:ColumnReference):Iterable&lt;DataVal&gt;&nbsp;{</p>
<p id=607 class="line"><span>&nbsp;607</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;const&nbsp;c&nbsp;=&nbsp;this.colNumber(column);</p>
<p id=608 class="line"><span>&nbsp;608</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;(let&nbsp;r=0;&nbsp;r&lt;this.data.length;&nbsp;r++)&nbsp;{</p>
<p id=609 class="line"><span>&nbsp;609</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;yield&nbsp;this.data[r][c];</p>
<p id=610 class="line"><span>&nbsp;610</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<p id=611 class="line"><span>&nbsp;611</span>&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;</p>
<p id=612 class="line"><span>&nbsp;612</span>}</p></code></div>
                </body>
Provide feedback

Saved searches

Use saved searches to filter your results more quickly

FilesExpand file tree

Data.html

Latest commit

History

Data.html

File metadata and controls
