Google Git
Sign in
apache / griffin / refs/tags/griffin-0.1.5-incubating / . / ui / pages / measures / va-explaination.html
blob: 18ccc9ab66c8619f713adafbbee1fecb4b19a1b6 [file] [log] [blame]
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
<!-- Simple Statistics -->
<!-- Null Count -->
<div class="container-fluid" ng-show="form.vaType==2">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is Null Count ?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Null is a special marker used to indicate that a data value does not exist.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Suppose we have the below data table, then the Null Count of "FIRSTNAME" is <kbd style="font-size: 16px">3</kbd>
</label>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<thead>
<tr class="success">
<td>ID</td>
<td>FRISTNAME</td>
<td>LASTNAME</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>lei</td>
<td>li</td>
</tr>
<tr>
<td>2</td>
<td>lei</td>
<td>li</td>
</tr>
<tr>
<td>3</td>
<td>lei</td>
<td>li</td>
</tr>
<tr>
<td>4</td>
<td>
<abbr title="the value isn't necessary " class="initialism"><mark>null</mark></abbr>
</td>
<td>stone</td>
</tr>
<tr>
<td>5</td>
<td>lei</td>
<td>li</td>
</tr>
<tr>
<td>6</td>
<td>lei</td>
<td>li</td>
</tr>
<tr>
<td>7</td>
<td>
<abbr title="the value isn't necessary " class="initialism"><mark>null</mark></abbr>
</td>
<td>stone</td>
</tr>
<tr>
<td>8</td>
<td>
<abbr title="the value isn't necessary " class="initialism"><mark>null</mark></abbr>
</td>
<td>zhang</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Unique Count -->
<div class="container-fluid" ng-show="form.vaType==3">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is Unique Count ?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
The UNIQUE Constraint prevents two records from having identical values in a particular column.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Suppose we have the below data table which has four attributes-ID, NAME, AGE and FAVOURITE FOOD. Then the Unique Count is <kbd style="font-size: 16px">2</kbd>
</label>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<colgroup>
<col span="2" style="background-color:#064225">
</colgroup>
<thead>
<tr class="success">
<td>ID</td>
<td>NAME</td>
<td>AGE</td>
<td>FAVOURITE FOOD</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>Lily</td>
<td>20</td>
<td>APPLE</td>
</tr>
<tr>
<td>2</td>
<td>Lucy</td>
<td>20</td>
<td>APPLE</td>
</tr>
<tr>
<td>3</td>
<td>John</td>
<td>20</td>
<td>APPLE</td>
</tr>
<tr>
<td>4</td>
<td>David</td>
<td>20</td>
<td>APPLE</td>
</tr>
<tr>
<td>5</td>
<td>Sam</td>
<td>35</td>
<td>banana</td>
</tr>
<tr>
<td>6</td>
<td>Kaka</td>
<td>35</td>
<td>banana</td>
</tr>
<tr>
<td>7</td>
<td>stone</td>
<td>35</td>
<td>banana</td>
</tr>
<tr>
<td>8</td>
<td>Adison</td>
<td>35</td>
<td>banana</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Duplicate Count -->
<div class="container-fluid" ng-show="form.vaType==4">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is Duplicate Count ?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Duplicate Count is the number of duplicate rows in a table and generate an output column that shows how many times each row occurs.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Suppose we have the below data table, and we only count the the number of duplicate rows for age. Then the Duplicate Count is <kbd style="font-size: 16px">2</kbd>
</label>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<thead>
<tr class="success">
<td>ID</td>
<td>NAME</td>
<td>AGE</td>
<td>FAVOURITE FOOD</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>Lily</td>
<td>21</td>
<td>APPLE</td>
</tr>
<tr>
<td>2</td>
<td>Lucy</td>
<td class="info">20</td>
<td>APPLE</td>
</tr>
<tr>
<td>3</td>
<td>John</td>
<td class="info">20</td>
<td>APPLE</td>
</tr>
<tr>
<td>4</td>
<td>David</td>
<td class="info">20</td>
<td>APPLE</td>
</tr>
<tr>
<td>5</td>
<td>Sam</td>
<td>37</td>
<td>banana</td>
</tr>
<tr>
<td>6</td>
<td>Kaka</td>
<td class="warning">35</td>
<td>banana</td>
</tr>
<tr>
<td>7</td>
<td>stone</td>
<td class="warning">35</td>
<td>banana</td>
</tr>
<tr>
<td>8</td>
<td>Adison</td>
<td>38</td>
<td>banana</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Summary Statistics -->
<!-- Maximum -->
<div class="container-fluid" ng-show="form.vaType==5">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is Maximum ?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Maximum is the biggest value of the selected column.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
Suppose we have the below data table, then the maximum is: 26 <kbd style="font-size: 16px">26</kbd>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<thead>
<tr class="success">
<td>ID</td>
<td>NAME</td>
<td>AGE</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>lei</td>
<td>17</td>
</tr>
<tr>
<td>2</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>3</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>4</td>
<td>lei</td>
<td>21</td>
</tr>
<tr>
<td>5</td>
<td>lei</td>
<td>23</td>
</tr>
<tr>
<td>6</td>
<td>lei</td>
<td>23</td>
</tr>
<tr>
<td>7</td>
<td>lei</td>
<td>24</td>
</tr>
<tr>
<td>8</td>
<td>lei</td>
<td>
<abbr title="the value is the biggest number " class="initialism"><mark>26</mark></abbr>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Minimum -->
<div class="container-fluid" ng-show="form.vaType==6">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is Minimum ?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Minimum is smallest value of the selected column.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
Suppose we have the below data table, then the minimum is: <kbd style="font-size: 16px">14</kbd>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<thead>
<tr class="success">
<td>ID</td>
<td>NAME</td>
<td>AGE</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>lei</td>
<td>17</td>
</tr>
<tr>
<td>2</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>3</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>4</td>
<td>lei</td>
<td>
<abbr title="the value is the minimum number " class="initialism"><mark>14</mark></abbr>
</td>
</tr>
<tr>
<td>5</td>
<td>lei</td>
<td>23</td>
</tr>
<tr>
<td>6</td>
<td>lei</td>
<td>23</td>
</tr>
<tr>
<td>7</td>
<td>lei</td>
<td>24</td>
</tr>
<tr>
<td>8</td>
<td>lei</td>
<td>26</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Mean -->
<div class="container-fluid" ng-show="form.vaType==7">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is Mean ?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Mean is the usual average.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
Suppose we have the below data table, then the mean of AGE is: <kbd style="font-size: 16px">20</kbd>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<thead>
<tr class="success">
<td>ID</td>
<td>NAME</td>
<td>AGE</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>2</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>3</td>
<td>lei</td>
<td>19</td>
</tr>
<tr>
<td>4</td>
<td>lei</td>
<td>19</td>
</tr>
<tr>
<td>5</td>
<td>lei</td>
<td>21</td>
</tr>
<tr>
<td>6</td>
<td>lei</td>
<td>21</td>
</tr>
<tr>
<td>7</td>
<td>lei</td>
<td>22</td>
</tr>
<tr>
<td>8</td>
<td>lei</td>
<td>22</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Median -->
<div class="container-fluid" ng-show="form.vaType==8">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is Median ?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
Median is the middle value.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
Suppose we have the below data table, then the median of AGE is: <kbd style="font-size: 16px">21</kbd>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<thead>
<tr class="success">
<td>ID</td>
<td>NAME</td>
<td>AGE</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>lei</td>
<td>17</td>
</tr>
<tr>
<td>2</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>3</td>
<td>lei</td>
<td>19</td>
</tr>
<tr>
<td>4</td>
<td>lei</td>
<td>20</td>
</tr>
<tr>
<td>5</td>
<td>lei</td>
<td>21</td>
</tr>
<tr>
<td>6</td>
<td>lei</td>
<td>21</td>
</tr>
<tr>
<td>7</td>
<td>lei</td>
<td>22</td>
</tr>
<tr>
<td>8</td>
<td>lei</td>
<td>22</td>
</tr>
<tr>
<td>9</td>
<td>lei</td>
<td>23</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Regular Expression Matching -->
<div class="container-fluid" ng-show="form.vaType==9">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">What is the Regular Expression Match?</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
In theoretical computer science and formal language theory, a regular expression (sometimes called a rational expression) is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations.
</label>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<h5 class="text-left" style="margin-left: 0px">Example</h5>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<label class="text-left">
There is a series characters of in the column of IDENTIFIER in the following table, and we can use a kind of Regular Expression Matching to search it.
</label>
</div>
</div>
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<table class="table table-bordered text-center">
<thead>
<tr class="success">
<td>IDENTIFIER</td>
<td>NAME</td>
<td>AGE</td>
</tr>
</thead>
<tbody>
<tr>
<td>#1111</td>
<td>lei</td>
<td>17</td>
</tr>
<tr>
<td>#1245</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>15245</td>
<td>lei</td>
<td>18</td>
</tr>
<tr>
<td>87956</td>
<td>lei</td>
<td>21</td>
</tr>
<tr>
<td>
<abbr title="the value is the biggest number " class="initialism">
<mark>monkey</mark>
</abbr>
</td>
<td>lei</td>
<td>23</td>
</tr>
<tr>
<td>
<abbr title="the value is the biggest number " class="initialism">
<mark>tiger</mark>
</abbr>
</td>
<td>lei</td>
<td>23</td>
</tr>
<tr>
<td>456</td>
<td>lei</td>
<td>24</td>
</tr>
<tr>
<td>324</td>
<td>lei</td>
<td>26</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<p class="text-left">
<strong>Suppose Regular Expression is :</strong> ^[A-Za-z]+$
</p>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<p class="text-left">
<strong>The regular expression matching means :</strong> Matches a string consisting of 26 english letters
</p>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-md-12 col-lg-12 col-sm-12">
<p class="text-left">
The result is: <kbd>2 (MONKEY AND TIGER)</kbd>
</p>
</div>
</div>
</div>
</div>