Data Squirrel

Load data :

squirrels_url <- paste0("https://raw.githubusercontent.com/rfordatascience/tidytuesday/", "master/data/2019/2019-10-29/nyc_squirrels.csv")
squirrels <- read.csv(squirrels_url)
dim(squirrels)
## [1] 3023   36
#mohon maaf bu untuk package tidyverse nya tidak bisa ke update bu, ada bug di software R nya
library(tidyverse)
## Warning: package 'tidyverse' was built under R version 4.4.3
## Warning: package 'ggplot2' was built under R version 4.4.3
## Warning: package 'tibble' was built under R version 4.4.3
## Warning: package 'tidyr' was built under R version 4.4.3
## Warning: package 'readr' was built under R version 4.4.3
## Warning: package 'purrr' was built under R version 4.4.3
## Warning: package 'dplyr' was built under R version 4.4.3
## Warning: package 'stringr' was built under R version 4.4.3
## Warning: package 'forcats' was built under R version 4.4.3
## Warning: package 'lubridate' was built under R version 4.4.3
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.4     ✔ readr     2.1.5
## ✔ forcats   1.0.0     ✔ stringr   1.5.1
## ✔ ggplot2   3.5.1     ✔ tibble    3.2.1
## ✔ lubridate 1.9.4     ✔ tidyr     1.3.1
## ✔ purrr     1.0.4     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
squirrels%>%
  select(lat_long,
         primary_fur_color,
         location) %>%
  filter(primary_fur_color == "Cinnamon") %>%
  drop_na(location)
##                                         lat_long primary_fur_color     location
## 1    POINT (-73.9768311751004 40.76671780725581)          Cinnamon Above Ground
## 2     POINT (-73.9768603630674 40.7702795904962)          Cinnamon Ground Plane
## 3     POINT (-73.9649866016038 40.7764929694457)          Cinnamon Ground Plane
## 4    POINT (-73.9670628558161 40.77349914209411)          Cinnamon Ground Plane
## 5     POINT (-73.9662438996681 40.7890381809441)          Cinnamon Ground Plane
## 6     POINT (-73.9745630038492 40.7692602628745)          Cinnamon Ground Plane
## 7      POINT (-73.968381325559 40.7780143443779)          Cinnamon Ground Plane
## 8     POINT (-73.9610705592868 40.7914829661051)          Cinnamon Ground Plane
## 9     POINT (-73.9617088749928 40.7944585082367)          Cinnamon Ground Plane
## 10   POINT (-73.9541453465817 40.79821622237641)          Cinnamon Ground Plane
## 11    POINT (-73.9683608295976 40.7842927405327)          Cinnamon Ground Plane
## 12    POINT (-73.9511118711108 40.7950813345902)          Cinnamon Ground Plane
## 13    POINT (-73.9651601541795 40.7761841788025)          Cinnamon Ground Plane
## 14   POINT (-73.97686527856641 40.7684838168207)          Cinnamon Ground Plane
## 15    POINT (-73.9763430829342 40.7686351097159)          Cinnamon Above Ground
## 16    POINT (-73.9714789136757 40.7694886645194)          Cinnamon Ground Plane
## 17     POINT (-73.969058856545 40.7766356226979)          Cinnamon Ground Plane
## 18     POINT (-73.963846339804 40.7834051716226)          Cinnamon Above Ground
## 19    POINT (-73.9570528770427 40.7990973804149)          Cinnamon Above Ground
## 20    POINT (-73.9764839973068 40.7691725326976)          Cinnamon Ground Plane
## 21    POINT (-73.9771614686616 40.7709677983247)          Cinnamon Above Ground
## 22    POINT (-73.9679538163341 40.7837103696906)          Cinnamon Ground Plane
## 23    POINT (-73.9772576561244 40.7679895093963)          Cinnamon Ground Plane
## 24    POINT (-73.9712327308512 40.7748702909218)          Cinnamon Ground Plane
## 25    POINT (-73.9520592496349 40.7975076299811)          Cinnamon Above Ground
## 26    POINT (-73.9568343093228 40.7949401350882)          Cinnamon Ground Plane
## 27   POINT (-73.97331176635412 40.7694584620114)          Cinnamon Ground Plane
## 28    POINT (-73.9786339295735 40.7684918638639)          Cinnamon Ground Plane
## 29     POINT (-73.9762246600197 40.775164077652)          Cinnamon Ground Plane
## 30    POINT (-73.9800669115792 40.7676825134384)          Cinnamon Above Ground
## 31   POINT (-73.97679812430802 40.7741316574113)          Cinnamon Above Ground
## 32   POINT (-73.9773317054464 40.76840359967581)          Cinnamon Ground Plane
## 33     POINT (-73.9552861155228 40.788973931872)          Cinnamon Above Ground
## 34    POINT (-73.9771069181511 40.7670538214988)          Cinnamon Ground Plane
## 35    POINT (-73.9754742295091 40.7696998327247)          Cinnamon Ground Plane
## 36     POINT (-73.968107276769 40.7768612676036)          Cinnamon Above Ground
## 37    POINT (-73.9560679864426 40.7947887062326)          Cinnamon Ground Plane
## 38     POINT (-73.957342596188 40.7944359654227)          Cinnamon Ground Plane
## 39   POINT (-73.97623482246482 40.7694522315322)          Cinnamon Ground Plane
## 40    POINT (-73.9750283794865 40.7724101927821)          Cinnamon Ground Plane
## 41   POINT (-73.9659034359706 40.77975166888441)          Cinnamon Above Ground
## 42    POINT (-73.9684376038582 40.7824275067237)          Cinnamon Ground Plane
## 43    POINT (-73.9689657039917 40.7767834276767)          Cinnamon Ground Plane
## 44   POINT (-73.9635658786416 40.77772917779011)          Cinnamon Ground Plane
## 45    POINT (-73.9752000129992 40.7732918122239)          Cinnamon Ground Plane
## 46    POINT (-73.9698817079185 40.7758322627711)          Cinnamon Ground Plane
## 47     POINT (-73.9757001944781 40.769499790547)          Cinnamon Above Ground
## 48     POINT (-73.968045072743 40.7836626717225)          Cinnamon Above Ground
## 49    POINT (-73.9802376131034 40.7680707516627)          Cinnamon Ground Plane
## 50    POINT (-73.9690416961886 40.7716618670996)          Cinnamon Ground Plane
## 51    POINT (-73.9763433202401 40.7738473490681)          Cinnamon Above Ground
## 52    POINT (-73.9786603147149 40.7671937837017)          Cinnamon Ground Plane
## 53    POINT (-73.9785675798034 40.7672992405289)          Cinnamon Ground Plane
## 54    POINT (-73.9756754297747 40.7738518843446)          Cinnamon Ground Plane
## 55     POINT (-73.9756557086441 40.773296289824)          Cinnamon Ground Plane
## 56    POINT (-73.9757787135906 40.7737231427345)          Cinnamon Ground Plane
## 57    POINT (-73.9752793195744 40.7733960128931)          Cinnamon Ground Plane
## 58    POINT (-73.9648195433192 40.7796399955868)          Cinnamon Ground Plane
## 59    POINT (-73.9664450399121 40.7887844904695)          Cinnamon Ground Plane
## 60    POINT (-73.95812430217221 40.794431473386)          Cinnamon Ground Plane
## 61    POINT (-73.9701481200298 40.7751110354034)          Cinnamon Ground Plane
## 62   POINT (-73.9677423154682 40.77288133502451)          Cinnamon Ground Plane
## 63      POINT (-73.978426472499 40.771904101844)          Cinnamon Ground Plane
## 64    POINT (-73.9776854797916 40.7683102295663)          Cinnamon Ground Plane
## 65    POINT (-73.9801007327506 40.7677455633932)          Cinnamon Ground Plane
## 66    POINT (-73.9649611089685 40.7814371834837)          Cinnamon Above Ground
## 67    POINT (-73.9714289592392 40.7750670702093)          Cinnamon Above Ground
## 68    POINT (-73.9768357173861 40.7683813358343)          Cinnamon Ground Plane
## 69     POINT (-73.952526164386 40.7963759240504)          Cinnamon Above Ground
## 70    POINT (-73.9650499507011 40.7908191782173)          Cinnamon Above Ground
## 71    POINT (-73.9756810453606 40.7756257458036)          Cinnamon Ground Plane
## 72   POINT (-73.9625416200877 40.78113023979121)          Cinnamon Above Ground
## 73    POINT (-73.9792153893146 40.7688272492961)          Cinnamon Ground Plane
## 74    POINT (-73.9646597452128 40.7827698220703)          Cinnamon Above Ground
## 75    POINT (-73.9785133301426 40.7718260288338)          Cinnamon Ground Plane
## 76    POINT (-73.9808202088503 40.7682921842325)          Cinnamon Above Ground
## 77     POINT (-73.9540908513075 40.794201225045)          Cinnamon Ground Plane
## 78    POINT (-73.9655905300923 40.7752614638023)          Cinnamon Above Ground
## 79    POINT (-73.97642353733221 40.770606513989)          Cinnamon Ground Plane
## 80    POINT (-73.9757536187319 40.7755119810678)          Cinnamon Ground Plane
## 81  POINT (-73.9785536529136 40.771618450500206)          Cinnamon Ground Plane
## 82    POINT (-73.9801661903932 40.7697950141751)          Cinnamon Ground Plane
## 83    POINT (-73.9638298997554 40.7825966332367)          Cinnamon Ground Plane
## 84    POINT (-73.9624538733037 40.7883829851518)          Cinnamon Above Ground
## 85    POINT (-73.9799155966086 40.7698034314993)          Cinnamon Ground Plane
## 86    POINT (-73.9691057326088 40.7765973509721)          Cinnamon Ground Plane
## 87    POINT (-73.9658181813014 40.7798160637561)          Cinnamon Ground Plane
## 88   POINT (-73.9685080639873 40.77453097941551)          Cinnamon Above Ground
## 89     POINT (-73.9504693544225 40.797225436004)          Cinnamon Ground Plane
## 90    POINT (-73.9772026572674 40.7691598773017)          Cinnamon Ground Plane
## 91    POINT (-73.9654397484763 40.7798863522904)          Cinnamon Ground Plane
## 92    POINT (-73.9671640520938 40.7772236833816)          Cinnamon Ground Plane
## 93    POINT (-73.9756603846107 40.7672531319384)          Cinnamon Ground Plane
## 94    POINT (-73.9675472064204 40.7835947167436)          Cinnamon Above Ground
## 95    POINT (-73.9687476703117 40.7742856696093)          Cinnamon Above Ground
## 96    POINT (-73.9675023138703 40.7872554700995)          Cinnamon Above Ground
## 97    POINT (-73.9529413156461 40.7920963446605)          Cinnamon Ground Plane
## 98    POINT (-73.9682144039334 40.7773070675393)          Cinnamon Ground Plane
## 99    POINT (-73.9706851546184 40.7780777016038)          Cinnamon Above Ground
## 100   POINT (-73.9758959798289 40.7694125671679)          Cinnamon Ground Plane
## 101   POINT (-73.9642379942652 40.7774792520738)          Cinnamon Above Ground
## 102   POINT (-73.9642288873015 40.7820439983567)          Cinnamon Ground Plane
## 103   POINT (-73.9609704650925 40.7938786854735)          Cinnamon Above Ground
## 104   POINT (-73.9764016030666 40.7689894344251)          Cinnamon Ground Plane
## 105   POINT (-73.9799311173259 40.7685576997559)          Cinnamon Ground Plane
## 106    POINT (-73.9675198230918 40.778631094685)          Cinnamon Above Ground
## 107   POINT (-73.9734687538064 40.7694308959222)          Cinnamon Ground Plane
## 108   POINT (-73.9757216124349 40.7754310239649)          Cinnamon Ground Plane
## 109   POINT (-73.9763116425885 40.7688839576487)          Cinnamon Ground Plane
## 110    POINT (-73.967042958599 40.7784370719371)          Cinnamon Ground Plane
## 111   POINT (-73.9785948413883 40.7718908026758)          Cinnamon Ground Plane
## 112 POINT (-73.9706323458769 40.771319603426505)          Cinnamon Ground Plane
## 113   POINT (-73.9761447791484 40.7690147873986)          Cinnamon Ground Plane
## 114   POINT (-73.9654093844049 40.7806896368469)          Cinnamon Ground Plane
## 115   POINT (-73.9658443548822 40.7796704898979)          Cinnamon Ground Plane
## 116   POINT (-73.9623922773932 40.7814944428327)          Cinnamon Ground Plane
## 117  POINT (-73.96839940647311 40.7710765500799)          Cinnamon Ground Plane
## 118   POINT (-73.9689781843873 40.7709333833783)          Cinnamon Ground Plane
## 119    POINT (-73.978392591149 40.7668993398193)          Cinnamon Ground Plane
## 120   POINT (-73.9676424599715 40.7777766106807)          Cinnamon Ground Plane
## 121   POINT (-73.9649827807341 40.7817322832767)          Cinnamon Ground Plane
## 122   POINT (-73.9790896775237 40.7688048644871)          Cinnamon Ground Plane
## 123   POINT (-73.9801985977846 40.7680159511705)          Cinnamon Ground Plane
## 124    POINT (-73.9645547556826 40.776877007081)          Cinnamon Above Ground
## 125    POINT (-73.9686296217893 40.771812308875)          Cinnamon Above Ground
## 126   POINT (-73.9552035011902 40.7889851896334)          Cinnamon Above Ground
## 127   POINT (-73.9553163829551 40.7988610926249)          Cinnamon Ground Plane
## 128   POINT (-73.9563311167069 40.7950901563337)          Cinnamon Ground Plane
## 129    POINT (-73.9593374341938 40.797258337802)          Cinnamon Ground Plane
## 130   POINT (-73.9562642076935 40.7983338763074)          Cinnamon Ground Plane
## 131    POINT (-73.9811078442462 40.767515940567)          Cinnamon Ground Plane
## 132   POINT (-73.9695305996721 40.7745386896959)          Cinnamon Ground Plane
## 133   POINT (-73.9640534906634 40.7777383899836)          Cinnamon Ground Plane
## 134   POINT (-73.9541837143178 40.7944340477396)          Cinnamon Ground Plane
## 135   POINT (-73.9680855277775 40.7769251965381)          Cinnamon Above Ground
## 136   POINT (-73.9770985425092 40.7665926744505)          Cinnamon Ground Plane
## 137   POINT (-73.9604954276129 40.7965682182001)          Cinnamon Ground Plane
## 138   POINT (-73.9541500874008 40.7920329989756)          Cinnamon Above Ground
## 139   POINT (-73.9693465383617 40.7744996336934)          Cinnamon Ground Plane
## 140   POINT (-73.9645060433292 40.7768322057794)          Cinnamon Ground Plane
## 141    POINT (-73.9776445567926 40.768119107973)          Cinnamon Ground Plane
## 142  POINT (-73.9744906832678 40.76999487467761)          Cinnamon Ground Plane
## 143   POINT (-73.9798390387307 40.7700761090896)          Cinnamon Ground Plane
## 144   POINT (-73.9667474482967 40.7760643720793)          Cinnamon Above Ground
## 145   POINT (-73.9594357049738 40.7840678890949)          Cinnamon Above Ground
## 146  POINT (-73.9615817859213 40.79458396638451)          Cinnamon Ground Plane
## 147   POINT (-73.9765805609072 40.7692807820935)          Cinnamon Ground Plane
## 148   POINT (-73.9611446263364 40.7911003407299)          Cinnamon Above Ground
## 149   POINT (-73.9794367096274 40.7672720598482)          Cinnamon Ground Plane
## 150    POINT (-73.964572179093 40.7811208719018)          Cinnamon Ground Plane
## 151   POINT (-73.9763894759543 40.7705523372364)          Cinnamon Ground Plane
## 152   POINT (-73.9689504114652 40.7766770153764)          Cinnamon Above Ground
## 153    POINT (-73.9807898224726 40.768215817511)          Cinnamon Ground Plane
## 154   POINT (-73.9793334416378 40.7674142089209)          Cinnamon Ground Plane
## 155   POINT (-73.9762187733662 40.7739282973004)          Cinnamon Ground Plane
## 156   POINT (-73.9756993198381 40.7681956641913)          Cinnamon Ground Plane
## 157   POINT (-73.9761792189352 40.7745745517215)          Cinnamon Ground Plane
## 158   POINT (-73.9728895595977 40.7699378332299)          Cinnamon Ground Plane
## 159   POINT (-73.9796409671481 40.7679049871186)          Cinnamon Ground Plane
## 160     POINT (-73.97684509717 40.7709430375069)          Cinnamon Above Ground
## 161   POINT (-73.9790822606486 40.7714466633386)          Cinnamon Above Ground
## 162   POINT (-73.9722281263634 40.7704083288013)          Cinnamon Ground Plane
## 163 POINT (-73.9543044385367 40.798449857133804)          Cinnamon Ground Plane
## 164   POINT (-73.9527227282134 40.7935061484064)          Cinnamon Above Ground
## 165    POINT (-73.9811585807616 40.768706748732)          Cinnamon Ground Plane
## 166    POINT (-73.9709897849823 40.768627964006)          Cinnamon Ground Plane
## 167    POINT (-73.967762162893 40.7823359027165)          Cinnamon Ground Plane
## 168   POINT (-73.9702541471417 40.7698584231797)          Cinnamon Ground Plane
## 169  POINT (-73.97980051887042 40.7691868791734)          Cinnamon Ground Plane
## 170   POINT (-73.9795728289645 40.7678669804787)          Cinnamon Ground Plane
## 171    POINT (-73.974451175321 40.7701294635264)          Cinnamon Ground Plane
## 172   POINT (-73.9763236949008 40.7686815615335)          Cinnamon Above Ground
## 173   POINT (-73.9724681269526 40.7743474675821)          Cinnamon Ground Plane
## 174   POINT (-73.9668140804066 40.7768100147333)          Cinnamon Ground Plane
## 175   POINT (-73.9604089940153 40.7910028063138)          Cinnamon Ground Plane
## 176   POINT (-73.9694169352433 40.7744408293858)          Cinnamon Ground Plane
## 177    POINT (-73.957134662576 40.7872395604122)          Cinnamon Ground Plane
## 178   POINT (-73.9610985171525 40.7913867116989)          Cinnamon Above Ground
## 179   POINT (-73.9636476467218 40.7775556986702)          Cinnamon Ground Plane
## 180   POINT (-73.9765269282059 40.7746876635248)          Cinnamon Ground Plane
## 181    POINT (-73.972112497276 40.7702759037428)          Cinnamon Ground Plane
## 182    POINT (-73.9702717260829 40.768951107763)          Cinnamon Ground Plane
## 183   POINT (-73.9796470494747 40.7678370925485)          Cinnamon Ground Plane
## 184   POINT (-73.9611274898661 40.7915250069086)          Cinnamon Ground Plane
## 185   POINT (-73.9787608762005 40.7686062296462)          Cinnamon Above Ground
## 186     POINT (-73.95488263914 40.7959474571251)          Cinnamon Above Ground
## 187   POINT (-73.9594676326588 40.7984457363388)          Cinnamon Ground Plane
## 188   POINT (-73.9678561384348 40.7782877397822)          Cinnamon Ground Plane
## 189   POINT (-73.9757313481982 40.7754704051391)          Cinnamon Ground Plane
## 190   POINT (-73.9673924060436 40.7788781851716)          Cinnamon Ground Plane
## 191   POINT (-73.9721279808683 40.7661158663901)          Cinnamon Ground Plane
## 192   POINT (-73.9772810073685 40.7693577540392)          Cinnamon Ground Plane
## 193   POINT (-73.9697744662785 40.7755950428973)          Cinnamon Ground Plane
## 194   POINT (-73.9807078515193 40.7683335292642)          Cinnamon Ground Plane
## 195   POINT (-73.9733461334967 40.7684314285151)          Cinnamon Ground Plane
## 196   POINT (-73.9662409997642 40.7891042935432)          Cinnamon Ground Plane
## 197   POINT (-73.9746128451271 40.7700957046709)          Cinnamon Ground Plane
## 198   POINT (-73.9713906492842 40.7750061310143)          Cinnamon Ground Plane
## 199   POINT (-73.9785114291288 40.7719779589449)          Cinnamon Ground Plane
## 200    POINT (-73.968200390984 40.7837095769482)          Cinnamon Ground Plane
## 201   POINT (-73.9587072763996 40.7850256219415)          Cinnamon Above Ground
## 202  POINT (-73.96423978295472 40.7918992406575)          Cinnamon Ground Plane
## 203    POINT (-73.9540197079615 40.798039260983)          Cinnamon Above Ground
## 204    POINT (-73.965390623703 40.7807731363782)          Cinnamon Ground Plane
## 205   POINT (-73.9544278270221 40.7987827316512)          Cinnamon Ground Plane
## 206   POINT (-73.9690362384597 40.7767162824413)          Cinnamon Ground Plane
## 207   POINT (-73.9752029513644 40.7671734667361)          Cinnamon Ground Plane
## 208    POINT (-73.9527196716568 40.792363826828)          Cinnamon Above Ground
## 209   POINT (-73.9701408623121 40.7695511718541)          Cinnamon Ground Plane
## 210   POINT (-73.9564632239432 40.7904807427954)          Cinnamon Above Ground
## 211   POINT (-73.9762494239719 40.7750175306716)          Cinnamon Ground Plane
## 212   POINT (-73.9498421746221 40.7969397424182)          Cinnamon Above Ground
## 213  POINT (-73.9638167248251 40.77764856793541)          Cinnamon Above Ground
## 214   POINT (-73.9790889008147 40.7676402781925)          Cinnamon Ground Plane
## 215   POINT (-73.9801899519657 40.7695777009264)          Cinnamon Ground Plane
## 216   POINT (-73.9797425262459 40.7679120246352)          Cinnamon Ground Plane
## 217   POINT (-73.9657480066074 40.7753465489231)          Cinnamon Ground Plane
## 218   POINT (-73.9639700434449 40.7775003050028)          Cinnamon Ground Plane
## 219    POINT (-73.9577758125518 40.799384716477)          Cinnamon Ground Plane
## 220   POINT (-73.9756825338299 40.7755542506699)          Cinnamon Ground Plane
## 221   POINT (-73.9768286349595 40.7687012827059)          Cinnamon Ground Plane
## 222   POINT (-73.9690540696008 40.7766014124609)          Cinnamon Ground Plane
## 223    POINT (-73.951965247933 40.7938167628067)          Cinnamon Ground Plane
## 224    POINT (-73.978844141973 40.7696046074378)          Cinnamon Above Ground
## 225   POINT (-73.9698870647042 40.7826510985538)          Cinnamon Ground Plane
## 226   POINT (-73.9710187505339 40.7797265666746)          Cinnamon Ground Plane
## 227   POINT (-73.9775099290913 40.7697609063137)          Cinnamon Ground Plane
## 228   POINT (-73.9693159934697 40.7831212338295)          Cinnamon Above Ground
## 229    POINT (-73.9685940262068 40.776932102013)          Cinnamon Ground Plane
## 230  POINT (-73.9653311136561 40.78019349034301)          Cinnamon Ground Plane
## 231    POINT (-73.9791826197108 40.768577844752)          Cinnamon Ground Plane
## 232   POINT (-73.9748367344424 40.7693513000034)          Cinnamon Above Ground
## 233   POINT (-73.9679319758284 40.7821154802399)          Cinnamon Ground Plane
## 234   POINT (-73.9749641575871 40.7673305056277)          Cinnamon Above Ground
## 235  POINT (-73.97720701222511 40.7694343352509)          Cinnamon Ground Plane
## 236   POINT (-73.9693504617353 40.7830678709405)          Cinnamon Above Ground
## 237   POINT (-73.9616972557304 40.7953872829374)          Cinnamon Ground Plane
## 238   POINT (-73.9540151828782 40.7920066170587)          Cinnamon Above Ground
## 239   POINT (-73.9747175419546 40.7692820030878)          Cinnamon Ground Plane
## 240    POINT (-73.953664715831 40.7981256393159)          Cinnamon Ground Plane
## 241   POINT (-73.9750911996499 40.7722445210179)          Cinnamon Ground Plane
## 242   POINT (-73.9729979174723 40.7742904356698)          Cinnamon Ground Plane
## 243   POINT (-73.9521655419974 40.7948785497717)          Cinnamon Ground Plane
## 244   POINT (-73.9755259087781 40.7707256124181)          Cinnamon Above Ground
## 245   POINT (-73.9684834138222 40.7724289120211)          Cinnamon Ground Plane
## 246    POINT (-73.9524364087437 40.792846505434)          Cinnamon Above Ground
## 247    POINT (-73.9639505810228 40.789573183584)          Cinnamon Above Ground
## 248   POINT (-73.9766541879006 40.7674077265375)          Cinnamon Above Ground
## 249   POINT (-73.9622752768962 40.7814921913101)          Cinnamon Above Ground
## 250   POINT (-73.9749251267433 40.7679111971294)          Cinnamon Ground Plane
## 251   POINT (-73.9500167570283 40.7966185836685)          Cinnamon Ground Plane
## 252    POINT (-73.9643223016635 40.781431908715)          Cinnamon Ground Plane
## 253   POINT (-73.9771552326199 40.7706917595308)          Cinnamon Ground Plane
## 254   POINT (-73.95757980040841 40.795701403549)          Cinnamon Ground Plane
## 255   POINT (-73.9636234953334 40.7775138547689)          Cinnamon Ground Plane
## 256   POINT (-73.9675718059539 40.7786049141486)          Cinnamon Above Ground
## 257   POINT (-73.9685612289881 40.7778488829217)          Cinnamon Ground Plane
## 258   POINT (-73.9651541395415 40.7798283208748)          Cinnamon Above Ground
## 259   POINT (-73.9791536183194 40.7672705931866)          Cinnamon Ground Plane
## 260   POINT (-73.9686925781295 40.7705688673142)          Cinnamon Ground Plane
## 261  POINT (-73.97971223228342 40.7678347587435)          Cinnamon Above Ground
## 262   POINT (-73.9650387848001 40.7814134438394)          Cinnamon Ground Plane
## 263    POINT (-73.9794371709817 40.768387910254)          Cinnamon Ground Plane
## 264   POINT (-73.9686370726471 40.7780382348833)          Cinnamon Above Ground
## 265   POINT (-73.9684092812839 40.7711445841928)          Cinnamon Ground Plane
## 266   POINT (-73.9694938608335 40.7745700102115)          Cinnamon Ground Plane
## 267   POINT (-73.9657040391563 40.7755567428199)          Cinnamon Above Ground
## 268    POINT (-73.960898739757 40.7961393097144)          Cinnamon Above Ground
## 269   POINT (-73.9594986107981 40.7840083040604)          Cinnamon Above Ground
## 270   POINT (-73.9694382427984 40.7846350692923)          Cinnamon Ground Plane
## 271    POINT (-73.9734741818047 40.766328451425)          Cinnamon Ground Plane
## 272    POINT (-73.9575258627966 40.787715550749)          Cinnamon Ground Plane
## 273   POINT (-73.9509628195532 40.7977775674178)          Cinnamon Above Ground
## 274   POINT (-73.9774228454023 40.7686399839016)          Cinnamon Ground Plane
## 275   POINT (-73.9537703231359 40.7915959393814)          Cinnamon Above Ground
## 276   POINT (-73.9642967875857 40.7815652353937)          Cinnamon Ground Plane
## 277   POINT (-73.9590191655172 40.7926139425111)          Cinnamon Ground Plane
## 278   POINT (-73.9698044218476 40.7697007833531)          Cinnamon Ground Plane
## 279    POINT (-73.964539031099 40.7809916310012)          Cinnamon Ground Plane
## 280   POINT (-73.9767143644151 40.7684756941321)          Cinnamon Above Ground
## 281   POINT (-73.9691520826028 40.7717104037783)          Cinnamon Ground Plane
## 282   POINT (-73.9756894776708 40.7681638218212)          Cinnamon Ground Plane
## 283   POINT (-73.9789251806378 40.7699558513225)          Cinnamon Above Ground
## 284    POINT (-73.966824257293 40.7753405377869)          Cinnamon Ground Plane
## 285   POINT (-73.9767369686171 40.7735074437085)          Cinnamon Ground Plane
## 286   POINT (-73.9724618533895 40.7745021602455)          Cinnamon Ground Plane
## 287   POINT (-73.9786310308892 40.7669349368183)          Cinnamon Ground Plane
## 288   POINT (-73.9681671864047 40.7753770538635)          Cinnamon Ground Plane
## 289   POINT (-73.9808517324721 40.7683154647217)          Cinnamon Above Ground
## 290    POINT (-73.972010921173 40.7701626919216)          Cinnamon Ground Plane
## 291   POINT (-73.9665309689616 40.7775271020244)          Cinnamon Ground Plane
## 292   POINT (-73.9686907918759 40.7839462261858)          Cinnamon Ground Plane
## 293   POINT (-73.9775865217038 40.7704928300008)          Cinnamon Ground Plane
## 294   POINT (-73.9756105226696 40.7696531972655)          Cinnamon Ground Plane
## 295   POINT (-73.9565151662506 40.7946647987447)          Cinnamon Ground Plane
## 296    POINT (-73.9577297187155 40.799225295679)          Cinnamon Above Ground
## 297   POINT (-73.9605347462123 40.7942075448387)          Cinnamon Ground Plane
## 298   POINT (-73.9768544488742 40.7680069500977)          Cinnamon Ground Plane
## 299   POINT (-73.9691318044969 40.7709801974696)          Cinnamon Ground Plane
## 300   POINT (-73.9674931070324 40.7783693690954)          Cinnamon Above Ground
## 301   POINT (-73.9596083366477 40.7949526729608)          Cinnamon Ground Plane
## 302   POINT (-73.9595222999173 40.7833202577782)          Cinnamon Above Ground
## 303   POINT (-73.9726920847792 40.7794117463889)          Cinnamon Ground Plane
## 304   POINT (-73.9801619956135 40.7678576697542)          Cinnamon Ground Plane
## 305    POINT (-73.954767265558 40.7973243644491)          Cinnamon Ground Plane
## 306    POINT (-73.974382557804 40.7674812627373)          Cinnamon Above Ground
## 307   POINT (-73.9550131837533 40.7958617258176)          Cinnamon Ground Plane
## 308   POINT (-73.9762974698771 40.7740076116964)          Cinnamon Ground Plane
## 309     POINT (-73.95744422055 40.7961046528557)          Cinnamon Ground Plane
## 310   POINT (-73.9649823687651 40.7763395359636)          Cinnamon Above Ground
## 311    POINT (-73.976869549792 40.7706982454723)          Cinnamon Above Ground
## 312   POINT (-73.9619016393127 40.7925160126921)          Cinnamon Ground Plane
## 313   POINT (-73.9781033448468 40.7666724066213)          Cinnamon Ground Plane
## 314   POINT (-73.9743393747021 40.7676346798325)          Cinnamon Ground Plane
## 315   POINT (-73.9694805745522 40.7743556902843)          Cinnamon Above Ground
## 316 POINT (-73.9701505245419 40.768998364571004)          Cinnamon Above Ground
## 317   POINT (-73.9755459090534 40.7680866624003)          Cinnamon Ground Plane
## 318    POINT (-73.978199543688 40.7695660563362)          Cinnamon Ground Plane
## 319   POINT (-73.9769693140651 40.7684390015166)          Cinnamon Above Ground
## 320   POINT (-73.9789971286844 40.7707024146365)          Cinnamon Ground Plane
## 321  POINT (-73.96926766598071 40.7700678919108)          Cinnamon Above Ground
## 322    POINT (-73.979636950073 40.7677999753976)          Cinnamon Ground Plane
## 323   POINT (-73.9522677657659 40.7934034811368)          Cinnamon Ground Plane
## 324   POINT (-73.9711673006524 40.7747979614577)          Cinnamon Ground Plane
## 325   POINT (-73.9771800098131 40.7708863131336)          Cinnamon Ground Plane
## 326   POINT (-73.9700264128414 40.7692014637698)          Cinnamon Ground Plane
## 327   POINT (-73.9772239251936 40.7731716665766)          Cinnamon Above Ground
## 328    POINT (-73.954499539822 40.7949716693686)          Cinnamon Ground Plane
## 329   POINT (-73.9743369068254 40.7675726965985)          Cinnamon Ground Plane
## 330   POINT (-73.9614599022015 40.7945181285991)          Cinnamon Ground Plane
## 331   POINT (-73.9771009024581 40.7688793288864)          Cinnamon Ground Plane
## 332    POINT (-73.9501457233643 40.797094356558)          Cinnamon Ground Plane
## 333   POINT (-73.9658867660358 40.7756523577509)          Cinnamon Ground Plane
## 334    POINT (-73.974596903918 40.7765498215674)          Cinnamon Ground Plane
## 335   POINT (-73.9694185786221 40.7787189999566)          Cinnamon Ground Plane
## 336   POINT (-73.9768096953647 40.7708185213129)          Cinnamon Ground Plane
## 337  POINT (-73.9628041577934 40.78841801560551)          Cinnamon Above Ground
## 338     POINT (-73.97296259363 40.7652601851275)          Cinnamon Above Ground
## 339   POINT (-73.9561432836863 40.7982665347234)          Cinnamon Ground Plane
## 340  POINT (-73.97206993774601 40.7659402627832)          Cinnamon Ground Plane
## 341   POINT (-73.9681090824978 40.7838275830328)          Cinnamon Ground Plane
## 342   POINT (-73.9671419119456 40.7758602486862)          Cinnamon Ground Plane
## 343   POINT (-73.9689204258063 40.7712540588951)          Cinnamon Ground Plane
## 344   POINT (-73.9692660977515 40.7830532310766)          Cinnamon Ground Plane
## 345   POINT (-73.9767835160078 40.7674030330482)          Cinnamon Above Ground
## 346   POINT (-73.9647845655965 40.7816573808695)          Cinnamon Ground Plane
## 347   POINT (-73.9712187890707 40.7750640173134)          Cinnamon Ground Plane
## 348   POINT (-73.9682627382073 40.7730766743452)          Cinnamon Ground Plane
## 349   POINT (-73.9697665830132 40.7759094917104)          Cinnamon Ground Plane
## 350   POINT (-73.9533101544112 40.7938634280159)          Cinnamon Ground Plane
## 351   POINT (-73.9711120079542 40.7760801911766)          Cinnamon Ground Plane
## 352   POINT (-73.9772691210241 40.7690960712994)          Cinnamon Ground Plane
## 353 POINT (-73.9507699667119 40.795516603955505)          Cinnamon Ground Plane
## 354    POINT (-73.969720780557 40.7741105688757)          Cinnamon Ground Plane
## 355   POINT (-73.956581233786 40.79021276908371)          Cinnamon Ground Plane
## 356   POINT (-73.9729265300533 40.7741768291642)          Cinnamon Ground Plane
## 357   POINT (-73.9636482556874 40.7775831570186)          Cinnamon Ground Plane
## 358   POINT (-73.9747873899653 40.7731945258327)          Cinnamon Ground Plane
## 359   POINT (-73.9689554458632 40.7778593393957)          Cinnamon Ground Plane
## 360   POINT (-73.9631005470369 40.7885494057193)          Cinnamon Ground Plane
## 361   POINT (-73.9632164738341 40.7921270121312)          Cinnamon Above Ground
## 362   POINT (-73.9621297946132 40.7944058222814)          Cinnamon Above Ground
## 363   POINT (-73.9734630412566 40.7653097139415)          Cinnamon Ground Plane
## 364   POINT (-73.9768563402344 40.7744487310786)          Cinnamon Ground Plane
## 365  POINT (-73.9650120066074 40.78059328824071)          Cinnamon Above Ground
## 366     POINT (-73.97033289562 40.7701079697795)          Cinnamon Ground Plane
## 367   POINT (-73.9690266660317 40.7853134751509)          Cinnamon Ground Plane
## 368    POINT (-73.962534856258 40.7812134517411)          Cinnamon Ground Plane
## 369  POINT (-73.974515099169 40.770065079988605)          Cinnamon Ground Plane
## 370   POINT (-73.9763719445827 40.7689551413337)          Cinnamon Ground Plane
## 371   POINT (-73.9711666523376 40.7761513057034)          Cinnamon Ground Plane
## 372   POINT (-73.9767389132988 40.7689323691424)          Cinnamon Above Ground
## 373   POINT (-73.9639801411692 40.7778921302618)          Cinnamon Ground Plane
## 374   POINT (-73.9724083320538 40.7744163768061)          Cinnamon Ground Plane
## 375   POINT (-73.9756533763813 40.7733537881363)          Cinnamon Ground Plane
## 376   POINT (-73.9643538221947 40.7917565604735)          Cinnamon Ground Plane
## 377   POINT (-73.9746063250438 40.7687654196811)          Cinnamon Ground Plane
## 378   POINT (-73.9752079247419 40.7755376979002)          Cinnamon Ground Plane
## 379    POINT (-73.9698663926657 40.773999710413)          Cinnamon Ground Plane
## 380   POINT (-73.9528482858163 40.7922056218325)          Cinnamon Ground Plane
## 381   POINT (-73.9645437409662 40.7811599933331)          Cinnamon Ground Plane
## 382   POINT (-73.9754794191553 40.7696404489025)          Cinnamon Ground Plane
library(dplyr)
data(mtcars)
glimpse(mtcars)
## Rows: 32
## Columns: 11
## $ mpg  <dbl> 21.0, 21.0, 22.8, 21.4, 18.7, 18.1, 14.3, 24.4, 22.8, 19.2, 17.8,…
## $ cyl  <dbl> 6, 6, 4, 6, 8, 6, 8, 4, 4, 6, 6, 8, 8, 8, 8, 8, 8, 4, 4, 4, 4, 8,…
## $ disp <dbl> 160.0, 160.0, 108.0, 258.0, 360.0, 225.0, 360.0, 146.7, 140.8, 16…
## $ hp   <dbl> 110, 110, 93, 110, 175, 105, 245, 62, 95, 123, 123, 180, 180, 180…
## $ drat <dbl> 3.90, 3.90, 3.85, 3.08, 3.15, 2.76, 3.21, 3.69, 3.92, 3.92, 3.92,…
## $ wt   <dbl> 2.620, 2.875, 2.320, 3.215, 3.440, 3.460, 3.570, 3.190, 3.150, 3.…
## $ qsec <dbl> 16.46, 17.02, 18.61, 19.44, 17.02, 20.22, 15.84, 20.00, 22.90, 18…
## $ vs   <dbl> 0, 0, 1, 1, 0, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0,…
## $ am   <dbl> 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0,…
## $ gear <dbl> 4, 4, 4, 3, 3, 3, 3, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 4, 4, 4, 3, 3,…
## $ carb <dbl> 4, 4, 1, 1, 2, 1, 4, 2, 2, 4, 4, 3, 3, 3, 4, 4, 4, 1, 2, 1, 1, 2,…
summary(mtcars)
##       mpg             cyl             disp             hp       
##  Min.   :10.40   Min.   :4.000   Min.   : 71.1   Min.   : 52.0  
##  1st Qu.:15.43   1st Qu.:4.000   1st Qu.:120.8   1st Qu.: 96.5  
##  Median :19.20   Median :6.000   Median :196.3   Median :123.0  
##  Mean   :20.09   Mean   :6.188   Mean   :230.7   Mean   :146.7  
##  3rd Qu.:22.80   3rd Qu.:8.000   3rd Qu.:326.0   3rd Qu.:180.0  
##  Max.   :33.90   Max.   :8.000   Max.   :472.0   Max.   :335.0  
##       drat             wt             qsec             vs        
##  Min.   :2.760   Min.   :1.513   Min.   :14.50   Min.   :0.0000  
##  1st Qu.:3.080   1st Qu.:2.581   1st Qu.:16.89   1st Qu.:0.0000  
##  Median :3.695   Median :3.325   Median :17.71   Median :0.0000  
##  Mean   :3.597   Mean   :3.217   Mean   :17.85   Mean   :0.4375  
##  3rd Qu.:3.920   3rd Qu.:3.610   3rd Qu.:18.90   3rd Qu.:1.0000  
##  Max.   :4.930   Max.   :5.424   Max.   :22.90   Max.   :1.0000  
##        am              gear            carb      
##  Min.   :0.0000   Min.   :3.000   Min.   :1.000  
##  1st Qu.:0.0000   1st Qu.:3.000   1st Qu.:2.000  
##  Median :0.0000   Median :4.000   Median :2.000  
##  Mean   :0.4062   Mean   :3.688   Mean   :2.812  
##  3rd Qu.:1.0000   3rd Qu.:4.000   3rd Qu.:4.000  
##  Max.   :1.0000   Max.   :5.000   Max.   :8.000
mtcars2 = within(mtcars, {
  vs = factor(vs,labels = c("V","S"))
  am = factor (am,labels = c("automatic","manual"))
  cyl = ordered(cyl)
  gear = ordered(gear)
  carb = ordered(carb)
})

mtcars2 %>%
  filter (am=="automatic")
##                      mpg cyl  disp  hp drat    wt  qsec vs        am gear carb
## Hornet 4 Drive      21.4   6 258.0 110 3.08 3.215 19.44  S automatic    3    1
## Hornet Sportabout   18.7   8 360.0 175 3.15 3.440 17.02  V automatic    3    2
## Valiant             18.1   6 225.0 105 2.76 3.460 20.22  S automatic    3    1
## Duster 360          14.3   8 360.0 245 3.21 3.570 15.84  V automatic    3    4
## Merc 240D           24.4   4 146.7  62 3.69 3.190 20.00  S automatic    4    2
## Merc 230            22.8   4 140.8  95 3.92 3.150 22.90  S automatic    4    2
## Merc 280            19.2   6 167.6 123 3.92 3.440 18.30  S automatic    4    4
## Merc 280C           17.8   6 167.6 123 3.92 3.440 18.90  S automatic    4    4
## Merc 450SE          16.4   8 275.8 180 3.07 4.070 17.40  V automatic    3    3
## Merc 450SL          17.3   8 275.8 180 3.07 3.730 17.60  V automatic    3    3
## Merc 450SLC         15.2   8 275.8 180 3.07 3.780 18.00  V automatic    3    3
## Cadillac Fleetwood  10.4   8 472.0 205 2.93 5.250 17.98  V automatic    3    4
## Lincoln Continental 10.4   8 460.0 215 3.00 5.424 17.82  V automatic    3    4
## Chrysler Imperial   14.7   8 440.0 230 3.23 5.345 17.42  V automatic    3    4
## Toyota Corona       21.5   4 120.1  97 3.70 2.465 20.01  S automatic    3    1
## Dodge Challenger    15.5   8 318.0 150 2.76 3.520 16.87  V automatic    3    2
## AMC Javelin         15.2   8 304.0 150 3.15 3.435 17.30  V automatic    3    2
## Camaro Z28          13.3   8 350.0 245 3.73 3.840 15.41  V automatic    3    4
## Pontiac Firebird    19.2   8 400.0 175 3.08 3.845 17.05  V automatic    3    2
summary(mtcars2)
##       mpg        cyl         disp             hp             drat      
##  Min.   :10.40   4:11   Min.   : 71.1   Min.   : 52.0   Min.   :2.760  
##  1st Qu.:15.43   6: 7   1st Qu.:120.8   1st Qu.: 96.5   1st Qu.:3.080  
##  Median :19.20   8:14   Median :196.3   Median :123.0   Median :3.695  
##  Mean   :20.09          Mean   :230.7   Mean   :146.7   Mean   :3.597  
##  3rd Qu.:22.80          3rd Qu.:326.0   3rd Qu.:180.0   3rd Qu.:3.920  
##  Max.   :33.90          Max.   :472.0   Max.   :335.0   Max.   :4.930  
##        wt             qsec       vs             am     gear   carb  
##  Min.   :1.513   Min.   :14.50   V:18   automatic:19   3:15   1: 7  
##  1st Qu.:2.581   1st Qu.:16.89   S:14   manual   :13   4:12   2:10  
##  Median :3.325   Median :17.71                         5: 5   3: 3  
##  Mean   :3.217   Mean   :17.85                                4:10  
##  3rd Qu.:3.610   3rd Qu.:18.90                                6: 1  
##  Max.   :5.424   Max.   :22.90                                8: 1
mtcars2 %>%
  filter(cyl == 4)%>%
  arrange(wt)
##                 mpg cyl  disp  hp drat    wt  qsec vs        am gear carb
## Lotus Europa   30.4   4  95.1 113 3.77 1.513 16.90  S    manual    5    2
## Honda Civic    30.4   4  75.7  52 4.93 1.615 18.52  S    manual    4    2
## Toyota Corolla 33.9   4  71.1  65 4.22 1.835 19.90  S    manual    4    1
## Fiat X1-9      27.3   4  79.0  66 4.08 1.935 18.90  S    manual    4    1
## Porsche 914-2  26.0   4 120.3  91 4.43 2.140 16.70  V    manual    5    2
## Fiat 128       32.4   4  78.7  66 4.08 2.200 19.47  S    manual    4    1
## Datsun 710     22.8   4 108.0  93 3.85 2.320 18.61  S    manual    4    1
## Toyota Corona  21.5   4 120.1  97 3.70 2.465 20.01  S automatic    3    1
## Volvo 142E     21.4   4 121.0 109 4.11 2.780 18.60  S    manual    4    2
## Merc 230       22.8   4 140.8  95 3.92 3.150 22.90  S automatic    4    2
## Merc 240D      24.4   4 146.7  62 3.69 3.190 20.00  S automatic    4    2
mtcars2 %>%
  filter(mpg > 20) %>%
  arrange(hp)%>%
  head()
