Advertisement
Guest User

Untitled

a guest
Feb 26th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.62 KB | None | 0 0
  1. install.packages("tidyverse")
  2. library(tidyverse)
  3. mmr <- readxl::read_excel("Maternal Mortality Ratio.xlsx", sheet = 1, col_names = TRUE, col_types = NULL)
  4.  
  5. ggplot() +
  6. geom_histogram(data = subset(mmr, !is.na(2011.0)),
  7. aes(x = "2011.0"))
  8.  
  9. Error: StatBin requires a continuous x variable the x variable is discrete. Perhaps you want stat="count"?
  10.  
  11. > mmr
  12. # A tibble: 999 × 215
  13. `Maternal Mortality rate per 100 000` `1800.0` `1801.0` `1802.0` `1803.0` `1804.0` `1805.0` `1806.0` `1807.0`
  14. <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
  15. 1 Abkhazia NA NA NA NA NA NA NA NA
  16. 2 Afghanistan NA NA NA NA NA NA NA NA
  17. 3 Akrotiri and Dhekelia NA NA NA NA NA NA NA NA
  18. 4 Albania NA NA NA NA NA NA NA NA
  19. 5 Algeria NA NA NA NA NA NA NA NA
  20. 6 American Samoa NA NA NA NA NA NA NA NA
  21. 7 Andorra NA NA NA NA NA NA NA NA
  22. 8 Angola NA NA NA NA NA NA NA NA
  23. 9 Anguilla NA NA NA NA NA NA NA NA
  24. 10 Antigua and Barbuda NA NA NA NA NA NA NA NA
  25. # ... with 989 more rows, and 206 more variables: `1808.0` <dbl>, `1809.0` <dbl>, `1810.0` <dbl>, `1811.0` <dbl>,
  26. # `1812.0` <dbl>, `1813.0` <dbl>, `1814.0` <dbl>, `1815.0` <dbl>, `1816.0` <dbl>, `1817.0` <dbl>, `1818.0` <dbl>,
  27. # `1819.0` <dbl>, `1820.0` <dbl>, `1821.0` <dbl>, `1822.0` <dbl>, `1823.0` <dbl>, `1824.0` <dbl>, `1825.0` <dbl>,
  28. # `1826.0` <dbl>, `1827.0` <dbl>, `1828.0` <dbl>, `1829.0` <dbl>, `1830.0` <dbl>, `1831.0` <dbl>, `1832.0` <dbl>,
  29. # `1833.0` <dbl>, `1834.0` <dbl>, `1835.0` <dbl>, `1836.0` <dbl>, `1837.0` <dbl>, `1838.0` <dbl>, `1839.0` <dbl>,
  30. # `1840.0` <dbl>, `1841.0` <dbl>, `1842.0` <dbl>, `1843.0` <dbl>, `1844.0` <dbl>, `1845.0` <dbl>, `1846.0` <dbl>,
  31. # `1847.0` <dbl>, `1848.0` <dbl>, `1849.0` <dbl>, `1850.0` <dbl>, `1851.0` <dbl>, `1852.0` <dbl>, `1853.0` <dbl>,
  32. # `1854.0` <dbl>, `1855.0` <dbl>, `1856.0` <dbl>, `1857.0` <dbl>, `1858.0` <dbl>, `1859.0` <dbl>, `1860.0` <dbl>,
  33. # `1861.0` <dbl>, `1862.0` <dbl>, `1863.0` <dbl>, `1864.0` <dbl>, `1865.0` <dbl>, `1866.0` <dbl>, `1867.0` <dbl>,
  34. # `1868.0` <dbl>, `1869.0` <dbl>, `1870.0` <dbl>, `1871.0` <dbl>, `1872.0` <dbl>, `1873.0` <dbl>, `1874.0` <dbl>,
  35. # `1875.0` <dbl>, `1876.0` <dbl>, `1877.0` <dbl>, `1878.0` <dbl>, `1879.0` <dbl>, `1880.0` <dbl>, `1881.0` <dbl>,
  36. # `1882.0` <dbl>, `1883.0` <dbl>, `1884.0` <dbl>, `1885.0` <dbl>, `1886.0` <dbl>, `1887.0` <dbl>, `1888.0` <dbl>,
  37. # `1889.0` <dbl>, `1890.0` <dbl>, `1891.0` <dbl>, `1892.0` <dbl>, `1893.0` <dbl>, `1894.0` <dbl>, `1895.0` <dbl>,
  38. # `1896.0` <dbl>, `1897.0` <dbl>, `1898.0` <dbl>, `1899.0` <dbl>, `1900.0` <dbl>, `1901.0` <dbl>, `1902.0` <dbl>,
  39. # `1903.0` <dbl>, `1904.0` <dbl>, `1905.0` <dbl>, `1906.0` <dbl>, `1907.0` <dbl>, ...
  40.  
  41. > str(mmr)
  42. Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 999 obs. of 215 variables:
  43. $ Maternal Mortality rate per 100 000: chr "Abkhazia" "Afghanistan" "Akrotiri and Dhekelia" "Albania" ...
  44. $ 1800.0 : num NA NA NA NA NA NA NA NA NA NA ...
  45. $ 1801.0 : num NA NA NA NA NA NA NA NA NA NA ...
  46.  
  47. > typeof(mmr)
  48. [1] "list"
  49. > typeof(mmr$"2011.0")
  50. [1] "double"
  51. > is.double(mmr$"2011.0")
  52. [1] TRUE
  53. > is.numeric(mmr$"2011.0")
  54. [1] TRUE
  55. > is.character(mmr$"2011.0")
  56. [1] FALSE
  57. > is.character(mmr$"Maternal Mortality rate per 100 000")
  58. [1] TRUE
  59. > class(mmr$"2011.0")
  60. [1] "numeric"
  61. > class(mmr$"Maternal Mortality rate per 100 000")
  62. [1] "character"
  63.  
  64. mmr[,'2011.0'] <- as.numeric(mmr[,'2011.0'])
  65.  
  66. mmr[,'2011.0'] <- as.numeric(as.character((mmr[,'2011.0']))
  67.  
  68. ggplot() +
  69. geom_histogram(data = subset(mmr, !is.na(2011.0)),
  70. aes(x = "2011.0"))
  71. Error: StatBin requires a continuous x variable the x variable is discrete. Perhaps you want stat="count"?
  72.  
  73. mmr <- readxl::read_excel("Maternal Mortality Ratio.xlsx", sheet = 1, col_names = TRUE, col_types = numeric)
  74.  
  75. Error in read_xlsx_(path, sheet, col_names = col_names, col_types = col_types, : `col_types` must be a character vector or NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement