Databases
StackOverflow2013
Postsdbo
POHow transform list to plotable dataframe in R?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow transform list to plotable dataframe in R?
    primarykey
    data
    text
    <p>I have those 2 lists :</p> <pre><code>&gt; FHM_CS $X3 [1] 100 $X5 [1] 100 $X7 [1] 54.23706 63.48137 51.04026 60.14302 70.39396 56.59812 75.41480 88.26871 70.96976 54.20140 63.43252 [12] 51.00868 60.10348 70.33980 56.56310 75.36522 88.20079 70.92585 $X9 [1] 38.63259 27.74551 21.17788 100.00000 73.08030 55.78148 85.86148 38.56665 27.71148 21.15804 11] 72.99067 55.72924 85.78107 $XAS [1] 0 $XPW [1] 49.07016 40.02288 23.87023 100.00000 89.30224 53.26115 69.98929 0.00000 </code></pre> <p>and </p> <pre><code>&gt; FHM_CD $X3 [1] 14.8840750 17.7316138 6.1164435 0.0000000 1.1435141 14.8904265 17.7375474 6.1241709 1.1506441 [10] 14.6751282 17.5364297 5.8621689 0.9089743 $X5 [1] 74.41660 76.74417 80.95828 58.58119 62.34946 69.17199 57.25100 61.14029 68.18193 74.38872 76.72114 [12] 80.94284 58.53606 62.31217 69.14699 57.20442 61.10180 68.15613 74.34258 76.68302 80.91730 58.46136 [23] 62.25047 69.10565 57.12732 61.03811 68.11346 $X7 [1] 66.30768 60.56507 68.29355 49.37678 40.74842 52.36058 36.42026 25.58356 40.16773 66.32983 60.59541 [12] 68.31317 49.41006 40.79401 52.39005 36.46206 25.64082 40.20475 $X9 [1] 66.14771 75.68765 81.44262 55.01738 67.69397 75.34112 51.61251 65.24862 73.47461 66.20550 75.71747 [12] 81.46000 55.09417 67.73359 75.36421 51.69510 65.29125 73.49945 $XAS [1] 25.62701 45.29201 44.51013 0.00000 17.99168 16.81963 $XPW [1] 7.344758 24.428011 54.927770 0.000000 4.637824 43.124615 39.752560 100.000000 </code></pre> <p>And I would like to do a "clustured jittered plot" for every line from both list. For example : X3 from FHM_CS right by X3 from FHM_CD and so one for every row of the lists.</p> <p>I was thinking of using qplot from ggplot2 with geom="jitter", but I would also like to add an horizontal bar for each bar space to show the mean every list.</p> <p>It would be something like this except I would like to add the mean for every list as a horizontal red bar (with its value if possible) and the clustering part (like FHM_CS in blue and FHM_CD in red).</p> <p><img src="https://s17.postimg.org/wah2ky7nz/jitter.png" alt="jitterplot"></p> <p>So how to convert those list to dataframe and how to plot this from there ?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USWicelo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload