Comparison of side walk cafes
Nag Rajendran
3/27/2021
This is a report showing the distribution of square footage of encloses vs unenclosed side walk care in NYC.Its is based on the latest release of data by NYC.This report was generated on Fri Apr 9 11:53:33 2021.
##
## ── Column specification ────────────────────────────────────────────────────────
## cols(
## Entity.Type = col_character(),
## License.Number = col_double(),
## Sidewalk.Cafe.Type = col_character(),
## Lic.Area.Sq.Ft = col_double(),
## Entity.Name = col_character(),
## Camis.Trade.Name = col_character(),
## Address.Street.Name = col_character(),
## Street.Address = col_character(),
## Address.Location = col_character(),
## Address.Zip.Code = col_double(),
## Camis.Phone.Number = col_double(),
## Location.1 = col_character()
## )The Data is split in to two dataframe for enclosed and unenclosed
enclosed = subset.data.frame(sidewalk, sidewalk$Sidewalk.Cafe.Type == "Enclosed")
unenclosed = subset.data.frame(sidewalk, sidewalk$Sidewalk.Cafe.Type == "Unenclosed")The Data is then plotted between enclosed vs unenclosed
boxplot(enclosed$Lic.Area.Sq.Ft,unenclosed$Lic.Area.Sq.Ft, names = c("Enclosed", "Unenclosed"), main = "NYC average square footage")
Summary
enclosedmedian = median(enclosed$Lic.Area.Sq.Ft, na.rm = TRUE)
unenclosedmedian = median(unenclosed$Lic.Area.Sq.Ft, na.rm = TRUE)
lengthenclosed1 = length(enclosed$License.Number)
lengthenclosed2 = sum(!is.na(enclosed$Lic.Area.Sq.Ft))
lengthunenclosed1 = length(unenclosed$Lic.Area.Sq.Ft)
lengthunenclosed2 = sum(!is.na(unenclosed$Lic.Area.Sq.Ft))
maxenclosed = max(enclosed$Lic.Area.Sq.Ft, na.rm=TRUE)
minenclosed = min(enclosed$Lic.Area.Sq.Ft,na.rm = TRUE)
maxunenclosed = max(unenclosed$Lic.Area.Sq.Ft, na.rm=TRUE)
minunenclosed = min(unenclosed$Lic.Area.Sq.Ft,na.rm = TRUE)
summary(enclosed)## Entity.Type License.Number Sidewalk.Cafe.Type Lic.Area.Sq.Ft
## Length:147 Min. : 571720 Length:147 Min. : 1.0
## Class :character 1st Qu.: 926712 Class :character 1st Qu.: 231.8
## Mode :character Median :1113412 Mode :character Median : 325.5
## Mean :1083284 Mean : 349.0
## 3rd Qu.:1257956 3rd Qu.: 420.0
## Max. :1354705 Max. :1044.0
## NA's :27
## Entity.Name Camis.Trade.Name Address.Street.Name Street.Address
## Length:147 Length:147 Length:147 Length:147
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## Address.Location Address.Zip.Code Camis.Phone.Number Location.1
## Length:147 Min. :10001 Min. :2.120e+02 Length:147
## Class :character 1st Qu.:10019 1st Qu.:2.125e+09 Class :character
## Mode :character Median :10025 Median :2.128e+09 Mode :character
## Mean :10288 Mean :3.810e+09
## 3rd Qu.:10128 3rd Qu.:7.184e+09
## Max. :11414 Max. :9.180e+09
## summary(unenclosed)## Entity.Type License.Number Sidewalk.Cafe.Type Lic.Area.Sq.Ft
## Length:861 Min. : 293907 Length:861 Min. : 30.0
## Class :character 1st Qu.:1133801 Class :character 1st Qu.: 139.0
## Mode :character Median :1221132 Mode :character Median : 202.0
## Mean :1182864 Mean : 245.9
## 3rd Qu.:1281789 3rd Qu.: 320.0
## Max. :1357229 Max. :1300.0
## NA's :8
## Entity.Name Camis.Trade.Name Address.Street.Name Street.Address
## Length:861 Length:861 Length:861 Length:861
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## Address.Location Address.Zip.Code Camis.Phone.Number Location.1
## Length:861 Min. :10001 Min. :2.120e+02 Length:861
## Class :character 1st Qu.:10013 1st Qu.:2.125e+09 Class :character
## Mode :character Median :10022 Median :2.127e+09 Mode :character
## Mean :10246 Mean :3.756e+09
## 3rd Qu.:10075 3rd Qu.:7.182e+09
## Max. :11694 Max. :9.180e+09
## Summary I ( Length based on License.Number )
The median size of the reported 147 enclosed cafe is 325.5 square feet. The largest enclosed cafe is 1044 square feet and the smallest is 1 square feet The median size of the reported 861 unenclosed cafe is 202 square feet. The largest enclosed cafe is 1300 square feet and the smallest is 30 square feet
Summary II ( Length based on Lic.Area.Sq.Ft excluding N/A’s )
The median size of the reported 120 enclosed cafe is 325.5 square feet. The largest enclosed cafe is 1044 square feet and the smallest is 1 square feet The median size of the reported 853 unenclosed cafe is 202 square feet. The largest enclosed cafe is 1300 square feet and the smallest is 30 square feet