##                 mpg cyl  disp hp drat    wt  qsec vs        am gear carb
## Honda Civic    30.4   4  75.7 52 4.93 1.615 18.52  S    manual    4    2
## Merc 240D      24.4   4 146.7 62 3.69 3.190 20.00  S automatic    4    2
## Toyota Corolla 33.9   4  71.1 65 4.22 1.835 19.90  S    manual    4    1
## Fiat 128       32.4   4  78.7 66 4.08 2.200 19.47  S    manual    4    1
## Fiat X1-9      27.3   4  79.0 66 4.08 1.935 18.90  S    manual    4    1
## Porsche 914-2  26.0   4 120.3 91 4.43 2.140 16.70  V    manual    5    2
mtcars2 %>%
  filter(between(mpg, 15, 25))
##                    mpg cyl  disp  hp drat    wt  qsec vs        am gear carb
## Mazda RX4         21.0   6 160.0 110 3.90 2.620 16.46  V    manual    4    4
## Mazda RX4 Wag     21.0   6 160.0 110 3.90 2.875 17.02  V    manual    4    4
## Datsun 710        22.8   4 108.0  93 3.85 2.320 18.61  S    manual    4    1
## Hornet 4 Drive    21.4   6 258.0 110 3.08 3.215 19.44  S automatic    3    1
## Hornet Sportabout 18.7   8 360.0 175 3.15 3.440 17.02  V automatic    3    2
## Valiant           18.1   6 225.0 105 2.76 3.460 20.22  S automatic    3    1
## Merc 240D         24.4   4 146.7  62 3.69 3.190 20.00  S automatic    4    2
## Merc 230          22.8   4 140.8  95 3.92 3.150 22.90  S automatic    4    2
## Merc 280          19.2   6 167.6 123 3.92 3.440 18.30  S automatic    4    4
## Merc 280C         17.8   6 167.6 123 3.92 3.440 18.90  S automatic    4    4
## Merc 450SE        16.4   8 275.8 180 3.07 4.070 17.40  V automatic    3    3
## Merc 450SL        17.3   8 275.8 180 3.07 3.730 17.60  V automatic    3    3
## Merc 450SLC       15.2   8 275.8 180 3.07 3.780 18.00  V automatic    3    3
## Toyota Corona     21.5   4 120.1  97 3.70 2.465 20.01  S automatic    3    1
## Dodge Challenger  15.5   8 318.0 150 2.76 3.520 16.87  V automatic    3    2
## AMC Javelin       15.2   8 304.0 150 3.15 3.435 17.30  V automatic    3    2
## Pontiac Firebird  19.2   8 400.0 175 3.08 3.845 17.05  V automatic    3    2
## Ford Pantera L    15.8   8 351.0 264 4.22 3.170 14.50  V    manual    5    4
## Ferrari Dino      19.7   6 145.0 175 3.62 2.770 15.50  V    manual    5    6
## Maserati Bora     15.0   8 301.0 335 3.54 3.570 14.60  V    manual    5    8
## Volvo 142E        21.4   4 121.0 109 4.11 2.780 18.60  S    manual    4    2
mtcars2 %>%
  select(cyl,wt,am)
