I want to create density graphs like this in R using ggplot with data.-
Data is like this:
Year Month Crop Incidence
2015 Jan Maize 6.00
2015 Feb Maize 10.00
2015 March Maize 5.00
2015 May Maize 5.00
2015 June Maize 7.00
2015 July Maize 8.00
2015 Aug Maize 15.00
2015 Sep Maize 11.00
2015 Oct Maize 14.00
2015 Nov Maize 7.00
2015 Dec Maize 6.00
2016 Jan Maize 8.00
2016 Feb Maize 10.00
2016 March Maize 11.00
2016 May Maize 5.00
2016 June Maize 7.00
2016 July Maize 9.00
2016 Aug Maize 12.00
2016 Sep Maize 12.00
2016 Oct Maize 13.00
2016 Nov Maize 7.00
2016 Dec Maize 6.00
2017 Jan Maize 5.00
2017 Feb Maize 8.00
2017 March Maize 12.00
2017 May Maize 3.00
2017 June Maize 7.00
2017 July Maize 8.00
2017 Aug Maize 9.00
2017 Sep Maize 11.00
2017 Oct Maize 14.00
2017 Nov Maize 9.00
2017 Dec Maize 7.00
2018 Jan Maize 7.00
2018 Feb Maize 11.00
2018 March Maize 13.00
2018 May Maize 2.00
2018 June Maize 7.00
2018 July Maize 8.00
2018 Aug Maize 15.00
2018 Sep Maize 10.00
2018 Oct Maize 12.00
2018 Nov Maize 8.00
2018 Dec Maize 6.00
2019 Jan Maize 8.00
2019 Feb Maize 8.00
2019 March Maize 13.00
2019 May Maize 4.00
2019 June Maize 9.00
2019 July Maize 10.00
2019 Aug Maize 11.00
2019 Sep Maize 10.00
2019 Oct Maize 14.00
2019 Nov Maize 7.00
2019 Dec Maize 7.00
2015 Jan Sorghum 7.00
2015 Feb Sorghum 8.00
2015 March Sorghum 13.00
2015 May Sorghum 3.00
2015 June Sorghum 7.00
2015 July Sorghum 8.00
2015 Aug Sorghum 14.00
2015 Sep Sorghum 12.00
2015 Oct Sorghum 13.00
2015 Nov Sorghum 9.00
2015 Dec Sorghum 7.00
2016 Jan Sorghum 7.00
2016 Feb Sorghum 11.00
2016 March Sorghum 12.00
2016 May Sorghum 4.00
2016 June Sorghum 8.00
2016 July Sorghum 8.00
2016 Aug Sorghum 11.00
2016 Sep Sorghum 12.00
2016 Oct Sorghum 13.00
2016 Nov Sorghum 8.00
2016 Dec Sorghum 7.00
2017 Jan Sorghum 7.00
2017 Feb Sorghum 8.00
2017 March Sorghum 12.00
2017 May Sorghum 2.00
2017 June Sorghum 7.00
2017 July Sorghum 9.00
2017 Aug Sorghum 11.00
2017 Sep Sorghum 12.00
2017 Oct Sorghum 14.00
2017 Nov Sorghum 9.00
2017 Dec Sorghum 6.00
2018 Jan Sorghum 7.00
2018 Feb Sorghum 7.00
2018 March Sorghum 11.00
2018 May Sorghum 3.00
2018 June Sorghum 7.00
2018 July Sorghum 9.00
2018 Aug Sorghum 10.00
2018 Sep Sorghum 10.00
2018 Oct Sorghum 12.00
2018 Nov Sorghum 7.00
2018 Dec Sorghum 7.00
2019 Jan Sorghum 5.00
2019 Feb Sorghum 8.00
2019 March Sorghum 13.00
2019 May Sorghum 5.00
2019 June Sorghum 7.00
2019 July Sorghum 9.00
2019 Aug Sorghum 15.00
2019 Sep Sorghum 10.00
2019 Oct Sorghum 12.00
2019 Nov Sorghum 8.00
2019 Dec Sorghum 7.00
2015 Jan Pearl millet 7.00
2015 Feb Pearl millet 8.00
2015 March Pearl millet 12.00
2015 May Pearl millet 4.00
2015 June Pearl millet 9.00
2015 July Pearl millet 10.00
2015 Aug Pearl millet 13.00
2015 Sep Pearl millet 10.00
2015 Oct Pearl millet 14.00
2015 Nov Pearl millet 7.00
2015 Dec Pearl millet 6.00
2016 Jan Pearl millet 8.00
2016 Feb Pearl millet 8.00
2016 March Pearl millet 12.00
2016 May Pearl millet 2.00
2016 June Pearl millet 8.00
2016 July Pearl millet 10.00
2016 Aug Pearl millet 13.00
2016 Sep Pearl millet 11.00
2016 Oct Pearl millet 14.00
2016 Nov Pearl millet 8.00
2016 Dec Pearl millet 7.00
2017 Jan Pearl millet 5.00
2017 Feb Pearl millet 11.00
2017 March Pearl millet 13.00
2017 May Pearl millet 3.00
2017 June Pearl millet 9.00
2017 July Pearl millet 10.00
2017 Aug Pearl millet 10.00
2017 Sep Pearl millet 10.00
2017 Oct Pearl millet 13.00
2017 Nov Pearl millet 8.00
2017 Dec Pearl millet 6.00
2018 Jan Pearl millet 8.00
2018 Feb Pearl millet 11.00
2018 March Pearl millet 13.00
2018 May Pearl millet 5.00
2018 June Pearl millet 7.00
2018 July Pearl millet 9.00
2018 Aug Pearl millet 11.00
2018 Sep Pearl millet 11.00
2018 Oct Pearl millet 14.00
2018 Nov Pearl millet 9.00
2018 Dec Pearl millet 6.00
2019 Jan Pearl millet 7.00
2019 Feb Pearl millet 11.00
2019 March Pearl millet 12.00
2019 May Pearl millet 5.00
2019 June Pearl millet 7.00
2019 July Pearl millet 9.00
2019 Aug Pearl millet 14.00
2019 Sep Pearl millet 11.00
2019 Oct Pearl millet 14.00
2019 Nov Pearl millet 7.00
2019 Dec Pearl millet 7.00
2015 Jan Finger Millet 5.00
2015 Feb Finger Millet 11.00
2015 March Finger Millet 12.00
2015 May Finger Millet 5.00
2015 June Finger Millet 7.00
2015 July Finger Millet 9.00
2015 Aug Finger Millet 12.00
2015 Sep Finger Millet 10.00
2015 Oct Finger Millet 12.00
2015 Nov Finger Millet 8.00
2015 Dec Finger Millet 6.00
2016 Jan Finger Millet 5.00
2016 Feb Finger Millet 8.00
2016 March Finger Millet 12.00
2016 May Finger Millet 4.00
2016 June Finger Millet 9.00
2016 July Finger Millet 9.00
2016 Aug Finger Millet 12.00
2016 Sep Finger Millet 10.00
2016 Oct Finger Millet 14.00
2016 Nov Finger Millet 7.00
2016 Dec Finger Millet 7.00
2017 Jan Finger Millet 6.00
2017 Feb Finger Millet 7.00
2017 March Finger Millet 11.00
2017 May Finger Millet 2.00
2017 June Finger Millet 7.00
2017 July Finger Millet 10.00
2017 Aug Finger Millet 11.00
2017 Sep Finger Millet 12.00
2017 Oct Finger Millet 14.00
2017 Nov Finger Millet 8.00
2017 Dec Finger Millet 7.00
2018 Jan Finger Millet 8.00
2018 Feb Finger Millet 10.00
2018 March Finger Millet 12.00
2018 May Finger Millet 4.00
2018 June Finger Millet 7.00
2018 July Finger Millet 10.00
2018 Aug Finger Millet 10.00
2018 Sep Finger Millet 12.00
2018 Oct Finger Millet 12.00
2018 Nov Finger Millet 9.00
2018 Dec Finger Millet 7.00
2019 Jan Finger Millet 6.00
2019 Feb Finger Millet 7.00
2019 March Finger Millet 13.00
2019 May Finger Millet 4.00
2019 June Finger Millet 9.00
2019 July Finger Millet 9.00
2019 Aug Finger Millet 15.00
2019 Sep Finger Millet 12.00
2019 Oct Finger Millet 13.00
2019 Nov Finger Millet 9.00
2019 Dec Finger Millet 6.00
I am unable to mark the x-axis with Months and Y-axis with Incidence. Instead, I am getting density on the y-axis and intervals on x-axis. Is it possible to draw graphs like that with the above data?
P.S: Please forgive me. I just copy-pasted data from excel. Unable to vectorize it.