UDF, UDAF using pandasUDF.ipynb

{"cells":[{"cell_type":"code","source":["from pyspark.sql.functions import udf\nfrom pyspark.sql.types import IntegerType"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":1},{"cell_type":"code","source":["def func(x):\n  return int(x)+5\n\nstrToInt = udf( func, IntegerType())"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":2},{"cell_type":"code","source":["df = spark.createDataFrame([('1',1),('2',2)],['a','b'])"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":3},{"cell_type":"code","source":["display(df.withColumn('newCol', strToInt(df.a)))"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .table-result-container {\n    max-height: 300px;\n    overflow: auto;\n  }\n  table, th, td {\n    border: 1px solid black;\n    border-collapse: collapse;\n  }\n  th, td {\n    padding: 5px;\n  }\n  th {\n    text-align: left;\n  }\n</style><div class='table-result-container'><table class='table-result'><thead style='background-color: white'><tr><th>a</th><th>b</th><th>newCol</th></tr></thead><tbody><tr><td>1</td><td>1</td><td>6</td></tr><tr><td>2</td><td>2</td><td>7</td></tr></tbody></table></div>"]}}],"execution_count":4},{"cell_type":"code","source":["from pyspark.sql.functions import pandas_udf, PandasUDFType"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":5},{"cell_type":"code","source":["from pyspark.sql.functions import pandas_udf, PandasUDFType\n\ndf = spark.createDataFrame([(1, 1.0), (1, 2.0), (2, 3.0), (2, 5.0), (2, 10.0)],(\"id\", \"v\"))\n  \n"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":6},{"cell_type":"code","source":["display(df)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .table-result-container {\n    max-height: 300px;\n    overflow: auto;\n  }\n  table, th, td {\n    border: 1px solid black;\n    border-collapse: collapse;\n  }\n  th, td {\n    padding: 5px;\n  }\n  th {\n    text-align: left;\n  }\n</style><div class='table-result-container'><table class='table-result'><thead style='background-color: white'><tr><th>id</th><th>v</th></tr></thead><tbody><tr><td>1</td><td>1.0</td></tr><tr><td>1</td><td>2.0</td></tr><tr><td>2</td><td>3.0</td></tr><tr><td>2</td><td>5.0</td></tr><tr><td>2</td><td>10.0</td></tr></tbody></table></div>"]}}],"execution_count":7},{"cell_type":"code","source":["@pandas_udf(\"id long, v double\", PandasUDFType.GROUPED_MAP)\ndef normalize(pdf):\n  v = pdf.v\n  return pdf.assign(v=(v - v.mean()) / v.std())\n\ndf.groupBy(\"id\").apply(normalize).show()"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">+---+-------------------+\n id|                  v|\n+---+-------------------+\n  1|-0.7071067811865475|\n  1| 0.7071067811865475|\n  2|-0.8320502943378437|\n  2|-0.2773500981126146|\n  2| 1.1094003924504583|\n+---+-------------------+\n\n</div>"]}}],"execution_count":8},{"cell_type":"code","source":["df = spark.createDataFrame([(1, 1.0), (1, 2.0), (2, 3.0), (2, 5.0), (2, 10.0)],(\"id\", \"v\"))\n\n@pandas_udf('double', PandasUDFType.SCALAR)\ndef norm(v):\n  return v + 10\n\ndf.withColumn('a',norm(df.v))"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"><span class=\"ansired\">Out[</span><span class=\"ansired\">2</span><span class=\"ansired\">]: </span>DataFrame[id: bigint, v: double, a: double]\n</div>"]}}],"execution_count":9},{"cell_type":"code","source":["df = spark.range(1000)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":10},{"cell_type":"code","source":["from pyspark.sql.functions import udf"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":11},{"cell_type":"code","source":["sqr = udf(lambda x:x*x*x, IntegerType())"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":12},{"cell_type":"code","source":["df = df.withColumn('sqr',sqr(df.id))"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":13},{"cell_type":"code","source":["from pyspark.sql.functions import pandas_udf, PandasUDFType"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":14},{"cell_type":"code","source":["import pandas as pd\n@pandas_udf('int', PandasUDFType.SCALAR)\ndef func(pdfc):\n  return pdfc*pdfc\n  "],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":15},{"cell_type":"code","source":["df = df.withColumn('sqr',func(df.id))"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":16},{"cell_type":"code","source":["df = df.withColumn('key',df.sqr%2)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":17},{"cell_type":"code","source":["df.head(5)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"><span class=\"ansired\">Out[</span><span class=\"ansired\">46</span><span class=\"ansired\">]: </span>\n[Row(id=0, sqr=0, key=0),\n Row(id=1, sqr=1, key=1),\n Row(id=2, sqr=4, key=0),\n Row(id=3, sqr=9, key=1),\n Row(id=4, sqr=16, key=0)]\n</div>"]}}],"execution_count":18},{"cell_type":"code","source":["display(df)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .table-result-container {\n    max-height: 300px;\n    overflow: auto;\n  }\n  table, th, td {\n    border: 1px solid black;\n    border-collapse: collapse;\n  }\n  th, td {\n    padding: 5px;\n  }\n  th {\n    text-align: left;\n  }\n</style><div class='table-result-container'><table class='table-result'><thead style='background-color: white'><tr><th>id</th><th>sqr</th><th>key</th></tr></thead><tbody><tr><td>0</td><td>0</td><td>0</td></tr><tr><td>1</td><td>1</td><td>1</td></tr><tr><td>2</td><td>4</td><td>0</td></tr><tr><td>3</td><td>9</td><td>1</td></tr><tr><td>4</td><td>16</td><td>0</td></tr><tr><td>5</td><td>25</td><td>1</td></tr><tr><td>6</td><td>36</td><td>0</td></tr><tr><td>7</td><td>49</td><td>1</td></tr><tr><td>8</td><td>64</td><td>0</td></tr><tr><td>9</td><td>81</td><td>1</td></tr><tr><td>10</td><td>100</td><td>0</td></tr><tr><td>11</td><td>121</td><td>1</td></tr><tr><td>12</td><td>144</td><td>0</td></tr><tr><td>13</td><td>169</td><td>1</td></tr><tr><td>14</td><td>196</td><td>0</td></tr><tr><td>15</td><td>225</td><td>1</td></tr><tr><td>16</td><td>256</td><td>0</td></tr><tr><td>17</td><td>289</td><td>1</td></tr><tr><td>18</td><td>324</td><td>0</td></tr><tr><td>19</td><td>361</td><td>1</td></tr><tr><td>20</td><td>400</td><td>0</td></tr><tr><td>21</td><td>441</td><td>1</td></tr><tr><td>22</td><td>484</td><td>0</td></tr><tr><td>23</td><td>529</td><td>1</td></tr><tr><td>24</td><td>576</td><td>0</td></tr><tr><td>25</td><td>625</td><td>1</td></tr><tr><td>26</td><td>676</td><td>0</td></tr><tr><td>27</td><td>729</td><td>1</td></tr><tr><td>28</td><td>784</td><td>0</td></tr><tr><td>29</td><td>841</td><td>1</td></tr><tr><td>30</td><td>900</td><td>0</td></tr><tr><td>31</td><td>961</td><td>1</td></tr><tr><td>32</td><td>1024</td><td>0</td></tr><tr><td>33</td><td>1089</td><td>1</td></tr><tr><td>34</td><td>1156</td><td>0</td></tr><tr><td>35</td><td>1225</td><td>1</td></tr><tr><td>36</td><td>1296</td><td>0</td></tr><tr><td>37</td><td>1369</td><td>1</td></tr><tr><td>38</td><td>1444</td><td>0</td></tr><tr><td>39</td><td>1521</td><td>1</td></tr><tr><td>40</td><td>1600</td><td>0</td></tr><tr><td>41</td><td>1681</td><td>1</td></tr><tr><td>42</td><td>1764</td><td>0</td></tr><tr><td>43</td><td>1849</td><td>1</td></tr><tr><td>44</td><td>1936</td><td>0</td></tr><tr><td>45</td><td>2025</td><td>1</td></tr><tr><td>46</td><td>2116</td><td>0</td></tr><tr><td>47</td><td>2209</td><td>1</td></tr><tr><td>48</td><td>2304</td><td>0</td></tr><tr><td>49</td><td>2401</td><td>1</td></tr><tr><td>50</td><td>2500</td><td>0</td></tr><tr><td>51</td><td>2601</td><td>1</td></tr><tr><td>52</td><td>2704</td><td>0</td></tr><tr><td>53</td><td>2809</td><td>1</td></tr><tr><td>54</td><td>2916</td><td>0</td></tr><tr><td>55</td><td>3025</td><td>1</td></tr><tr><td>56</td><td>3136</td><td>0</td></tr><tr><td>57</td><td>3249</td><td>1</td></tr><tr><td>58</td><td>3364</td><td>0</td></tr><tr><td>59</td><td>3481</td><td>1</td></tr><tr><td>60</td><td>3600</td><td>0</td></tr><tr><td>61</td><td>3721</td><td>1</td></tr><tr><td>62</td><td>3844</td><td>0</td></tr><tr><td>63</td><td>3969</td><td>1</td></tr><tr><td>64</td><td>4096</td><td>0</td></tr><tr><td>65</td><td>4225</td><td>1</td></tr><tr><td>66</td><td>4356</td><td>0</td></tr><tr><td>67</td><td>4489</td><td>1</td></tr><tr><td>68</td><td>4624</td><td>0</td></tr><tr><td>69</td><td>4761</td><td>1</td></tr><tr><td>70</td><td>4900</td><td>0</td></tr><tr><td>71</td><td>5041</td><td>1</td></tr><tr><td>72</td><td>5184</td><td>0</td></tr><tr><td>73</td><td>5329</td><td>1</td></tr><tr><td>74</td><td>5476</td><td>0</td></tr><tr><td>75</td><td>5625</td><td>1</td></tr><tr><td>76</td><td>5776</td><td>0</td></tr><tr><td>77</td><td>5929</td><td>1</td></tr><tr><td>78</td><td>6084</td><td>0</td></tr><tr><td>79</td><td>6241</td><td>1</td></tr><tr><td>80</td><td>6400</td><td>0</td></tr><tr><td>81</td><td>6561</td><td>1</td></tr><tr><td>82</td><td>6724</td><td>0</td></tr><tr><td>83</td><td>6889</td><td>1</td></tr><tr><td>84</td><td>7056</td><td>0</td></tr><tr><td>85</td><td>7225</td><td>1</td></tr><tr><td>86</td><td>7396</td><td>0</td></tr><tr><td>87</td><td>7569</td><td>1</td></tr><tr><td>88</td><td>7744</td><td>0</td></tr><tr><td>89</td><td>7921</td><td>1</td></tr><tr><td>90</td><td>8100</td><td>0</td></tr><tr><td>91</td><td>8281</td><td>1</td></tr><tr><td>92</td><td>8464</td><td>0</td></tr><tr><td>93</td><td>8649</td><td>1</td></tr><tr><td>94</td><td>8836</td><td>0</td></tr><tr><td>95</td><td>9025</td><td>1</td></tr><tr><td>96</td><td>9216</td><td>0</td></tr><tr><td>97</td><td>9409</td><td>1</td></tr><tr><td>98</td><td>9604</td><td>0</td></tr><tr><td>99</td><td>9801</td><td>1</td></tr><tr><td>100</td><td>10000</td><td>0</td></tr><tr><td>101</td><td>10201</td><td>1</td></tr><tr><td>102</td><td>10404</td><td>0</td></tr><tr><td>103</td><td>10609</td><td>1</td></tr><tr><td>104</td><td>10816</td><td>0</td></tr><tr><td>105</td><td>11025</td><td>1</td></tr><tr><td>106</td><td>11236</td><td>0</td></tr><tr><td>107</td><td>11449</td><td>1</td></tr><tr><td>108</td><td>11664</td><td>0</td></tr><tr><td>109</td><td>11881</td><td>1</td></tr><tr><td>110</td><td>12100</td><td>0</td></tr><tr><td>111</td><td>12321</td><td>1</td></tr><tr><td>112</td><td>12544</td><td>0</td></tr><tr><td>113</td><td>12769</td><td>1</td></tr><tr><td>114</td><td>12996</td><td>0</td></tr><tr><td>115</td><td>13225</td><td>1</td></tr><tr><td>116</td><td>13456</td><td>0</td></tr><tr><td>117</td><td>13689</td><td>1</td></tr><tr><td>118</td><td>13924</td><td>0</td></tr><tr><td>119</td><td>14161</td><td>1</td></tr><tr><td>120</td><td>14400</td><td>0</td></tr><tr><td>121</td><td>14641</td><td>1</td></tr><tr><td>122</td><td>14884</td><td>0</td></tr><tr><td>123</td><td>15129</td><td>1</td></tr><tr><td>124</td><td>15376</td><td>0</td></tr><tr><td>125</td><td>15625</td><td>1</td></tr><tr><td>126</td><td>15876</td><td>0</td></tr><tr><td>127</td><td>16129</td><td>1</td></tr><tr><td>128</td><td>16384</td><td>0</td></tr><tr><td>129</td><td>16641</td><td>1</td></tr><tr><td>130</td><td>16900</td><td>0</td></tr><tr><td>131</td><td>17161</td><td>1</td></tr><tr><td>132</td><td>17424</td><td>0</td></tr><tr><td>133</td><td>17689</td><td>1</td></tr><tr><td>134</td><td>17956</td><td>0</td></tr><tr><td>135</td><td>18225</td><td>1</td></tr><tr><td>136</td><td>18496</td><td>0</td></tr><tr><td>137</td><td>18769</td><td>1</td></tr><tr><td>138</td><td>19044</td><td>0</td></tr><tr><td>139</td><td>19321</td><td>1</td></tr><tr><td>140</td><td>19600</td><td>0</td></tr><tr><td>141</td><td>19881</td><td>1</td></tr><tr><td>142</td><td>20164</td><td>0</td></tr><tr><td>143</td><td>20449</td><td>1</td></tr><tr><td>144</td><td>20736</td><td>0</td></tr><tr><td>145</td><td>21025</td><td>1</td></tr><tr><td>146</td><td>21316</td><td>0</td></tr><tr><td>147</td><td>21609</td><td>1</td></tr><tr><td>148</td><td>21904</td><td>0</td></tr><tr><td>149</td><td>22201</td><td>1</td></tr><tr><td>150</td><td>22500</td><td>0</td></tr><tr><td>151</td><td>22801</td><td>1</td></tr><tr><td>152</td><td>23104</td><td>0</td></tr><tr><td>153</td><td>23409</td><td>1</td></tr><tr><td>154</td><td>23716</td><td>0</td></tr><tr><td>155</td><td>24025</td><td>1</td></tr><tr><td>156</td><td>24336</td><td>0</td></tr><tr><td>157</td><td>24649</td><td>1</td></tr><tr><td>158</td><td>24964</td><td>0</td></tr><tr><td>159</td><td>25281</td><td>1</td></tr><tr><td>160</td><td>25600</td><td>0</td></tr><tr><td>161</td><td>25921</td><td>1</td></tr><tr><td>162</td><td>26244</td><td>0</td></tr><tr><td>163</td><td>26569</td><td>1</td></tr><tr><td>164</td><td>26896</td><td>0</td></tr><tr><td>165</td><td>27225</td><td>1</td></tr><tr><td>166</td><td>27556</td><td>0</td></tr><tr><td>167</td><td>27889</td><td>1</td></tr><tr><td>168</td><td>28224</td><td>0</td></tr><tr><td>169</td><td>28561</td><td>1</td></tr><tr><td>170</td><td>28900</td><td>0</td></tr><tr><td>171</td><td>29241</td><td>1</td></tr><tr><td>172</td><td>29584</td><td>0</td></tr><tr><td>173</td><td>29929</td><td>1</td></tr><tr><td>174</td><td>30276</td><td>0</td></tr><tr><td>175</td><td>30625</td><td>1</td></tr><tr><td>176</td><td>30976</td><td>0</td></tr><tr><td>177</td><td>31329</td><td>1</td></tr><tr><td>178</td><td>31684</td><td>0</td></tr><tr><td>179</td><td>32041</td><td>1</td></tr><tr><td>180</td><td>32400</td><td>0</td></tr><tr><td>181</td><td>32761</td><td>1</td></tr><tr><td>182</td><td>33124</td><td>0</td></tr><tr><td>183</td><td>33489</td><td>1</td></tr><tr><td>184</td><td>33856</td><td>0</td></tr><tr><td>185</td><td>34225</td><td>1</td></tr><tr><td>186</td><td>34596</td><td>0</td></tr><tr><td>187</td><td>34969</td><td>1</td></tr><tr><td>188</td><td>35344</td><td>0</td></tr><tr><td>189</td><td>35721</td><td>1</td></tr><tr><td>190</td><td>36100</td><td>0</td></tr><tr><td>191</td><td>36481</td><td>1</td></tr><tr><td>192</td><td>36864</td><td>0</td></tr><tr><td>193</td><td>37249</td><td>1</td></tr><tr><td>194</td><td>37636</td><td>0</td></tr><tr><td>195</td><td>38025</td><td>1</td></tr><tr><td>196</td><td>38416</td><td>0</td></tr><tr><td>197</td><td>38809</td><td>1</td></tr><tr><td>198</td><td>39204</td><td>0</td></tr><tr><td>199</td><td>39601</td><td>1</td></tr><tr><td>200</td><td>40000</td><td>0</td></tr><tr><td>201</td><td>40401</td><td>1</td></tr><tr><td>202</td><td>40804</td><td>0</td></tr><tr><td>203</td><td>41209</td><td>1</td></tr><tr><td>204</td><td>41616</td><td>0</td></tr><tr><td>205</td><td>42025</td><td>1</td></tr><tr><td>206</td><td>42436</td><td>0</td></tr><tr><td>207</td><td>42849</td><td>1</td></tr><tr><td>208</td><td>43264</td><td>0</td></tr><tr><td>209</td><td>43681</td><td>1</td></tr><tr><td>210</td><td>44100</td><td>0</td></tr><tr><td>211</td><td>44521</td><td>1</td></tr><tr><td>212</td><td>44944</td><td>0</td></tr><tr><td>213</td><td>45369</td><td>1</td></tr><tr><td>214</td><td>45796</td><td>0</td></tr><tr><td>215</td><td>46225</td><td>1</td></tr><tr><td>216</td><td>46656</td><td>0</td></tr><tr><td>217</td><td>47089</td><td>1</td></tr><tr><td>218</td><td>47524</td><td>0</td></tr><tr><td>219</td><td>47961</td><td>1</td></tr><tr><td>220</td><td>48400</td><td>0</td></tr><tr><td>221</td><td>48841</td><td>1</td></tr><tr><td>222</td><td>49284</td><td>0</td></tr><tr><td>223</td><td>49729</td><td>1</td></tr><tr><td>224</td><td>50176</td><td>0</td></tr><tr><td>225</td><td>50625</td><td>1</td></tr><tr><td>226</td><td>51076</td><td>0</td></tr><tr><td>227</td><td>51529</td><td>1</td></tr><tr><td>228</td><td>51984</td><td>0</td></tr><tr><td>229</td><td>52441</td><td>1</td></tr><tr><td>230</td><td>52900</td><td>0</td></tr><tr><td>231</td><td>53361</td><td>1</td></tr><tr><td>232</td><td>53824</td><td>0</td></tr><tr><td>233</td><td>54289</td><td>1</td></tr><tr><td>234</td><td>54756</td><td>0</td></tr><tr><td>235</td><td>55225</td><td>1</td></tr><tr><td>236</td><td>55696</td><td>0</td></tr><tr><td>237</td><td>56169</td><td>1</td></tr><tr><td>238</td><td>56644</td><td>0</td></tr><tr><td>239</td><td>57121</td><td>1</td></tr><tr><td>240</td><td>57600</td><td>0</td></tr><tr><td>241</td><td>58081</td><td>1</td></tr><tr><td>242</td><td>58564</td><td>0</td></tr><tr><td>243</td><td>59049</td><td>1</td></tr><tr><td>244</td><td>59536</td><td>0</td></tr><tr><td>245</td><td>60025</td><td>1</td></tr><tr><td>246</td><td>60516</td><td>0</td></tr><tr><td>247</td><td>61009</td><td>1</td></tr><tr><td>248</td><td>61504</td><td>0</td></tr><tr><td>249</td><td>62001</td><td>1</td></tr><tr><td>250</td><td>62500</td><td>0</td></tr><tr><td>251</td><td>63001</td><td>1</td></tr><tr><td>252</td><td>63504</td><td>0</td></tr><tr><td>253</td><td>64009</td><td>1</td></tr><tr><td>254</td><td>64516</td><td>0</td></tr><tr><td>255</td><td>65025</td><td>1</td></tr><tr><td>256</td><td>65536</td><td>0</td></tr><tr><td>257</td><td>66049</td><td>1</td></tr><tr><td>258</td><td>66564</td><td>0</td></tr><tr><td>259</td><td>67081</td><td>1</td></tr><tr><td>260</td><td>67600</td><td>0</td></tr><tr><td>261</td><td>68121</td><td>1</td></tr><tr><td>262</td><td>68644</td><td>0</td></tr><tr><td>263</td><td>69169</td><td>1</td></tr><tr><td>264</td><td>69696</td><td>0</td></tr><tr><td>265</td><td>70225</td><td>1</td></tr><tr><td>266</td><td>70756</td><td>0</td></tr><tr><td>267</td><td>71289</td><td>1</td></tr><tr><td>268</td><td>71824</td><td>0</td></tr><tr><td>269</td><td>72361</td><td>1</td></tr><tr><td>270</td><td>72900</td><td>0</td></tr><tr><td>271</td><td>73441</td><td>1</td></tr><tr><td>272</td><td>73984</td><td>0</td></tr><tr><td>273</td><td>74529</td><td>1</td></tr><tr><td>274</td><td>75076</td><td>0</td></tr><tr><td>275</td><td>75625</td><td>1</td></tr><tr><td>276</td><td>76176</td><td>0</td></tr><tr><td>277</td><td>76729</td><td>1</td></tr><tr><td>278</td><td>77284</td><td>0</td></tr><tr><td>279</td><td>77841</td><td>1</td></tr><tr><td>280</td><td>78400</td><td>0</td></tr><tr><td>281</td><td>78961</td><td>1</td></tr><tr><td>282</td><td>79524</td><td>0</td></tr><tr><td>283</td><td>80089</td><td>1</td></tr><tr><td>284</td><td>80656</td><td>0</td></tr><tr><td>285</td><td>81225</td><td>1</td></tr><tr><td>286</td><td>81796</td><td>0</td></tr><tr><td>287</td><td>82369</td><td>1</td></tr><tr><td>288</td><td>82944</td><td>0</td></tr><tr><td>289</td><td>83521</td><td>1</td></tr><tr><td>290</td><td>84100</td><td>0</td></tr><tr><td>291</td><td>84681</td><td>1</td></tr><tr><td>292</td><td>85264</td><td>0</td></tr><tr><td>293</td><td>85849</td><td>1</td></tr><tr><td>294</td><td>86436</td><td>0</td></tr><tr><td>295</td><td>87025</td><td>1</td></tr><tr><td>296</td><td>87616</td><td>0</td></tr><tr><td>297</td><td>88209</td><td>1</td></tr><tr><td>298</td><td>88804</td><td>0</td></tr><tr><td>299</td><td>89401</td><td>1</td></tr><tr><td>300</td><td>90000</td><td>0</td></tr><tr><td>301</td><td>90601</td><td>1</td></tr><tr><td>302</td><td>91204</td><td>0</td></tr><tr><td>303</td><td>91809</td><td>1</td></tr><tr><td>304</td><td>92416</td><td>0</td></tr><tr><td>305</td><td>93025</td><td>1</td></tr><tr><td>306</td><td>93636</td><td>0</td></tr><tr><td>307</td><td>94249</td><td>1</td></tr><tr><td>308</td><td>94864</td><td>0</td></tr><tr><td>309</td><td>95481</td><td>1</td></tr><tr><td>310</td><td>96100</td><td>0</td></tr><tr><td>311</td><td>96721</td><td>1</td></tr><tr><td>312</td><td>97344</td><td>0</td></tr><tr><td>313</td><td>97969</td><td>1</td></tr><tr><td>314</td><td>98596</td><td>0</td></tr><tr><td>315</td><td>99225</td><td>1</td></tr><tr><td>316</td><td>99856</td><td>0</td></tr><tr><td>317</td><td>100489</td><td>1</td></tr><tr><td>318</td><td>101124</td><td>0</td></tr><tr><td>319</td><td>101761</td><td>1</td></tr><tr><td>320</td><td>102400</td><td>0</td></tr><tr><td>321</td><td>103041</td><td>1</td></tr><tr><td>322</td><td>103684</td><td>0</td></tr><tr><td>323</td><td>104329</td><td>1</td></tr><tr><td>324</td><td>104976</td><td>0</td></tr><tr><td>325</td><td>105625</td><td>1</td></tr><tr><td>326</td><td>106276</td><td>0</td></tr><tr><td>327</td><td>106929</td><td>1</td></tr><tr><td>328</td><td>107584</td><td>0</td></tr><tr><td>329</td><td>108241</td><td>1</td></tr><tr><td>330</td><td>108900</td><td>0</td></tr><tr><td>331</td><td>109561</td><td>1</td></tr><tr><td>332</td><td>110224</td><td>0</td></tr><tr><td>333</td><td>110889</td><td>1</td></tr><tr><td>334</td><td>111556</td><td>0</td></tr><tr><td>335</td><td>112225</td><td>1</td></tr><tr><td>336</td><td>112896</td><td>0</td></tr><tr><td>337</td><td>113569</td><td>1</td></tr><tr><td>338</td><td>114244</td><td>0</td></tr><tr><td>339</td><td>114921</td><td>1</td></tr><tr><td>340</td><td>115600</td><td>0</td></tr><tr><td>341</td><td>116281</td><td>1</td></tr><tr><td>342</td><td>116964</td><td>0</td></tr><tr><td>343</td><td>117649</td><td>1</td></tr><tr><td>344</td><td>118336</td><td>0</td></tr><tr><td>345</td><td>119025</td><td>1</td></tr><tr><td>346</td><td>119716</td><td>0</td></tr><tr><td>347</td><td>120409</td><td>1</td></tr><tr><td>348</td><td>121104</td><td>0</td></tr><tr><td>349</td><td>121801</td><td>1</td></tr><tr><td>350</td><td>122500</td><td>0</td></tr><tr><td>351</td><td>123201</td><td>1</td></tr><tr><td>352</td><td>123904</td><td>0</td></tr><tr><td>353</td><td>124609</td><td>1</td></tr><tr><td>354</td><td>125316</td><td>0</td></tr><tr><td>355</td><td>126025</td><td>1</td></tr><tr><td>356</td><td>126736</td><td>0</td></tr><tr><td>357</td><td>127449</td><td>1</td></tr><tr><td>358</td><td>128164</td><td>0</td></tr><tr><td>359</td><td>128881</td><td>1</td></tr><tr><td>360</td><td>129600</td><td>0</td></tr><tr><td>361</td><td>130321</td><td>1</td></tr><tr><td>362</td><td>131044</td><td>0</td></tr><tr><td>363</td><td>131769</td><td>1</td></tr><tr><td>364</td><td>132496</td><td>0</td></tr><tr><td>365</td><td>133225</td><td>1</td></tr><tr><td>366</td><td>133956</td><td>0</td></tr><tr><td>367</td><td>134689</td><td>1</td></tr><tr><td>368</td><td>135424</td><td>0</td></tr><tr><td>369</td><td>136161</td><td>1</td></tr><tr><td>370</td><td>136900</td><td>0</td></tr><tr><td>371</td><td>137641</td><td>1</td></tr><tr><td>372</td><td>138384</td><td>0</td></tr><tr><td>373</td><td>139129</td><td>1</td></tr><tr><td>374</td><td>139876</td><td>0</td></tr><tr><td>375</td><td>140625</td><td>1</td></tr><tr><td>376</td><td>141376</td><td>0</td></tr><tr><td>377</td><td>142129</td><td>1</td></tr><tr><td>378</td><td>142884</td><td>0</td></tr><tr><td>379</td><td>143641</td><td>1</td></tr><tr><td>380</td><td>144400</td><td>0</td></tr><tr><td>381</td><td>145161</td><td>1</td></tr><tr><td>382</td><td>145924</td><td>0</td></tr><tr><td>383</td><td>146689</td><td>1</td></tr><tr><td>384</td><td>147456</td><td>0</td></tr><tr><td>385</td><td>148225</td><td>1</td></tr><tr><td>386</td><td>148996</td><td>0</td></tr><tr><td>387</td><td>149769</td><td>1</td></tr><tr><td>388</td><td>150544</td><td>0</td></tr><tr><td>389</td><td>151321</td><td>1</td></tr><tr><td>390</td><td>152100</td><td>0</td></tr><tr><td>391</td><td>152881</td><td>1</td></tr><tr><td>392</td><td>153664</td><td>0</td></tr><tr><td>393</td><td>154449</td><td>1</td></tr><tr><td>394</td><td>155236</td><td>0</td></tr><tr><td>395</td><td>156025</td><td>1</td></tr><tr><td>396</td><td>156816</td><td>0</td></tr><tr><td>397</td><td>157609</td><td>1</td></tr><tr><td>398</td><td>158404</td><td>0</td></tr><tr><td>399</td><td>159201</td><td>1</td></tr><tr><td>400</td><td>160000</td><td>0</td></tr><tr><td>401</td><td>160801</td><td>1</td></tr><tr><td>402</td><td>161604</td><td>0</td></tr><tr><td>403</td><td>162409</td><td>1</td></tr><tr><td>404</td><td>163216</td><td>0</td></tr><tr><td>405</td><td>164025</td><td>1</td></tr><tr><td>406</td><td>164836</td><td>0</td></tr><tr><td>407</td><td>165649</td><td>1</td></tr><tr><td>408</td><td>166464</td><td>0</td></tr><tr><td>409</td><td>167281</td><td>1</td></tr><tr><td>410</td><td>168100</td><td>0</td></tr><tr><td>411</td><td>168921</td><td>1</td></tr><tr><td>412</td><td>169744</td><td>0</td></tr><tr><td>413</td><td>170569</td><td>1</td></tr><tr><td>414</td><td>171396</td><td>0</td></tr><tr><td>415</td><td>172225</td><td>1</td></tr><tr><td>416</td><td>173056</td><td>0</td></tr><tr><td>417</td><td>173889</td><td>1</td></tr><tr><td>418</td><td>174724</td><td>0</td></tr><tr><td>419</td><td>175561</td><td>1</td></tr><tr><td>420</td><td>176400</td><td>0</td></tr><tr><td>421</td><td>177241</td><td>1</td></tr><tr><td>422</td><td>178084</td><td>0</td></tr><tr><td>423</td><td>178929</td><td>1</td></tr><tr><td>424</td><td>179776</td><td>0</td></tr><tr><td>425</td><td>180625</td><td>1</td></tr><tr><td>426</td><td>181476</td><td>0</td></tr><tr><td>427</td><td>182329</td><td>1</td></tr><tr><td>428</td><td>183184</td><td>0</td></tr><tr><td>429</td><td>184041</td><td>1</td></tr><tr><td>430</td><td>184900</td><td>0</td></tr><tr><td>431</td><td>185761</td><td>1</td></tr><tr><td>432</td><td>186624</td><td>0</td></tr><tr><td>433</td><td>187489</td><td>1</td></tr><tr><td>434</td><td>188356</td><td>0</td></tr><tr><td>435</td><td>189225</td><td>1</td></tr><tr><td>436</td><td>190096</td><td>0</td></tr><tr><td>437</td><td>190969</td><td>1</td></tr><tr><td>438</td><td>191844</td><td>0</td></tr><tr><td>439</td><td>192721</td><td>1</td></tr><tr><td>440</td><td>193600</td><td>0</td></tr><tr><td>441</td><td>194481</td><td>1</td></tr><tr><td>442</td><td>195364</td><td>0</td></tr><tr><td>443</td><td>196249</td><td>1</td></tr><tr><td>444</td><td>197136</td><td>0</td></tr><tr><td>445</td><td>198025</td><td>1</td></tr><tr><td>446</td><td>198916</td><td>0</td></tr><tr><td>447</td><td>199809</td><td>1</td></tr><tr><td>448</td><td>200704</td><td>0</td></tr><tr><td>449</td><td>201601</td><td>1</td></tr><tr><td>450</td><td>202500</td><td>0</td></tr><tr><td>451</td><td>203401</td><td>1</td></tr><tr><td>452</td><td>204304</td><td>0</td></tr><tr><td>453</td><td>205209</td><td>1</td></tr><tr><td>454</td><td>206116</td><td>0</td></tr><tr><td>455</td><td>207025</td><td>1</td></tr><tr><td>456</td><td>207936</td><td>0</td></tr><tr><td>457</td><td>208849</td><td>1</td></tr><tr><td>458</td><td>209764</td><td>0</td></tr><tr><td>459</td><td>210681</td><td>1</td></tr><tr><td>460</td><td>211600</td><td>0</td></tr><tr><td>461</td><td>212521</td><td>1</td></tr><tr><td>462</td><td>213444</td><td>0</td></tr><tr><td>463</td><td>214369</td><td>1</td></tr><tr><td>464</td><td>215296</td><td>0</td></tr><tr><td>465</td><td>216225</td><td>1</td></tr><tr><td>466</td><td>217156</td><td>0</td></tr><tr><td>467</td><td>218089</td><td>1</td></tr><tr><td>468</td><td>219024</td><td>0</td></tr><tr><td>469</td><td>219961</td><td>1</td></tr><tr><td>470</td><td>220900</td><td>0</td></tr><tr><td>471</td><td>221841</td><td>1</td></tr><tr><td>472</td><td>222784</td><td>0</td></tr><tr><td>473</td><td>223729</td><td>1</td></tr><tr><td>474</td><td>224676</td><td>0</td></tr><tr><td>475</td><td>225625</td><td>1</td></tr><tr><td>476</td><td>226576</td><td>0</td></tr><tr><td>477</td><td>227529</td><td>1</td></tr><tr><td>478</td><td>228484</td><td>0</td></tr><tr><td>479</td><td>229441</td><td>1</td></tr><tr><td>480</td><td>230400</td><td>0</td></tr><tr><td>481</td><td>231361</td><td>1</td></tr><tr><td>482</td><td>232324</td><td>0</td></tr><tr><td>483</td><td>233289</td><td>1</td></tr><tr><td>484</td><td>234256</td><td>0</td></tr><tr><td>485</td><td>235225</td><td>1</td></tr><tr><td>486</td><td>236196</td><td>0</td></tr><tr><td>487</td><td>237169</td><td>1</td></tr><tr><td>488</td><td>238144</td><td>0</td></tr><tr><td>489</td><td>239121</td><td>1</td></tr><tr><td>490</td><td>240100</td><td>0</td></tr><tr><td>491</td><td>241081</td><td>1</td></tr><tr><td>492</td><td>242064</td><td>0</td></tr><tr><td>493</td><td>243049</td><td>1</td></tr><tr><td>494</td><td>244036</td><td>0</td></tr><tr><td>495</td><td>245025</td><td>1</td></tr><tr><td>496</td><td>246016</td><td>0</td></tr><tr><td>497</td><td>247009</td><td>1</td></tr><tr><td>498</td><td>248004</td><td>0</td></tr><tr><td>499</td><td>249001</td><td>1</td></tr><tr><td>500</td><td>250000</td><td>0</td></tr><tr><td>501</td><td>251001</td><td>1</td></tr><tr><td>502</td><td>252004</td><td>0</td></tr><tr><td>503</td><td>253009</td><td>1</td></tr><tr><td>504</td><td>254016</td><td>0</td></tr><tr><td>505</td><td>255025</td><td>1</td></tr><tr><td>506</td><td>256036</td><td>0</td></tr><tr><td>507</td><td>257049</td><td>1</td></tr><tr><td>508</td><td>258064</td><td>0</td></tr><tr><td>509</td><td>259081</td><td>1</td></tr><tr><td>510</td><td>260100</td><td>0</td></tr><tr><td>511</td><td>261121</td><td>1</td></tr><tr><td>512</td><td>262144</td><td>0</td></tr><tr><td>513</td><td>263169</td><td>1</td></tr><tr><td>514</td><td>264196</td><td>0</td></tr><tr><td>515</td><td>265225</td><td>1</td></tr><tr><td>516</td><td>266256</td><td>0</td></tr><tr><td>517</td><td>267289</td><td>1</td></tr><tr><td>518</td><td>268324</td><td>0</td></tr><tr><td>519</td><td>269361</td><td>1</td></tr><tr><td>520</td><td>270400</td><td>0</td></tr><tr><td>521</td><td>271441</td><td>1</td></tr><tr><td>522</td><td>272484</td><td>0</td></tr><tr><td>523</td><td>273529</td><td>1</td></tr><tr><td>524</td><td>274576</td><td>0</td></tr><tr><td>525</td><td>275625</td><td>1</td></tr><tr><td>526</td><td>276676</td><td>0</td></tr><tr><td>527</td><td>277729</td><td>1</td></tr><tr><td>528</td><td>278784</td><td>0</td></tr><tr><td>529</td><td>279841</td><td>1</td></tr><tr><td>530</td><td>280900</td><td>0</td></tr><tr><td>531</td><td>281961</td><td>1</td></tr><tr><td>532</td><td>283024</td><td>0</td></tr><tr><td>533</td><td>284089</td><td>1</td></tr><tr><td>534</td><td>285156</td><td>0</td></tr><tr><td>535</td><td>286225</td><td>1</td></tr><tr><td>536</td><td>287296</td><td>0</td></tr><tr><td>537</td><td>288369</td><td>1</td></tr><tr><td>538</td><td>289444</td><td>0</td></tr><tr><td>539</td><td>290521</td><td>1</td></tr><tr><td>540</td><td>291600</td><td>0</td></tr><tr><td>541</td><td>292681</td><td>1</td></tr><tr><td>542</td><td>293764</td><td>0</td></tr><tr><td>543</td><td>294849</td><td>1</td></tr><tr><td>544</td><td>295936</td><td>0</td></tr><tr><td>545</td><td>297025</td><td>1</td></tr><tr><td>546</td><td>298116</td><td>0</td></tr><tr><td>547</td><td>299209</td><td>1</td></tr><tr><td>548</td><td>300304</td><td>0</td></tr><tr><td>549</td><td>301401</td><td>1</td></tr><tr><td>550</td><td>302500</td><td>0</td></tr><tr><td>551</td><td>303601</td><td>1</td></tr><tr><td>552</td><td>304704</td><td>0</td></tr><tr><td>553</td><td>305809</td><td>1</td></tr><tr><td>554</td><td>306916</td><td>0</td></tr><tr><td>555</td><td>308025</td><td>1</td></tr><tr><td>556</td><td>309136</td><td>0</td></tr><tr><td>557</td><td>310249</td><td>1</td></tr><tr><td>558</td><td>311364</td><td>0</td></tr><tr><td>559</td><td>312481</td><td>1</td></tr><tr><td>560</td><td>313600</td><td>0</td></tr><tr><td>561</td><td>314721</td><td>1</td></tr><tr><td>562</td><td>315844</td><td>0</td></tr><tr><td>563</td><td>316969</td><td>1</td></tr><tr><td>564</td><td>318096</td><td>0</td></tr><tr><td>565</td><td>319225</td><td>1</td></tr><tr><td>566</td><td>320356</td><td>0</td></tr><tr><td>567</td><td>321489</td><td>1</td></tr><tr><td>568</td><td>322624</td><td>0</td></tr><tr><td>569</td><td>323761</td><td>1</td></tr><tr><td>570</td><td>324900</td><td>0</td></tr><tr><td>571</td><td>326041</td><td>1</td></tr><tr><td>572</td><td>327184</td><td>0</td></tr><tr><td>573</td><td>328329</td><td>1</td></tr><tr><td>574</td><td>329476</td><td>0</td></tr><tr><td>575</td><td>330625</td><td>1</td></tr><tr><td>576</td><td>331776</td><td>0</td></tr><tr><td>577</td><td>332929</td><td>1</td></tr><tr><td>578</td><td>334084</td><td>0</td></tr><tr><td>579</td><td>335241</td><td>1</td></tr><tr><td>580</td><td>336400</td><td>0</td></tr><tr><td>581</td><td>337561</td><td>1</td></tr><tr><td>582</td><td>338724</td><td>0</td></tr><tr><td>583</td><td>339889</td><td>1</td></tr><tr><td>584</td><td>341056</td><td>0</td></tr><tr><td>585</td><td>342225</td><td>1</td></tr><tr><td>586</td><td>343396</td><td>0</td></tr><tr><td>587</td><td>344569</td><td>1</td></tr><tr><td>588</td><td>345744</td><td>0</td></tr><tr><td>589</td><td>346921</td><td>1</td></tr><tr><td>590</td><td>348100</td><td>0</td></tr><tr><td>591</td><td>349281</td><td>1</td></tr><tr><td>592</td><td>350464</td><td>0</td></tr><tr><td>593</td><td>351649</td><td>1</td></tr><tr><td>594</td><td>352836</td><td>0</td></tr><tr><td>595</td><td>354025</td><td>1</td></tr><tr><td>596</td><td>355216</td><td>0</td></tr><tr><td>597</td><td>356409</td><td>1</td></tr><tr><td>598</td><td>357604</td><td>0</td></tr><tr><td>599</td><td>358801</td><td>1</td></tr><tr><td>600</td><td>360000</td><td>0</td></tr><tr><td>601</td><td>361201</td><td>1</td></tr><tr><td>602</td><td>362404</td><td>0</td></tr><tr><td>603</td><td>363609</td><td>1</td></tr><tr><td>604</td><td>364816</td><td>0</td></tr><tr><td>605</td><td>366025</td><td>1</td></tr><tr><td>606</td><td>367236</td><td>0</td></tr><tr><td>607</td><td>368449</td><td>1</td></tr><tr><td>608</td><td>369664</td><td>0</td></tr><tr><td>609</td><td>370881</td><td>1</td></tr><tr><td>610</td><td>372100</td><td>0</td></tr><tr><td>611</td><td>373321</td><td>1</td></tr><tr><td>612</td><td>374544</td><td>0</td></tr><tr><td>613</td><td>375769</td><td>1</td></tr><tr><td>614</td><td>376996</td><td>0</td></tr><tr><td>615</td><td>378225</td><td>1</td></tr><tr><td>616</td><td>379456</td><td>0</td></tr><tr><td>617</td><td>380689</td><td>1</td></tr><tr><td>618</td><td>381924</td><td>0</td></tr><tr><td>619</td><td>383161</td><td>1</td></tr><tr><td>620</td><td>384400</td><td>0</td></tr><tr><td>621</td><td>385641</td><td>1</td></tr><tr><td>622</td><td>386884</td><td>0</td></tr><tr><td>623</td><td>388129</td><td>1</td></tr><tr><td>624</td><td>389376</td><td>0</td></tr><tr><td>625</td><td>390625</td><td>1</td></tr><tr><td>626</td><td>391876</td><td>0</td></tr><tr><td>627</td><td>393129</td><td>1</td></tr><tr><td>628</td><td>394384</td><td>0</td></tr><tr><td>629</td><td>395641</td><td>1</td></tr><tr><td>630</td><td>396900</td><td>0</td></tr><tr><td>631</td><td>398161</td><td>1</td></tr><tr><td>632</td><td>399424</td><td>0</td></tr><tr><td>633</td><td>400689</td><td>1</td></tr><tr><td>634</td><td>401956</td><td>0</td></tr><tr><td>635</td><td>403225</td><td>1</td></tr><tr><td>636</td><td>404496</td><td>0</td></tr><tr><td>637</td><td>405769</td><td>1</td></tr><tr><td>638</td><td>407044</td><td>0</td></tr><tr><td>639</td><td>408321</td><td>1</td></tr><tr><td>640</td><td>409600</td><td>0</td></tr><tr><td>641</td><td>410881</td><td>1</td></tr><tr><td>642</td><td>412164</td><td>0</td></tr><tr><td>643</td><td>413449</td><td>1</td></tr><tr><td>644</td><td>414736</td><td>0</td></tr><tr><td>645</td><td>416025</td><td>1</td></tr><tr><td>646</td><td>417316</td><td>0</td></tr><tr><td>647</td><td>418609</td><td>1</td></tr><tr><td>648</td><td>419904</td><td>0</td></tr><tr><td>649</td><td>421201</td><td>1</td></tr><tr><td>650</td><td>422500</td><td>0</td></tr><tr><td>651</td><td>423801</td><td>1</td></tr><tr><td>652</td><td>425104</td><td>0</td></tr><tr><td>653</td><td>426409</td><td>1</td></tr><tr><td>654</td><td>427716</td><td>0</td></tr><tr><td>655</td><td>429025</td><td>1</td></tr><tr><td>656</td><td>430336</td><td>0</td></tr><tr><td>657</td><td>431649</td><td>1</td></tr><tr><td>658</td><td>432964</td><td>0</td></tr><tr><td>659</td><td>434281</td><td>1</td></tr><tr><td>660</td><td>435600</td><td>0</td></tr><tr><td>661</td><td>436921</td><td>1</td></tr><tr><td>662</td><td>438244</td><td>0</td></tr><tr><td>663</td><td>439569</td><td>1</td></tr><tr><td>664</td><td>440896</td><td>0</td></tr><tr><td>665</td><td>442225</td><td>1</td></tr><tr><td>666</td><td>443556</td><td>0</td></tr><tr><td>667</td><td>444889</td><td>1</td></tr><tr><td>668</td><td>446224</td><td>0</td></tr><tr><td>669</td><td>447561</td><td>1</td></tr><tr><td>670</td><td>448900</td><td>0</td></tr><tr><td>671</td><td>450241</td><td>1</td></tr><tr><td>672</td><td>451584</td><td>0</td></tr><tr><td>673</td><td>452929</td><td>1</td></tr><tr><td>674</td><td>454276</td><td>0</td></tr><tr><td>675</td><td>455625</td><td>1</td></tr><tr><td>676</td><td>456976</td><td>0</td></tr><tr><td>677</td><td>458329</td><td>1</td></tr><tr><td>678</td><td>459684</td><td>0</td></tr><tr><td>679</td><td>461041</td><td>1</td></tr><tr><td>680</td><td>462400</td><td>0</td></tr><tr><td>681</td><td>463761</td><td>1</td></tr><tr><td>682</td><td>465124</td><td>0</td></tr><tr><td>683</td><td>466489</td><td>1</td></tr><tr><td>684</td><td>467856</td><td>0</td></tr><tr><td>685</td><td>469225</td><td>1</td></tr><tr><td>686</td><td>470596</td><td>0</td></tr><tr><td>687</td><td>471969</td><td>1</td></tr><tr><td>688</td><td>473344</td><td>0</td></tr><tr><td>689</td><td>474721</td><td>1</td></tr><tr><td>690</td><td>476100</td><td>0</td></tr><tr><td>691</td><td>477481</td><td>1</td></tr><tr><td>692</td><td>478864</td><td>0</td></tr><tr><td>693</td><td>480249</td><td>1</td></tr><tr><td>694</td><td>481636</td><td>0</td></tr><tr><td>695</td><td>483025</td><td>1</td></tr><tr><td>696</td><td>484416</td><td>0</td></tr><tr><td>697</td><td>485809</td><td>1</td></tr><tr><td>698</td><td>487204</td><td>0</td></tr><tr><td>699</td><td>488601</td><td>1</td></tr><tr><td>700</td><td>490000</td><td>0</td></tr><tr><td>701</td><td>491401</td><td>1</td></tr><tr><td>702</td><td>492804</td><td>0</td></tr><tr><td>703</td><td>494209</td><td>1</td></tr><tr><td>704</td><td>495616</td><td>0</td></tr><tr><td>705</td><td>497025</td><td>1</td></tr><tr><td>706</td><td>498436</td><td>0</td></tr><tr><td>707</td><td>499849</td><td>1</td></tr><tr><td>708</td><td>501264</td><td>0</td></tr><tr><td>709</td><td>502681</td><td>1</td></tr><tr><td>710</td><td>504100</td><td>0</td></tr><tr><td>711</td><td>505521</td><td>1</td></tr><tr><td>712</td><td>506944</td><td>0</td></tr><tr><td>713</td><td>508369</td><td>1</td></tr><tr><td>714</td><td>509796</td><td>0</td></tr><tr><td>715</td><td>511225</td><td>1</td></tr><tr><td>716</td><td>512656</td><td>0</td></tr><tr><td>717</td><td>514089</td><td>1</td></tr><tr><td>718</td><td>515524</td><td>0</td></tr><tr><td>719</td><td>516961</td><td>1</td></tr><tr><td>720</td><td>518400</td><td>0</td></tr><tr><td>721</td><td>519841</td><td>1</td></tr><tr><td>722</td><td>521284</td><td>0</td></tr><tr><td>723</td><td>522729</td><td>1</td></tr><tr><td>724</td><td>524176</td><td>0</td></tr><tr><td>725</td><td>525625</td><td>1</td></tr><tr><td>726</td><td>527076</td><td>0</td></tr><tr><td>727</td><td>528529</td><td>1</td></tr><tr><td>728</td><td>529984</td><td>0</td></tr><tr><td>729</td><td>531441</td><td>1</td></tr><tr><td>730</td><td>532900</td><td>0</td></tr><tr><td>731</td><td>534361</td><td>1</td></tr><tr><td>732</td><td>535824</td><td>0</td></tr><tr><td>733</td><td>537289</td><td>1</td></tr><tr><td>734</td><td>538756</td><td>0</td></tr><tr><td>735</td><td>540225</td><td>1</td></tr><tr><td>736</td><td>541696</td><td>0</td></tr><tr><td>737</td><td>543169</td><td>1</td></tr><tr><td>738</td><td>544644</td><td>0</td></tr><tr><td>739</td><td>546121</td><td>1</td></tr><tr><td>740</td><td>547600</td><td>0</td></tr><tr><td>741</td><td>549081</td><td>1</td></tr><tr><td>742</td><td>550564</td><td>0</td></tr><tr><td>743</td><td>552049</td><td>1</td></tr><tr><td>744</td><td>553536</td><td>0</td></tr><tr><td>745</td><td>555025</td><td>1</td></tr><tr><td>746</td><td>556516</td><td>0</td></tr><tr><td>747</td><td>558009</td><td>1</td></tr><tr><td>748</td><td>559504</td><td>0</td></tr><tr><td>749</td><td>561001</td><td>1</td></tr><tr><td>750</td><td>562500</td><td>0</td></tr><tr><td>751</td><td>564001</td><td>1</td></tr><tr><td>752</td><td>565504</td><td>0</td></tr><tr><td>753</td><td>567009</td><td>1</td></tr><tr><td>754</td><td>568516</td><td>0</td></tr><tr><td>755</td><td>570025</td><td>1</td></tr><tr><td>756</td><td>571536</td><td>0</td></tr><tr><td>757</td><td>573049</td><td>1</td></tr><tr><td>758</td><td>574564</td><td>0</td></tr><tr><td>759</td><td>576081</td><td>1</td></tr><tr><td>760</td><td>577600</td><td>0</td></tr><tr><td>761</td><td>579121</td><td>1</td></tr><tr><td>762</td><td>580644</td><td>0</td></tr><tr><td>763</td><td>582169</td><td>1</td></tr><tr><td>764</td><td>583696</td><td>0</td></tr><tr><td>765</td><td>585225</td><td>1</td></tr><tr><td>766</td><td>586756</td><td>0</td></tr><tr><td>767</td><td>588289</td><td>1</td></tr><tr><td>768</td><td>589824</td><td>0</td></tr><tr><td>769</td><td>591361</td><td>1</td></tr><tr><td>770</td><td>592900</td><td>0</td></tr><tr><td>771</td><td>594441</td><td>1</td></tr><tr><td>772</td><td>595984</td><td>0</td></tr><tr><td>773</td><td>597529</td><td>1</td></tr><tr><td>774</td><td>599076</td><td>0</td></tr><tr><td>775</td><td>600625</td><td>1</td></tr><tr><td>776</td><td>602176</td><td>0</td></tr><tr><td>777</td><td>603729</td><td>1</td></tr><tr><td>778</td><td>605284</td><td>0</td></tr><tr><td>779</td><td>606841</td><td>1</td></tr><tr><td>780</td><td>608400</td><td>0</td></tr><tr><td>781</td><td>609961</td><td>1</td></tr><tr><td>782</td><td>611524</td><td>0</td></tr><tr><td>783</td><td>613089</td><td>1</td></tr><tr><td>784</td><td>614656</td><td>0</td></tr><tr><td>785</td><td>616225</td><td>1</td></tr><tr><td>786</td><td>617796</td><td>0</td></tr><tr><td>787</td><td>619369</td><td>1</td></tr><tr><td>788</td><td>620944</td><td>0</td></tr><tr><td>789</td><td>622521</td><td>1</td></tr><tr><td>790</td><td>624100</td><td>0</td></tr><tr><td>791</td><td>625681</td><td>1</td></tr><tr><td>792</td><td>627264</td><td>0</td></tr><tr><td>793</td><td>628849</td><td>1</td></tr><tr><td>794</td><td>630436</td><td>0</td></tr><tr><td>795</td><td>632025</td><td>1</td></tr><tr><td>796</td><td>633616</td><td>0</td></tr><tr><td>797</td><td>635209</td><td>1</td></tr><tr><td>798</td><td>636804</td><td>0</td></tr><tr><td>799</td><td>638401</td><td>1</td></tr><tr><td>800</td><td>640000</td><td>0</td></tr><tr><td>801</td><td>641601</td><td>1</td></tr><tr><td>802</td><td>643204</td><td>0</td></tr><tr><td>803</td><td>644809</td><td>1</td></tr><tr><td>804</td><td>646416</td><td>0</td></tr><tr><td>805</td><td>648025</td><td>1</td></tr><tr><td>806</td><td>649636</td><td>0</td></tr><tr><td>807</td><td>651249</td><td>1</td></tr><tr><td>808</td><td>652864</td><td>0</td></tr><tr><td>809</td><td>654481</td><td>1</td></tr><tr><td>810</td><td>656100</td><td>0</td></tr><tr><td>811</td><td>657721</td><td>1</td></tr><tr><td>812</td><td>659344</td><td>0</td></tr><tr><td>813</td><td>660969</td><td>1</td></tr><tr><td>814</td><td>662596</td><td>0</td></tr><tr><td>815</td><td>664225</td><td>1</td></tr><tr><td>816</td><td>665856</td><td>0</td></tr><tr><td>817</td><td>667489</td><td>1</td></tr><tr><td>818</td><td>669124</td><td>0</td></tr><tr><td>819</td><td>670761</td><td>1</td></tr><tr><td>820</td><td>672400</td><td>0</td></tr><tr><td>821</td><td>674041</td><td>1</td></tr><tr><td>822</td><td>675684</td><td>0</td></tr><tr><td>823</td><td>677329</td><td>1</td></tr><tr><td>824</td><td>678976</td><td>0</td></tr><tr><td>825</td><td>680625</td><td>1</td></tr><tr><td>826</td><td>682276</td><td>0</td></tr><tr><td>827</td><td>683929</td><td>1</td></tr><tr><td>828</td><td>685584</td><td>0</td></tr><tr><td>829</td><td>687241</td><td>1</td></tr><tr><td>830</td><td>688900</td><td>0</td></tr><tr><td>831</td><td>690561</td><td>1</td></tr><tr><td>832</td><td>692224</td><td>0</td></tr><tr><td>833</td><td>693889</td><td>1</td></tr><tr><td>834</td><td>695556</td><td>0</td></tr><tr><td>835</td><td>697225</td><td>1</td></tr><tr><td>836</td><td>698896</td><td>0</td></tr><tr><td>837</td><td>700569</td><td>1</td></tr><tr><td>838</td><td>702244</td><td>0</td></tr><tr><td>839</td><td>703921</td><td>1</td></tr><tr><td>840</td><td>705600</td><td>0</td></tr><tr><td>841</td><td>707281</td><td>1</td></tr><tr><td>842</td><td>708964</td><td>0</td></tr><tr><td>843</td><td>710649</td><td>1</td></tr><tr><td>844</td><td>712336</td><td>0</td></tr><tr><td>845</td><td>714025</td><td>1</td></tr><tr><td>846</td><td>715716</td><td>0</td></tr><tr><td>847</td><td>717409</td><td>1</td></tr><tr><td>848</td><td>719104</td><td>0</td></tr><tr><td>849</td><td>720801</td><td>1</td></tr><tr><td>850</td><td>722500</td><td>0</td></tr><tr><td>851</td><td>724201</td><td>1</td></tr><tr><td>852</td><td>725904</td><td>0</td></tr><tr><td>853</td><td>727609</td><td>1</td></tr><tr><td>854</td><td>729316</td><td>0</td></tr><tr><td>855</td><td>731025</td><td>1</td></tr><tr><td>856</td><td>732736</td><td>0</td></tr><tr><td>857</td><td>734449</td><td>1</td></tr><tr><td>858</td><td>736164</td><td>0</td></tr><tr><td>859</td><td>737881</td><td>1</td></tr><tr><td>860</td><td>739600</td><td>0</td></tr><tr><td>861</td><td>741321</td><td>1</td></tr><tr><td>862</td><td>743044</td><td>0</td></tr><tr><td>863</td><td>744769</td><td>1</td></tr><tr><td>864</td><td>746496</td><td>0</td></tr><tr><td>865</td><td>748225</td><td>1</td></tr><tr><td>866</td><td>749956</td><td>0</td></tr><tr><td>867</td><td>751689</td><td>1</td></tr><tr><td>868</td><td>753424</td><td>0</td></tr><tr><td>869</td><td>755161</td><td>1</td></tr><tr><td>870</td><td>756900</td><td>0</td></tr><tr><td>871</td><td>758641</td><td>1</td></tr><tr><td>872</td><td>760384</td><td>0</td></tr><tr><td>873</td><td>762129</td><td>1</td></tr><tr><td>874</td><td>763876</td><td>0</td></tr><tr><td>875</td><td>765625</td><td>1</td></tr><tr><td>876</td><td>767376</td><td>0</td></tr><tr><td>877</td><td>769129</td><td>1</td></tr><tr><td>878</td><td>770884</td><td>0</td></tr><tr><td>879</td><td>772641</td><td>1</td></tr><tr><td>880</td><td>774400</td><td>0</td></tr><tr><td>881</td><td>776161</td><td>1</td></tr><tr><td>882</td><td>777924</td><td>0</td></tr><tr><td>883</td><td>779689</td><td>1</td></tr><tr><td>884</td><td>781456</td><td>0</td></tr><tr><td>885</td><td>783225</td><td>1</td></tr><tr><td>886</td><td>784996</td><td>0</td></tr><tr><td>887</td><td>786769</td><td>1</td></tr><tr><td>888</td><td>788544</td><td>0</td></tr><tr><td>889</td><td>790321</td><td>1</td></tr><tr><td>890</td><td>792100</td><td>0</td></tr><tr><td>891</td><td>793881</td><td>1</td></tr><tr><td>892</td><td>795664</td><td>0</td></tr><tr><td>893</td><td>797449</td><td>1</td></tr><tr><td>894</td><td>799236</td><td>0</td></tr><tr><td>895</td><td>801025</td><td>1</td></tr><tr><td>896</td><td>802816</td><td>0</td></tr><tr><td>897</td><td>804609</td><td>1</td></tr><tr><td>898</td><td>806404</td><td>0</td></tr><tr><td>899</td><td>808201</td><td>1</td></tr><tr><td>900</td><td>810000</td><td>0</td></tr><tr><td>901</td><td>811801</td><td>1</td></tr><tr><td>902</td><td>813604</td><td>0</td></tr><tr><td>903</td><td>815409</td><td>1</td></tr><tr><td>904</td><td>817216</td><td>0</td></tr><tr><td>905</td><td>819025</td><td>1</td></tr><tr><td>906</td><td>820836</td><td>0</td></tr><tr><td>907</td><td>822649</td><td>1</td></tr><tr><td>908</td><td>824464</td><td>0</td></tr><tr><td>909</td><td>826281</td><td>1</td></tr><tr><td>910</td><td>828100</td><td>0</td></tr><tr><td>911</td><td>829921</td><td>1</td></tr><tr><td>912</td><td>831744</td><td>0</td></tr><tr><td>913</td><td>833569</td><td>1</td></tr><tr><td>914</td><td>835396</td><td>0</td></tr><tr><td>915</td><td>837225</td><td>1</td></tr><tr><td>916</td><td>839056</td><td>0</td></tr><tr><td>917</td><td>840889</td><td>1</td></tr><tr><td>918</td><td>842724</td><td>0</td></tr><tr><td>919</td><td>844561</td><td>1</td></tr><tr><td>920</td><td>846400</td><td>0</td></tr><tr><td>921</td><td>848241</td><td>1</td></tr><tr><td>922</td><td>850084</td><td>0</td></tr><tr><td>923</td><td>851929</td><td>1</td></tr><tr><td>924</td><td>853776</td><td>0</td></tr><tr><td>925</td><td>855625</td><td>1</td></tr><tr><td>926</td><td>857476</td><td>0</td></tr><tr><td>927</td><td>859329</td><td>1</td></tr><tr><td>928</td><td>861184</td><td>0</td></tr><tr><td>929</td><td>863041</td><td>1</td></tr><tr><td>930</td><td>864900</td><td>0</td></tr><tr><td>931</td><td>866761</td><td>1</td></tr><tr><td>932</td><td>868624</td><td>0</td></tr><tr><td>933</td><td>870489</td><td>1</td></tr><tr><td>934</td><td>872356</td><td>0</td></tr><tr><td>935</td><td>874225</td><td>1</td></tr><tr><td>936</td><td>876096</td><td>0</td></tr><tr><td>937</td><td>877969</td><td>1</td></tr><tr><td>938</td><td>879844</td><td>0</td></tr><tr><td>939</td><td>881721</td><td>1</td></tr><tr><td>940</td><td>883600</td><td>0</td></tr><tr><td>941</td><td>885481</td><td>1</td></tr><tr><td>942</td><td>887364</td><td>0</td></tr><tr><td>943</td><td>889249</td><td>1</td></tr><tr><td>944</td><td>891136</td><td>0</td></tr><tr><td>945</td><td>893025</td><td>1</td></tr><tr><td>946</td><td>894916</td><td>0</td></tr><tr><td>947</td><td>896809</td><td>1</td></tr><tr><td>948</td><td>898704</td><td>0</td></tr><tr><td>949</td><td>900601</td><td>1</td></tr><tr><td>950</td><td>902500</td><td>0</td></tr><tr><td>951</td><td>904401</td><td>1</td></tr><tr><td>952</td><td>906304</td><td>0</td></tr><tr><td>953</td><td>908209</td><td>1</td></tr><tr><td>954</td><td>910116</td><td>0</td></tr><tr><td>955</td><td>912025</td><td>1</td></tr><tr><td>956</td><td>913936</td><td>0</td></tr><tr><td>957</td><td>915849</td><td>1</td></tr><tr><td>958</td><td>917764</td><td>0</td></tr><tr><td>959</td><td>919681</td><td>1</td></tr><tr><td>960</td><td>921600</td><td>0</td></tr><tr><td>961</td><td>923521</td><td>1</td></tr><tr><td>962</td><td>925444</td><td>0</td></tr><tr><td>963</td><td>927369</td><td>1</td></tr><tr><td>964</td><td>929296</td><td>0</td></tr><tr><td>965</td><td>931225</td><td>1</td></tr><tr><td>966</td><td>933156</td><td>0</td></tr><tr><td>967</td><td>935089</td><td>1</td></tr><tr><td>968</td><td>937024</td><td>0</td></tr><tr><td>969</td><td>938961</td><td>1</td></tr><tr><td>970</td><td>940900</td><td>0</td></tr><tr><td>971</td><td>942841</td><td>1</td></tr><tr><td>972</td><td>944784</td><td>0</td></tr><tr><td>973</td><td>946729</td><td>1</td></tr><tr><td>974</td><td>948676</td><td>0</td></tr><tr><td>975</td><td>950625</td><td>1</td></tr><tr><td>976</td><td>952576</td><td>0</td></tr><tr><td>977</td><td>954529</td><td>1</td></tr><tr><td>978</td><td>956484</td><td>0</td></tr><tr><td>979</td><td>958441</td><td>1</td></tr><tr><td>980</td><td>960400</td><td>0</td></tr><tr><td>981</td><td>962361</td><td>1</td></tr><tr><td>982</td><td>964324</td><td>0</td></tr><tr><td>983</td><td>966289</td><td>1</td></tr><tr><td>984</td><td>968256</td><td>0</td></tr><tr><td>985</td><td>970225</td><td>1</td></tr><tr><td>986</td><td>972196</td><td>0</td></tr><tr><td>987</td><td>974169</td><td>1</td></tr><tr><td>988</td><td>976144</td><td>0</td></tr><tr><td>989</td><td>978121</td><td>1</td></tr><tr><td>990</td><td>980100</td><td>0</td></tr><tr><td>991</td><td>982081</td><td>1</td></tr><tr><td>992</td><td>984064</td><td>0</td></tr><tr><td>993</td><td>986049</td><td>1</td></tr><tr><td>994</td><td>988036</td><td>0</td></tr><tr><td>995</td><td>990025</td><td>1</td></tr><tr><td>996</td><td>992016</td><td>0</td></tr><tr><td>997</td><td>994009</td><td>1</td></tr><tr><td>998</td><td>996004</td><td>0</td></tr><tr><td>999</td><td>998001</td><td>1</td></tr></tbody></table></div>"]}}],"execution_count":19},{"cell_type":"code","source":["#UDAF\nimport numpy as np\n@pandas_udf(\"key int, sqr int\", PandasUDFType.GROUPED_MAP)\ndef func(pdf):\n  sqr = pdf.sqr\n  return pdf.assign(sqr=(np.sum(sqr)))\n\ndf.select(['key','sqr']).groupBy(\"key\").apply(func).distinct().show()"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">+---+---------+\nkey|      sqr|\n+---+---------+\n  0|166167000|\n  1|166666500|\n+---+---------+\n\n</div>"]}}],"execution_count":20},{"cell_type":"code","source":[""],"metadata":{},"outputs":[],"execution_count":21}],"metadata":{"name":"UDF, UDAF using pandasUDF","notebookId":3094644534275145},"nbformat":4,"nbformat_minor":0}