##                     cyl    wt        am
## Mazda RX4             6 2.620    manual
## Mazda RX4 Wag         6 2.875    manual
## Datsun 710            4 2.320    manual
## Hornet 4 Drive        6 3.215 automatic
## Hornet Sportabout     8 3.440 automatic
## Valiant               6 3.460 automatic
## Duster 360            8 3.570 automatic
## Merc 240D             4 3.190 automatic
## Merc 230              4 3.150 automatic
## Merc 280              6 3.440 automatic
## Merc 280C             6 3.440 automatic
## Merc 450SE            8 4.070 automatic
## Merc 450SL            8 3.730 automatic
## Merc 450SLC           8 3.780 automatic
## Cadillac Fleetwood    8 5.250 automatic
## Lincoln Continental   8 5.424 automatic
## Chrysler Imperial     8 5.345 automatic
## Fiat 128              4 2.200    manual
## Honda Civic           4 1.615    manual
## Toyota Corolla        4 1.835    manual
## Toyota Corona         4 2.465 automatic
## Dodge Challenger      8 3.520 automatic
## AMC Javelin           8 3.435 automatic
## Camaro Z28            8 3.840 automatic
## Pontiac Firebird      8 3.845 automatic
## Fiat X1-9             4 1.935    manual
## Porsche 914-2         4 2.140    manual
## Lotus Europa          4 1.513    manual
## Ford Pantera L        8 3.170    manual
## Ferrari Dino          6 2.770    manual
## Maserati Bora         8 3.570    manual
## Volvo 142E            4 2.780    manual
mtcars2 %>%
  select(where(is.character))
