[R] how to create a sorted barplot and colored by groups

[John Kane]

Hi,
At the moment I cannot make sense of your data. You write "I have three
genes and a type column in the dataframe" but it seems to have 5 columns.
Would you please supply us with the sample data in dput() format?

Here are some suggestions and an example on how to do this plus other
advice on asking a question.  http://adv-r.had.co.nz/Reproducibility.html

What if anything have you tried?

On Sun, 19 Apr 2020 at 18:44, aiguo li via R-help <r-help using r-project.org>
wrote:

> Dear all,
> I need some help for creating a barplot as below.  I have three genes and
> a type column in the dataframe attached.  I would like to sort each gene
> from low to high within each type and create a barplot similar to the one
> below, but colored and grouped by type.
> Thanks in advance for your hep!
> Aiguo
>
>
> |  | types | MYC | MYCL | MYCN |
> | TS603_1 | AnaplasticOligo | 7.97 | 2.98 | 0.48 |
> | TS603_2 | AnaplasticOligo | 9.04 | 3.94 | 0.28 |
> | TS603_3 | AnaplasticOligo | 9.35 | 3.29 | 0.33 |
> | NCH612_1 | AnaplasticOligo | 13.86 | 0.88 | 33.5 |
> | NCH612_2 | AnaplasticOligo | 14.02 | 0.88 | 36.12 |
> | NCH612_3 | AnaplasticOligo | 15.99 | 0.95 | 35.67 |
> | DIPG_XIX_2 | DIPG | 1.12 | 6.18 | 24.37 |
> | DIPG_XIX_1 | DIPG | 1.27 | 6 | 25.63 |
> | DIPG_XIX_3 | DIPG | 1.63 | 7.19 | 26.06 |
> | DIPG_38_3 | DIPG | 3.18 | 14.08 | 8.52 |
> | DIPG_38_1 | DIPG | 3.4 | 14.48 | 10.2 |
> | DIPG_38_2 | DIPG | 5.62 | 12.27 | 12.37 |
> | DIPG_36_1 | DIPG | 6.65 | 0.45 | 4.86 |
> | DIPG_36_3 | DIPG | 7.04 | 0.28 | 4.55 |
> | DIPG_29_1 | DIPG | 7.2 | 2.29 | 9.38 |
> | DIPG_35_1 | DIPG | 7.87 | 1.34 | 8.87 |
> | DIPG_36_2 | DIPG | 8.18 | 0.41 | 3 |
> | DIPG_29_2 | DIPG | 8.85 | 1.53 | 10.97 |
> | DIPG_35_2 | DIPG | 8.99 | 0.74 | 11.52 |
> | DIPG_29_3 | DIPG | 9.66 | 1.03 | 9.46 |
> | DIPG_35_3 | DIPG | 9.73 | 1.35 | 11.92 |
> | DIPG_IV_3 | DIPG | 11.68 | 0.08 | 0 |
> | DIPG_IV_1 | DIPG | 13.63 | 0.29 | 0 |
> | DIPG_IV_2 | DIPG | 15.2 | 0.17 | 0 |
> | DIPG_43_2 | DIPG | 17.77 | 3.72 | 10.33 |
> | DIPG_43_3 | DIPG | 22.04 | 3.02 | 9.52 |
> | DIPG_43_1 | DIPG | 22.87 | 3.42 | 9.24 |
> | DIPG_13_3 | DIPG | 26.36 | 1.3 | 13.89 |
> | DIPG_13_2 | DIPG | 26.44 | 1.4 | 13.88 |
> | DIPG_50_3 | DIPG | 31.92 | 0.62 | 9.55 |
> | DIPG_13_1 | DIPG | 32.57 | 1.41 | 14.78 |
> | DIPG_50_2 | DIPG | 34.13 | 0.98 | 7.74 |
> | DIPG_24_3 | DIPG | 34.22 | 0.75 | 11.73 |
> | DIPG_24_1 | DIPG | 35.75 | 0.46 | 14.92 |
> | DIPG_50_1 | DIPG | 35.78 | 1.03 | 10.75 |
> | DIPG_24_2 | DIPG | 38.48 | 0.78 | 13.08 |
> | DIPG_45_3 | DIPG | 59.56 | 2.34 | 9.1 |
> | DIPG_45_2 | DIPG | 60.23 | 2.79 | 9.32 |
> | DIPG_45_1 | DIPG | 63.19 | 2.59 | 9.7 |
> | DIPG_SCG-1_1 | DIPG | 96.95 | 3.1 | 481.64 |
> | DIPG_SCG-1_3 | DIPG | 106.77 | 3.79 | 481.03 |
> | DIPG_SCG-1_2 | DIPG | 109.77 | 2.88 | 523.27 |
> | DIPG_27_1 | DIPG | 195.07 | 2.23 | 5.92 |
> | DIPG_27_3 | DIPG | 195.45 | 3.09 | 6.71 |
> | DIPG_27_2 | DIPG | 205.33 | 3.28 | 6.26 |
> | DIPGXVII_ONC206_2 | DIPG | 327.55 | 2.07 | 2.21 |
> | DIPGXVII_ONC206_3 | DIPG | 358.3 | 1.8 | 2.55 |
> | DIPGXVII_ONC206_1 | DIPG | 368.93 | 1.97 | 2.28 |
> | DIPG_17_2 | DIPG | 424.17 | 7.35 | 5.18 |
> | DIPG_25_1 | DIPG | 447.28 | 4.47 | 5.84 |
> | DIPG_25_3 | DIPG | 458.31 | 4.98 | 6.18 |
> | DIPG_17_1 | DIPG | 480.19 | 8.66 | 5.95 |
> | DIPG_17_3 | DIPG | 488.79 | 9.64 | 5.16 |
> | DIPG_25_2 | DIPG | 490.16 | 5.23 | 7.56 |
> | DIPGXVII_1_3 | DIPG | 509.04 | 2.33 | 2.97 |
> | DIPGXVII_ONC201_1 | DIPG | 509.05 | 2.51 | 2.58 |
> | DIPGXVII_1_1 | DIPG | 541.42 | 2.79 | 2.91 |
> | DIPGXVII_ONC201_3 | DIPG | 555.35 | 1.96 | 3.19 |
> | DIPGXVII_1_2 | DIPG | 577.68 | 2.19 | 3.01 |
> | DIPGXVII_ONC201_2 | DIPG | 580.61 | 2.38 | 2.8 |
> | DIPGXVII_2_2 | DIPG | 585.22 | 2.34 | 3.36 |
> | DIPGXVII_2_1 | DIPG | 591.72 | 2.62 | 3.01 |
> | DIPGXVII_2_3 | DIPG | 619.18 | 3.04 | 2.35 |
> | GSC627_1 | glioma | 0 | 0.79 | 597.07 |
> | GSC627_2 | glioma | 0 | 1.25 | 615.02 |
> | GSC627_3 | glioma | 0.07 | 1.01 | 632.08 |
> | MGG152_2 | glioma | 0.13 | 13.37 | 916.02 |
> | MGG152_1 | glioma | 0.18 | 12.92 | 895.3 |
> | MGG152_3 | glioma | 0.22 | 14.47 | 935.56 |
> | GBM1_3 | glioma | 4.58 | 6.73 | 291.75 |
> | GBM1_1 | glioma | 4.96 | 6.36 | 276.04 |
> | GBM1_2 | glioma | 5.35 | 7.21 | 280.6 |
> | GSC17_3 | glioma | 7.54 | 3.89 | 59.22 |
> | GSC17_2 | glioma | 8.38 | 3.89 | 60.65 |
> | GSC17_1 | glioma | 9.8 | 4.77 | 57.33 |
> | GBM164_3 | glioma | 11.14 | 1.42 | 7.04 |
> | GBM164_1 | glioma | 11.89 | 1.53 | 6.04 |
> | GBM164_2 | glioma | 12.69 | 1.85 | 6.8 |
> | GSC923_3 | glioma | 14.93 | 6.59 | 216.57 |
> | GSC923_2 | glioma | 15.63 | 5.75 | 226.94 |
> | GSC923_1 | glioma | 16.93 | 5.75 | 207.18 |
> | GSC268_3 | glioma | 16.94 | 0.14 | 7.14 |
> | GSC268_1 | glioma | 17.8 | 0.01 | 8.25 |
> | GSC268_2 | glioma | 19.97 | 0.11 | 6.24 |
> | SF10602_3 | glioma | 23.81 | 2.39 | 0.47 |
> | SF10602_1 | glioma | 25.38 | 2.72 | 0.43 |
> | MGG119_1 | glioma | 25.49 | 6.84 | 9.8 |
> | SF10602_2 | glioma | 25.61 | 2.5 | 0.55 |
> | GSC827_2 | glioma | 27.67 | 2.32 | 128.56 |
> | GSC827_3 | glioma | 28.2 | 3.22 | 128.85 |
> | GSC827_1 | glioma | 30.6 | 3.15 | 126.77 |
> | MGG119_2 | glioma | 31.43 | 5.86 | 9.02 |
> | BT054_3 | glioma | 35.26 | 0.46 | 2.89 |
> | MGG119_3 | glioma | 35.57 | 6.52 | 9.42 |
> | BT054_2 | glioma | 39.74 | 0.53 | 3.29 |
> | BT054_1 | glioma | 42.22 | 0.28 | 3.54 |
> | SF10417_1 | glioma | 43.93 | 2.93 | 0.21 |
> | SF10417_2 | glioma | 44.77 | 2.43 | 0.32 |
> | GBM196_1 | glioma | 47.28 | 0.33 | 1.75 |
> | GBM196_2 | glioma | 48.85 | 0.34 | 1.9 |
> | SF10417_3 | glioma | 48.88 | 2.81 | 0.27 |
> | GBM196_3 | glioma | 50.5 | 0.4 | 2.25 |
> | BT088_1 | glioma | 65.83 | 4.3 | 12.17 |
> | BT088_2 | glioma | 66.96 | 4.13 | 10.33 |
> | TB096_1 | glioma | 71.38 | 5.55 | 0 |
> | TB096_3 | glioma | 74.87 | 4.55 | 0.03 |
> | TB096_2 | glioma | 80.34 | 4.37 | 0 |
> | BT088_3 | glioma | 93.29 | 4.1 | 12.14 |
> | GSC274_2 | glioma | 134.37 | 0.28 | 0.03 |
> | GSC274_1 | glioma | 135.93 | 0.38 | 0.04 |
> | GSC274_3 | glioma | 169.64 | 0.27 | 0.06 |
> | GSC711_1 | glioma | 192.15 | 1.95 | 155.15 |
> | GSC711_2 | glioma | 192.85 | 2.11 | 141.35 |
> | GSC711_3 | glioma | 198.1 | 2.1 | 154.15 |
> | XO1_1 | GSC | 0.22 | 0.35 | 661.86 |
> | XO6_2 | GSC | 0.23 | 0.06 | 539.81 |
> | XO1_3 | GSC | 0.31 | 0.32 | 709.18 |
> | XO9_3 | GSC | 0.34 | 0.17 | 999.27 |
> | XO6_1 | GSC | 0.37 | 0.09 | 523.3 |
> | XO1_2 | GSC | 0.41 | 0.03 | 683.86 |
> | XO9_2 | GSC | 0.48 | 0.15 | 992.87 |
> | XO6_3 | GSC | 0.52 | 0.15 | 531.36 |
> | XO9_1 | GSC | 0.67 | 0.32 | 919.95 |
> | XO10_1 | GSC | 5 | 0.08 | 409.65 |
> | XO10_3 | GSC | 5.49 | 0.11 | 335.44 |
> | XO10_2 | GSC | 6.06 | 0.03 | 369.5 |
> | L0_1 | GSC | 16.48 | 3.35 | 0.4 |
> | L1_2 | GSC | 17.38 | 3.36 | 0.93 |
> | L0_3 | GSC | 17.54 | 3.59 | 0.49 |
> | L0_2 | GSC | 19.1 | 4.11 | 0.6 |
> | L1_1 | GSC | 21.54 | 3.82 | 1 |
> | L1_3 | GSC | 22.71 | 3.57 | 0.9 |
> | GSC403_3 | GSC | 37.44 | 4.86 | 17.64 |
> | GSC403_2 | GSC | 38.07 | 5.59 | 18.46 |
> | GSC403_1 | GSC | 38.83 | 5.11 | 16.2 |
> | XO2_2 | GSC | 78.66 | 0.01 | 0.88 |
> | XO2_1 | GSC | 80.11 | 0.03 | 0.93 |
> | XO2_3 | GSC | 90.97 | 0 | 1.01 |
> | CA4_1_1 | GSC | 153.82 | 0.05 | 0 |
> | CA4_1_3 | GSC | 155.24 | 0.13 | 0 |
> | CA4_2_1 | GSC | 161 | 0 | 0.04 |
> | CA4_1_2 | GSC | 162.61 | 0.08 | 0 |
> | CA4_2_2 | GSC | 164.36 | 0.08 | 0 |
> | CA4_2_3 | GSC | 175.21 | 0.11 | 0 |
> | CA4_ONC201_2 | GSC | 196.03 | 0.21 | 0 |
> | CA4_ONC201_3 | GSC | 208.01 | 0.15 | 0 |
> | CA4_ONC201_1 | GSC | 217.87 | 0.03 | 0 |
> | CA1_3 | GSC | 240.43 | 0.09 | 0 |
> | CA1_1 | GSC | 253.36 | 0.18 | 0 |
> | CA4_2 | GSC | 260.43 | 0.05 | 0 |
> | CA4_ONC206_2 | GSC | 261.34 | 0.35 | 0.06 |
> | CA4_3 | GSC | 266.39 | 0.07 | 0.06 |
> | CA1_2 | GSC | 266.96 | 0.07 | 0.02 |
> | CA4_1 | GSC | 273.27 | 0.11 | 0.04 |
> | CA4_ONC206_1 | GSC | 279.86 | 0.36 | 0 |
> | CA4_ONC206_3 | GSC | 281.32 | 0.37 | 0 |
> | HW8_2 | HW | 15.39 | 7.56 | 23.16 |
> | HW7_2_2 | HW | 17.31 | 6.38 | 23.78 |
> | HW8_1 | HW | 18.19 | 7.38 | 20.54 |
> | HW8_3 | HW | 19.71 | 7.42 | 23.85 |
> | HW8_R132_1 | HW | 20.08 | 6.23 | 27 |
> | HW5_1 | HW | 22.64 | 7.42 | 41.08 |
> | HW7_1_2 | HW | 22.81 | 7.5 | 34.93 |
> | HW7_2_3 | HW | 22.87 | 7.72 | 22.19 |
> | HW7_1_1 | HW | 23.98 | 7.26 | 26.06 |
> | HW5_3 | HW | 24.64 | 7.06 | 36.65 |
> | HW8_R132_2 | HW | 24.77 | 6.09 | 25.01 |
> | HW5_2 | HW | 25.16 | 7.47 | 39.44 |
> | HW8_R132_3 | HW | 26.31 | 5.81 | 21.03 |
> | HW7_1_3 | HW | 27.04 | 9.31 | 32.27 |
> | HW7_2_1 | HW | 30.47 | 7.58 | 31.84 |
> | HW10_1 | HW | 35.38 | 9.74 | 32.4 |
> | HW10_3 | HW | 37.45 | 9.59 | 42.56 |
> | HW10_2 | HW | 39.95 | 9.58 | 37 |
> | HW10_R132H_2 | HW | 47.78 | 9.33 | 35.61 |
> | HW10_R132H_3 | HW | 55.78 | 10.55 | 30.24 |
> | HW10_R132H_1 | HW | 62.03 | 9.29 | 28.2 |
> | LN229_2 | MCL | 5.09 | 0.56 | 22.21 |
> | LN229_3 | MCL | 5.41 | 0.96 | 20.27 |
> | LN229_1 | MCL | 6.3 | 0.67 | 24.38 |
> | SW1088_2 | MCL | 11.59 | 0.14 | 0 |
> | SW1088_3 | MCL | 15.17 | 0.37 | 0 |
> | SW1088_1 | MCL | 18 | 0.11 | 0 |
> | U251_3 | MCL | 19.74 | 0.45 | 0 |
> | U251_1 | MCL | 21.4 | 0.31 | 0 |
> | U251_2 | MCL | 23.51 | 0.45 | 0 |
> | A172_2 | MCL | 41.43 | 0.72 | 0.03 |
> | BT142_2 | MCL | 45.43 | 2.39 | 9.77 |
> | BT142_1 | MCL | 45.95 | 2.02 | 8.23 |
> | BT142_3 | MCL | 48.88 | 1.71 | 10.31 |
> | A172_1 | MCL | 49.68 | 0.81 | 0.02 |
> | A172_3 | MCL | 49.98 | 0.59 | 0 |
> | NHA_R132H_1 | Normal astrocyte | 43.67 | 0.19 | 0 |
> | NHA_3 | Normal astrocyte | 58.47 | 0.04 | 0 |
> | NHA_R132H_2 | Normal astrocyte | 58.48 | 0.12 | 0 |
> | NHA_1 | Normal astrocyte | 58.58 | 0.13 | 0 |
> | NHA_2 | Normal astrocyte | 59.03 | 0.06 | 0 |
> | NHA_R132H_3 | Normal astrocyte | 63.43 | 0.15 | 0 |
>
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>


-- 
John Kane
Kingston ON Canada

	[[alternative HTML version deleted]]