title: Easier way to draw a bar chart using highcharts?
body: <p>I started to try to use Highcharts.</p>
  
  <p>It seems that in order to draw a bar chart, I need to fill up these two properties like this:</p>
  
  <pre><code>       xAxis: {
              categories: [
                  'Jan',
                  'Feb',
                  'Mar',
                  'Apr',
                  'May',
                  'Jun',
                  'Jul',
                  'Aug',
                  'Sep',
                  'Oct',
                  'Nov',
                  'Dec'
              ],
              crosshair: true
          },
          series: [{
              name: 'Tokyo',
              data: [49.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4]
          }, {
              name: 'New York',
              data: [83.6, 78.8, 98.5, 93.4, 106.0, 84.5, 105.0, 104.3, 91.2, 83.5, 106.6, 92.3]
  
          }, {
              name: 'London',
              data: [48.9, 38.8, 39.3, 41.4, 47.0, 48.3, 59.0, 59.6, 52.4, 65.2, 59.3, 51.2]
          }, {
              name: 'Berlin',
              data: [42.4, 33.2, 34.5, 39.7, 52.6, 75.5, 57.4, 60.4, 47.6, 39.1, 46.8, 51.1]
          }
  </code></pre>
  
  <hr>
  
  <p>Now I have the following table:</p>
  
  <pre><code>╔════╦════════╦════════╗
  ║ ID ║ State  ║ Number ║
  ╠════╬════════╬════════╣
  ║ A  ║ S1     ║      7 ║
  ║ B  ║ S1     ║      6 ║
  ║ B  ║ S2     ║      5 ║
  ║ C  ║ S3     ║      4 ║
  ║ C  ║ S1     ║      3 ║
  ╚════╩════════╩════════╝
  </code></pre>
  
  <p>The bar chart I want is </p>
  
  <ol>
  <li>X is for the <code>ID</code></li>
  <li>For each <code>ID</code>, I want to plot the number for Each possible <code>State</code>.</li>
  </ol>
  
  <p>So it seems I need the following properties for Highcharts:</p>
  
  <pre><code>       xAxis: {
              categories: [
                  'A',
                  'B',
                  'C'
              ],
              crosshair: true
          },
          series: [{
              name: 'S1',
              data: [7, 6, 3]
          }, {
              name: 'S2',
              data: [0, 5, 0]    
          }, {
              name: 'S3',
              data: [0, 0, 4]
          }
          }
  </code></pre>
  
  <p><strong>Is it correct?</strong></p>
  
  <hr>
  
  <p>So it seems I need to carefully convert my original table (in real life it can be bigger and more IDs and States) to the properties, and fill <code>0</code> to the <code>ID</code>s who do not have the <code>Number</code> for certain <code>State</code>s. For example, I may have to use dictionary of dictionary to store the converted table.</p>
  
  <p>Is there an easy way to achieve that?</p>