## data frame with 0 columns and 32 rows
mtcars2 %>%
  select(where(is.factor))
##                     cyl vs        am gear carb
## Mazda RX4             6  V    manual    4    4
## Mazda RX4 Wag         6  V    manual    4    4
## Datsun 710            4  S    manual    4    1
## Hornet 4 Drive        6  S automatic    3    1
## Hornet Sportabout     8  V automatic    3    2
## Valiant               6  S automatic    3    1
## Duster 360            8  V automatic    3    4
## Merc 240D             4  S automatic    4    2
## Merc 230              4  S automatic    4    2
## Merc 280              6  S automatic    4    4
## Merc 280C             6  S automatic    4    4
## Merc 450SE            8  V automatic    3    3
## Merc 450SL            8  V automatic    3    3
## Merc 450SLC           8  V automatic    3    3
## Cadillac Fleetwood    8  V automatic    3    4
## Lincoln Continental   8  V automatic    3    4
## Chrysler Imperial     8  V automatic    3    4
## Fiat 128              4  S    manual    4    1
## Honda Civic           4  S    manual    4    2
## Toyota Corolla        4  S    manual    4    1
## Toyota Corona         4  S automatic    3    1
## Dodge Challenger      8  V automatic    3    2
## AMC Javelin           8  V automatic    3    2
## Camaro Z28            8  V automatic    3    4
## Pontiac Firebird      8  V automatic    3    2
## Fiat X1-9             4  S    manual    4    1
## Porsche 914-2         4  V    manual    5    2
## Lotus Europa          4  S    manual    5    2
## Ford Pantera L        8  V    manual    5    4
## Ferrari Dino          6  V    manual    5    6
## Maserati Bora         8  V    manual    5    8
## Volvo 142E            4  S    manual    4    2
mtcars2 %>%
  select(where(is.numeric))
##                      mpg  disp  hp drat    wt  qsec
## Mazda RX4           21.0 160.0 110 3.90 2.620 16.46
## Mazda RX4 Wag       21.0 160.0 110 3.90 2.875 17.02
## Datsun 710          22.8 108.0  93 3.85 2.320 18.61
## Hornet 4 Drive      21.4 258.0 110 3.08 3.215 19.44
## Hornet Sportabout   18.7 360.0 175 3.15 3.440 17.02
## Valiant             18.1 225.0 105 2.76 3.460 20.22
## Duster 360          14.3 360.0 245 3.21 3.570 15.84
## Merc 240D           24.4 146.7  62 3.69 3.190 20.00
## Merc 230            22.8 140.8  95 3.92 3.150 22.90
## Merc 280            19.2 167.6 123 3.92 3.440 18.30
## Merc 280C           17.8 167.6 123 3.92 3.440 18.90
## Merc 450SE          16.4 275.8 180 3.07 4.070 17.40
## Merc 450SL          17.3 275.8 180 3.07 3.730 17.60
## Merc 450SLC         15.2 275.8 180 3.07 3.780 18.00
## Cadillac Fleetwood  10.4 472.0 205 2.93 5.250 17.98
## Lincoln Continental 10.4 460.0 215 3.00 5.424 17.82
## Chrysler Imperial   14.7 440.0 230 3.23 5.345 17.42
## Fiat 128            32.4  78.7  66 4.08 2.200 19.47
## Honda Civic         30.4  75.7  52 4.93 1.615 18.52
## Toyota Corolla      33.9  71.1  65 4.22 1.835 19.90
## Toyota Corona       21.5 120.1  97 3.70 2.465 20.01
## Dodge Challenger    15.5 318.0 150 2.76 3.520 16.87
## AMC Javelin         15.2 304.0 150 3.15 3.435 17.30
## Camaro Z28          13.3 350.0 245 3.73 3.840 15.41
## Pontiac Firebird    19.2 400.0 175 3.08 3.845 17.05
## Fiat X1-9           27.3  79.0  66 4.08 1.935 18.90
## Porsche 914-2       26.0 120.3  91 4.43 2.140 16.70
## Lotus Europa        30.4  95.1 113 3.77 1.513 16.90
## Ford Pantera L      15.8 351.0 264 4.22 3.170 14.50
## Ferrari Dino        19.7 145.0 175 3.62 2.770 15.50
## Maserati Bora       15.0 301.0 335 3.54 3.570 14.60
## Volvo 142E          21.4 121.0 109 4.11 2.780 18.60
mtcars2 %>%
  mutate(weight_kg = wt*1000*0.45)%>%
  select(everything())
