title: create R highchart table with sparkline
body: <p>I am trying to use <strong>R</strong> to create a <strong>datatable</strong> with <strong>sparklines</strong> and use it for my shiny dashboard. 
  A simplified test data as following:</p>
  
  <pre><code>#Create lists for test df
  Employee_name &lt;- c('Alice',"Alice", "Alice",  'Brian', "Brian", "Brian","Brian",'Carol', 'Carol', 'Dan', 'Dan','Dan', 'Dan','Dan','Dan', "Lily", "Lily", "Eric", "Eric")
  Product_type &lt;- c('A', "A", "A", "A", "L",'L',"L", "A", "L", "A", "A", "A",'L', "L", "L", "R", "A", "I", "I")
  Project_status &lt;- c("Closed", "Legacy","Active","Closed", "Active", "Dropped", "Closed","Closed","Closed","Closed","Active","Dropped","Active","Closed","Dropped", "Active", "Closed", "Active", "Closed")
  Proj_count_byTypeStatus &lt;- c(2,1,1,4,12,1,4,3,2,10,3,1,3,8,1,8,1, 2,1)
  
  #Test Data Frame
  test_df &lt;- data.frame(Employee_name, Product_type, Project_status, Proj_count_byTypeStatus)
  </code></pre>
  
  <p>How can I make the df into something like this(instead of java, use R codes):<a href="https://www.highcharts.com/demo/sparkline" rel="nofollow noreferrer">https://www.highcharts.com/demo/sparkline</a></p>
  
  <p>More specifically:</p>
  
  <ol>
  <li>Each person takes only one row</li>
  <li>Product_Type is spread to columns  </li>
  <li>Project_Status marked by color "fill"</li>
  </ol>
  
  <p>I used tableau to create my expected chart, hope this would help better understand my question:
  <a href="https://i.stack.imgur.com/QKurd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QKurd.png" alt="enter image description here"></a></p>
  
  <p>Thank you all for any helps!</p>