doc/source/_static/schemas/06_groupby.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!-- Created with Inkscape (http://www.inkscape.org/) -->

<svg
   xmlns:dc="http://purl.org/dc/elements/1.1/"
   xmlns:cc="http://creativecommons.org/ns#"
   xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
   xmlns:svg="http://www.w3.org/2000/svg"
   xmlns="http://www.w3.org/2000/svg"
   xmlns:sodipodi="http://sodipodi.sourceforge.net/DTD/sodipodi-0.dtd"
   xmlns:inkscape="http://www.inkscape.org/namespaces/inkscape"
   width="464.94458mm"
   height="165.19176mm"
   viewBox="0 0 464.94458 165.19176"
   version="1.1"
   id="svg14732"
   inkscape:version="0.92.4 (f8dce91, 2019-08-02)"
   sodipodi:docname="06_groupby.svg">
  <defs
     id="defs14726">
    <marker
       inkscape:stockid="Arrow2Lend"
       orient="auto"
       refY="0"
       refX="0"
       id="Arrow2Lend-7-6-9-4-2-3-3"
       style="overflow:visible"
       inkscape:isstock="true">
      <path
         inkscape:connector-curvature="0"
         id="path7253-1-4-3-6-9-2-86"
         style="fill:#000000;fill-opacity:1;fill-rule:evenodd;stroke:#000000;stroke-width:0.625;stroke-linejoin:round;stroke-opacity:1"
         d="M 8.7185878,4.0337352 -2.2072895,0.01601326 8.7185884,-4.0017078 c -1.7454984,2.3720609 -1.7354408,5.6174519 -6e-7,8.035443 z"
         transform="matrix(-1.1,0,0,-1.1,-1.1,0)" />
    </marker>
    <marker
       inkscape:stockid="Arrow2Lend"
       orient="auto"
       refY="0"
       refX="0"
       id="Arrow2Lend-7-6-9-4-2-3-1-7"
       style="overflow:visible"
       inkscape:isstock="true">
      <path
         inkscape:connector-curvature="0"
         id="path7253-1-4-3-6-9-2-8-3"
         style="fill:#000000;fill-opacity:1;fill-rule:evenodd;stroke:#000000;stroke-width:0.625;stroke-linejoin:round;stroke-opacity:1"
         d="M 8.7185878,4.0337352 -2.2072895,0.01601326 8.7185884,-4.0017078 c -1.7454984,2.3720609 -1.7354408,5.6174519 -6e-7,8.035443 z"
         transform="matrix(-1.1,0,0,-1.1,-1.1,0)" />
    </marker>
  </defs>
  <sodipodi:namedview
     id="base"
     pagecolor="#ffffff"
     bordercolor="#666666"
     borderopacity="1.0"
     inkscape:pageopacity="0.0"
     inkscape:pageshadow="2"
     inkscape:zoom="0.49497475"
     inkscape:cx="808.73401"
     inkscape:cy="127.43429"
     inkscape:document-units="mm"
     inkscape:current-layer="layer1"
     showgrid="false"
     fit-margin-top="0"
     fit-margin-left="0"
     fit-margin-right="0"
     fit-margin-bottom="0"
     inkscape:window-width="1551"
     inkscape:window-height="849"
     inkscape:window-x="49"
     inkscape:window-y="27"
     inkscape:window-maximized="1" />
  <metadata
     id="metadata14729">
    <rdf:RDF>
      <cc:Work
         rdf:about="">
        <dc:format>image/svg+xml</dc:format>
        <dc:type
           rdf:resource="http://purl.org/dc/dcmitype/StillImage" />
        <dc:title />
      </cc:Work>
    </rdf:RDF>
  </metadata>
  <g
     inkscape:label="Layer 1"
     inkscape:groupmode="layer"
     id="layer1"
     transform="translate(120.59136,-57.166026)">
    <path
       d="m -107.12734,127.31387 h 24.887965 V 115.1259 h -24.887965 z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-1-94-33-8"
       inkscape:connector-curvature="0" />
    <path
       d="m -107.12734,140.01387 h 24.887965 v -12.18796 h -24.887965 z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-5-1-4-9-6"
       inkscape:connector-curvature="0" />
    <path
       d="m -81.727335,113.59785 h 24.88796 V 101.4099 h -24.88796 z"
       style="fill:#150458;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-6-7-6-4-5"
       inkscape:connector-curvature="0" />
    <path
       d="m -81.727335,127.31387 h 24.88796 V 115.1259 h -24.88796 z"
       style="fill:#8b6ff9;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-5-0-6-9-2"
       inkscape:connector-curvature="0" />
    <path
       d="m -81.727335,140.01387 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#2808ac;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-2-3-4-39-9-4"
       inkscape:connector-curvature="0" />
    <path
       d="m -107.12734,152.71388 h 24.887965 v -12.18796 h -24.887965 z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-8-2-9-0"
       inkscape:connector-curvature="0" />
    <path
       d="m -81.727335,152.71388 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#8b6ff9;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-7-8-51-1-4-6"
       inkscape:connector-curvature="0" />
    <path
       d="m -107.12734,165.41389 h 24.887965 v -12.18796 h -24.887965 z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-0-6-0-0-5"
       inkscape:connector-curvature="0" />
    <path
       d="m -81.727335,165.41389 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#8b6ff9;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-7-8-5-21-9-6-4"
       inkscape:connector-curvature="0" />
    <path
       d="m -107.12734,178.1139 h 24.887965 v -12.18796 h -24.887965 z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-0-7-4-1-9-4"
       inkscape:connector-curvature="0" />
    <path
       d="m -81.727335,178.1139 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#2808ac;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-7-8-5-2-8-34-5-6"
       inkscape:connector-curvature="0" />
    <path
       d="m -56.327325,152.71388 h 24.88795 v -12.18796 h -24.88795 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-2-0-58-6-8"
       inkscape:connector-curvature="0" />
    <path
       d="m -56.327335,113.59785 h 24.88796 V 101.4099 h -24.88796 z"
       style="fill:#ffca00;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-8-8-5-1-3"
       inkscape:connector-curvature="0" />
    <path
       d="m -56.327325,127.31387 h 24.88795 V 115.1259 h -24.88795 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-4-1-73-1-2"
       inkscape:connector-curvature="0" />
    <path
       d="m -56.327335,140.01387 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-5-5-0-3-4-3"
       inkscape:connector-curvature="0" />
    <path
       d="m -56.327325,165.41389 h 24.88795 v -12.18796 h -24.88795 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-2-7-2-89-3-6"
       inkscape:connector-curvature="0" />
    <path
       d="m -56.327325,178.1139 h 24.88795 v -12.18796 h -24.88795 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-2-7-1-29-55-7-22"
       inkscape:connector-curvature="0" />
    <path
       d="m 279.58525,146.36389 h 24.88794 v -12.18797 h -24.88794 z"
       style="fill:#8b6ff9;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-74-6-3-4-4"
       inkscape:connector-curvature="0" />
    <path
       d="M 306.00124,132.64787 H 330.8892 V 120.45992 H 306.00124 Z"
       style="fill:#ffca00;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-17-40-0-4-7"
       inkscape:connector-curvature="0" />
    <path
       d="M 306.00124,146.36389 H 330.8892 V 134.17592 H 306.00124 Z"
       style="fill:#e50387;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-1-94-33-4-0"
       inkscape:connector-curvature="0" />
    <path
       d="m 279.58524,159.06389 h 24.88795 v -12.18796 h -24.88795 z"
       style="fill:#2808ac;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-2-1-5-7-9-4"
       inkscape:connector-curvature="0" />
    <path
       d="M 306.00124,159.06389 H 330.8892 V 146.87593 H 306.00124 Z"
       style="fill:#e50387;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-5-1-4-9-9-9"
       inkscape:connector-curvature="0" />
    <path
       style="fill:none;stroke:#000000;stroke-width:0.40000001;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;marker-end:url(#Arrow2Lend-7-6-9-4-2-3-3)"
       d="m 203.45015,139.76895 h 47.88958"
       id="path6109-2-9-6-9-0-9-4"
       inkscape:connector-curvature="0" />
    <path
       style="fill:none;stroke:#000000;stroke-width:0.40000001;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;marker-end:url(#Arrow2Lend-7-6-9-4-2-3-1-7)"
       d="M -3.8625116,139.76895 H 44.027068"
       id="path6109-2-9-6-9-0-9-7-0"
       inkscape:connector-curvature="0" />
    <path
       d="m 86.228953,184.50217 h 24.887957 v -12.1879 H 86.228953 Z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-1-94-33-49-2-90"
       inkscape:connector-curvature="0" />
    <path
       d="m 86.228953,197.20217 h 24.887957 v -12.1879 H 86.228953 Z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-5-1-4-9-5-7-4"
       inkscape:connector-curvature="0" />
    <path
       d="m 111.62895,170.78617 h 24.88796 v -12.1879 h -24.88796 z"
       style="fill:#150458;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-6-7-6-4-7-9-85"
       inkscape:connector-curvature="0" />
    <path
       d="m 111.62895,184.50217 h 24.88796 v -12.1879 h -24.88796 z"
       style="fill:#2808ac;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-5-0-6-9-3-5-8"
       inkscape:connector-curvature="0" />
    <path
       d="m 111.62895,197.20217 h 24.88796 v -12.1879 h -24.88796 z"
       style="fill:#2808ac;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-2-3-4-39-9-9-6-2"
       inkscape:connector-curvature="0" />
    <path
       d="m 137.02895,170.78617 h 24.88796 v -12.1879 h -24.88796 z"
       style="fill:#ffca00;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-8-8-5-1-1-21-2"
       inkscape:connector-curvature="0" />
    <path
       d="m 137.02896,184.50217 h 24.88795 v -12.1879 h -24.88795 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-4-1-73-1-7-0-0"
       inkscape:connector-curvature="0" />
    <path
       d="m 137.02895,197.20217 h 24.88796 v -12.1879 h -24.88796 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-5-5-0-3-4-9-5-6"
       inkscape:connector-curvature="0" />
    <path
       d="M 86.228963,108.22561 H 111.11692 V 96.037639 H 86.228963 Z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-1-94-33-8-7"
       inkscape:connector-curvature="0" />
    <path
       d="M 86.228963,120.92561 H 111.11692 V 108.73765 H 86.228963 Z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-5-1-4-9-6-3"
       inkscape:connector-curvature="0" />
    <path
       d="m 111.62896,94.509589 h 24.88796 v -12.18795 h -24.88796 z"
       style="fill:#150458;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-6-7-6-4-5-5"
       inkscape:connector-curvature="0" />
    <path
       d="m 111.62896,108.22561 h 24.88796 V 96.037639 h -24.88796 z"
       style="fill:#8b6ff9;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-5-0-6-9-2-6"
       inkscape:connector-curvature="0" />
    <path
       d="m 111.62896,120.92561 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#8b6ff9;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-2-3-4-39-9-4-2"
       inkscape:connector-curvature="0" />
    <path
       d="M 86.228963,133.62562 H 111.11692 V 121.43766 H 86.228963 Z"
       style="fill:#afabab;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-8-2-9-0-1"
       inkscape:connector-curvature="0" />
    <path
       d="m 111.62896,133.62562 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#8b6ff9;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-7-8-51-1-4-6-2"
       inkscape:connector-curvature="0" />
    <path
       d="m 137.02897,133.62562 h 24.88795 v -12.18796 h -24.88795 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-8-2-0-58-6-8-7"
       inkscape:connector-curvature="0" />
    <path
       d="m 137.02896,94.509589 h 24.88796 v -12.18795 h -24.88796 z"
       style="fill:#ffca00;fill-opacity:1;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-8-8-5-1-3-0"
       inkscape:connector-curvature="0" />
    <path
       d="m 137.02897,108.22561 h 24.88795 V 96.037639 h -24.88795 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-1-9-4-1-73-1-2-9"
       inkscape:connector-curvature="0" />
    <path
       d="m 137.02896,120.92561 h 24.88796 v -12.18796 h -24.88796 z"
       style="fill:#ffc900;fill-opacity:0.39215687;fill-rule:evenodd;stroke:#ffffff;stroke-width:0.51204854;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="path4891-1-50-8-2-7-5-5-0-3-4-3-3"
       inkscape:connector-curvature="0" />
  </g>
</svg>