##                      mpg cyl  disp  hp drat    wt  qsec vs        am gear carb
## Mazda RX4           21.0   6 160.0 110 3.90 2.620 16.46  V    manual    4    4
## Mazda RX4 Wag       21.0   6 160.0 110 3.90 2.875 17.02  V    manual    4    4
## Datsun 710          22.8   4 108.0  93 3.85 2.320 18.61  S    manual    4    1
## Hornet 4 Drive      21.4   6 258.0 110 3.08 3.215 19.44  S automatic    3    1
## Hornet Sportabout   18.7   8 360.0 175 3.15 3.440 17.02  V automatic    3    2
## Valiant             18.1   6 225.0 105 2.76 3.460 20.22  S automatic    3    1
## Duster 360          14.3   8 360.0 245 3.21 3.570 15.84  V automatic    3    4
## Merc 240D           24.4   4 146.7  62 3.69 3.190 20.00  S automatic    4    2
## Merc 230            22.8   4 140.8  95 3.92 3.150 22.90  S automatic    4    2
## Merc 280            19.2   6 167.6 123 3.92 3.440 18.30  S automatic    4    4
## Merc 280C           17.8   6 167.6 123 3.92 3.440 18.90  S automatic    4    4
## Merc 450SE          16.4   8 275.8 180 3.07 4.070 17.40  V automatic    3    3
## Merc 450SL          17.3   8 275.8 180 3.07 3.730 17.60  V automatic    3    3
## Merc 450SLC         15.2   8 275.8 180 3.07 3.780 18.00  V automatic    3    3
## Cadillac Fleetwood  10.4   8 472.0 205 2.93 5.250 17.98  V automatic    3    4
## Lincoln Continental 10.4   8 460.0 215 3.00 5.424 17.82  V automatic    3    4
## Chrysler Imperial   14.7   8 440.0 230 3.23 5.345 17.42  V automatic    3    4
## Fiat 128            32.4   4  78.7  66 4.08 2.200 19.47  S    manual    4    1
## Honda Civic         30.4   4  75.7  52 4.93 1.615 18.52  S    manual    4    2
## Toyota Corolla      33.9   4  71.1  65 4.22 1.835 19.90  S    manual    4    1
## Toyota Corona       21.5   4 120.1  97 3.70 2.465 20.01  S automatic    3    1
## Dodge Challenger    15.5   8 318.0 150 2.76 3.520 16.87  V automatic    3    2
## AMC Javelin         15.2   8 304.0 150 3.15 3.435 17.30  V automatic    3    2
## Camaro Z28          13.3   8 350.0 245 3.73 3.840 15.41  V automatic    3    4
## Pontiac Firebird    19.2   8 400.0 175 3.08 3.845 17.05  V automatic    3    2
## Fiat X1-9           27.3   4  79.0  66 4.08 1.935 18.90  S    manual    4    1
## Porsche 914-2       26.0   4 120.3  91 4.43 2.140 16.70  V    manual    5    2
## Lotus Europa        30.4   4  95.1 113 3.77 1.513 16.90  S    manual    5    2
## Ford Pantera L      15.8   8 351.0 264 4.22 3.170 14.50  V    manual    5    4
## Ferrari Dino        19.7   6 145.0 175 3.62 2.770 15.50  V    manual    5    6
## Maserati Bora       15.0   8 301.0 335 3.54 3.570 14.60  V    manual    5    8
## Volvo 142E          21.4   4 121.0 109 4.11 2.780 18.60  S    manual    4    2
##                     weight_kg
## Mazda RX4             1179.00
## Mazda RX4 Wag         1293.75
## Datsun 710            1044.00
## Hornet 4 Drive        1446.75
## Hornet Sportabout     1548.00
## Valiant               1557.00
## Duster 360            1606.50
## Merc 240D             1435.50
## Merc 230              1417.50
## Merc 280              1548.00
## Merc 280C             1548.00
## Merc 450SE            1831.50
## Merc 450SL            1678.50
## Merc 450SLC           1701.00
## Cadillac Fleetwood    2362.50
## Lincoln Continental   2440.80
## Chrysler Imperial     2405.25
## Fiat 128               990.00
## Honda Civic            726.75
## Toyota Corolla         825.75
## Toyota Corona         1109.25
## Dodge Challenger      1584.00
## AMC Javelin           1545.75
## Camaro Z28            1728.00
## Pontiac Firebird      1730.25
## Fiat X1-9              870.75
## Porsche 914-2          963.00
## Lotus Europa           680.85
## Ford Pantera L        1426.50
## Ferrari Dino          1246.50
## Maserati Bora         1606.50
## Volvo 142E            1251.00
mtcars2 %>%
  summarise(avg_weight = mean(wt))
##   avg_weight
## 1    3.21725
mtcars2 %>%
  summarise(avg_weight = mean(wt, na.rm = TRUE))
##   avg_weight
## 1    3.21725
mtcars2 %>%
  group_by(cyl)%>%
  summarise(avg_weight = mean(wt))
## # A tibble: 3 × 2
##   cyl   avg_weight
##   <ord>      <dbl>
## 1 4           2.29
## 2 6           3.12
## 3 8           4.00
ggplot(data = mtcars, aes(x =wt, y = mpg)) + geom_point()+
labs(title = "Hubungan Berat Mobil dengan Efisiensi Bahan Bakar", x = "Berat(1000 lbs)", y = "Miles per Gallon")

ggplot(data = mtcars, aes(x =wt, y = mpg, color =factor(cyl))) + geom_point() + labs(title = "berat vs efisiensi bahan bakar berdasarkan silinder", x = "berat (1000 lbs)", y = "miles per gallon", color = "jumlah silinder")

ggplot(data = mtcars,  aes(x = wt, y = mpg, color = factor(cyl)))+
  geom_point()+
  geom_smooth(method = "lm", se = FALSE, color ="blue") +
  labs(title = "berat vs efisiensi bahan bakar dengan garis regresi", color = "jumlah silinder", x = "berat(1000 lbs)",y = "miles per gallon")
## `geom_smooth()` using formula = 'y ~ x'

mtcars_summary = mtcars %>%
  group_by(cyl)%>%
  summarise(count=n())


ggplot(data = mtcars_summary, aes(x = factor(cyl), y = count)) + 
  geom_bar(stat = "identity", fill = "steelblue") + 
  labs(
    title = "Distribusi mobil berdasarkan jumlah silinder",
    x = "Jumlah Silinder",
    y = "Jumlah Mobil"
  )

ggplot(data = mtcars, aes(x=wt,y = mpg))+
  geom_point()+
  facet_wrap(~cyl) +
  labs(title = "berat vs efisiensi bb per jumlah silinder", x = "berat(1000 lbs)", y = "miles per galon")

ggplot(data = mtcars, aes(x = wt,y=mpg))+
  geom_point()+
  labs(title="scatter plot berat vs mpg")