export <- read.csv("Export.csv",sep=",",header=T)
nc_export <- subset(export,State== "North Carolina")
req_farmer_stores <- subset(nc_export, (County=="Wake") |(County=="Orange") |(County=="Johnston")|(County=="Durham"))
need farmer market data from 4 counties Wake, Orange, Johnston and Durham in North Carolina. Here is all the farmer market from 4 counties. There are 59 variables and 27 observations.
str(req_farmer_stores)
## 'data.frame': 27 obs. of 59 variables:
## $ FMID : int 1011109 1010489 1001607 1010564 1010872 1009697 1001873 1000312 1000175 1010414 ...
## $ MarketName : Factor w/ 7942 levels "100-Mile Market",..: 215 1000 1016 1312 1965 1966 1967 1985 2195 2392 ...
## $ Website : Factor w/ 4028 levels "","http:// jasper.agrilife.org/jasper-county-farmers-market/",..: 514 848 1 905 1961 1 1962 1352 1439 1964 ...
## $ Facebook : Factor w/ 2858 levels ""," www.facebook.com/pages/Haddon-Heights-Farmers-Market/219172298144851",..: 235 383 1 399 1 1 1 570 1487 129 ...
## $ Twitter : Factor w/ 609 levels ""," no twitter",..: 1 1 1 559 1 1 1 205 215 72 ...
## $ Youtube : Factor w/ 90 levels "","Buena Vista",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ OtherMedia : Factor w/ 301 levels ""," http://instagram.com/forsythfarmersmarket",..: 1 1 1 1 1 1 1 62 248 1 ...
## $ street : Factor w/ 8043 levels ""," 1102 McConnell Road",..: 2072 2659 6610 2941 7282 3017 7693 3678 1181 7455 ...
## $ city : Factor w/ 4865 levels "","-"," Dayton",..: 136 667 677 848 1188 1189 1188 1188 1915 1941 ...
## $ County : Factor w/ 1478 levels "","Abbeville",..: 1386 982 1386 673 410 410 410 410 982 1386 ...
## $ State : Factor w/ 54 levels "","Alabama","Alaska",..: 35 35 35 35 35 35 35 35 35 35 ...
## $ zip : Factor w/ 6117 levels "","00000","0033",..: 1772 1773 1772 1780 1797 1796 1798 1795 1759 1783 ...
## $ Season1Date : Factor w/ 2023 levels "","01/01/2011 to 12/31/2011",..: 325 236 1 236 370 601 259 224 223 501 ...
## $ Season1Time : Factor w/ 1644 levels "","Fri: 1:00 PM-5:00 PM;",..: 475 429 1 479 19 1015 1051 457 457 475 ...
## $ Season2Date : Factor w/ 336 levels "","01/01/2014 to 04/01/2014",..: 1 200 1 243 1 1 1 291 236 20 ...
## $ Season2Time : Factor w/ 198 levels "","Fri: 11:30 AM-1:00 PM;",..: 1 61 1 29 1 1 1 32 32 32 ...
## $ Season3Date : Factor w/ 62 levels "","01/01/2012 to 05/31/2012",..: 1 14 1 12 1 1 1 15 1 1 ...
## $ Season3Time : Factor w/ 45 levels "","Fri: 9:00 AM-1:00 PM;",..: 1 39 1 17 1 1 1 41 1 1 ...
## $ Season4Date : Factor w/ 8 levels "","01/03/2014 to 05/30/2014",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ Season4Time : Factor w/ 8 levels "","Fri: 9:00 AM-1:00 PM;",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ x : num -78.8 -79.1 -78.9 -78.5 -78.9 ...
## $ y : num 35.7 35.9 35.7 35.7 36 ...
## $ Location : Factor w/ 11 levels "","Closed-off public street",..: 1 1 1 1 1 7 7 1 1 1 ...
## $ Credit : Factor w/ 2 levels "N","Y": 1 1 2 1 1 2 2 1 1 1 ...
## $ WIC : Factor w/ 2 levels "N","Y": 2 2 1 1 1 1 1 2 2 1 ...
## $ WICcash : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 2 1 ...
## $ SFMNP : Factor w/ 2 levels "N","Y": 2 2 1 1 1 1 1 2 2 1 ...
## $ SNAP : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 2 1 1 ...
## $ Organic : Factor w/ 3 levels "-","N","Y": 3 3 1 1 3 2 3 3 3 2 ...
## $ Bakedgoods : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 1 2 2 2 ...
## $ Cheese : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 1 2 2 2 ...
## $ Crafts : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 1 2 2 1 ...
## $ Flowers : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 2 2 2 2 ...
## $ Eggs : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 2 2 2 2 ...
## $ Seafood : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 1 1 2 ...
## $ Herbs : Factor w/ 2 levels "N","Y": 2 2 1 2 2 2 2 2 2 2 ...
## $ Vegetables : Factor w/ 2 levels "N","Y": 2 2 1 2 2 2 2 2 2 2 ...
## $ Honey : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 1 2 2 2 ...
## $ Jams : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 1 2 2 2 ...
## $ Maple : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
## $ Meat : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 2 2 2 2 ...
## $ Nursery : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
## $ Nuts : Factor w/ 2 levels "N","Y": 1 2 1 1 2 1 1 2 1 2 ...
## $ Plants : Factor w/ 2 levels "N","Y": 2 2 1 2 2 2 2 2 2 2 ...
## $ Poultry : Factor w/ 2 levels "N","Y": 2 2 1 2 1 1 2 2 2 2 ...
## $ Prepared : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 1 2 2 2 ...
## $ Soap : Factor w/ 2 levels "N","Y": 2 2 1 2 2 1 1 2 2 2 ...
## $ Trees : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 2 2 1 ...
## $ Wine : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 2 1 1 ...
## $ Coffee : Factor w/ 2 levels "N","Y": 2 2 1 1 2 1 1 2 1 2 ...
## $ Beans : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 2 1 1 ...
## $ Fruits : Factor w/ 2 levels "N","Y": 2 2 1 2 2 2 2 2 2 2 ...
## $ Grains : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 2 2 1 1 ...
## $ Juices : Factor w/ 2 levels "N","Y": 1 1 1 2 2 1 1 2 1 2 ...
## $ Mushrooms : Factor w/ 2 levels "N","Y": 2 2 1 1 2 1 1 2 2 2 ...
## $ PetFood : Factor w/ 2 levels "N","Y": 2 1 1 1 1 1 1 1 1 2 ...
## $ Tofu : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 2 1 1 ...
## $ WildHarvested: Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 2 2 1 ...
## $ updateTime : Factor w/ 5797 levels "1/1/2015 10:12:55 PM",..: 3276 3977 114 5214 838 1666 1658 685 741 2780 ...
summary(req_farmer_stores)
## FMID MarketName
## Min. :1000175 Apex Farmers Market : 1
## 1st Qu.:1001632 Carrboro Farmers' Market : 1
## Median :1004327 Cary Downtown Farmers Market : 1
## Mean :1005386 Clayton Farm and Community Market : 1
## 3rd Qu.:1010395 Duke Farmers Market : 1
## Max. :1011109 Duke Farmers Market at Duke Regional Hospital: 1
## (Other) :21
## Website
## : 3
## http://www.apexfarmersmarket.com : 1
## http://www.carrborofarmersmarket.com: 1
## http://www.cfcmnc.org : 1
## http://www.durhamfarmersmarket.com : 1
## http://www.enoriverfarmersmarket.com: 1
## (Other) :19
## Facebook
## : 9
## https://www.facebook.com/RaleighEatLocal : 2
## holly springs farmers market : 1
## https://www.facebook.com/apexfarmersmarket : 1
## https://www.facebook.com/carrborofarmersmarket: 1
## https://www.facebook.com/CFCMNC : 1
## (Other) :12
## Twitter Youtube
## :13 :27
## @HFMLocalGrown : 1 Buena Vista : 0
## hsfarmersmarket : 1 Calistoga Farmers Market: 0
## https://twitter.com/chfarmersmarket: 1 Culinary Kidz : 0
## https://twitter.com/DurhamFarmerMkt: 1 DowntownGB : 0
## https://twitter.com/EnoRiverFM : 1 DowntownGreenBay : 0
## (Other) : 9 (Other) : 0
## OtherMedia
## :24
## http://instagram.com/durhamfarmersmarket/ : 1
## pinterest: chfarmersmarket instagram: chfarmersmarket: 1
## Pinterest: Eno River Farmers Market : 1
## http://instagram.com/forsythfarmersmarket : 0
## #marysvillefarmersmarket : 0
## (Other) : 0
## street city County
## : 1 Raleigh :5 Wake :14
## 102 N. Main St. : 1 Durham :4 Durham : 5
## 1145 Falls River Avenue : 1 Cary :3 Orange : 5
## 1201 Agriculture St : 1 Chapel Hill :2 Johnston : 3
## 1225 Morrisville Carpenter Rd. : 1 Hillsborough:2 : 0
## 1410 S. Brightleaf Blvd., (Hwy 301): 1 Smithfield :2 Abbeville: 0
## (Other) :21 (Other) :9 (Other) : 0
## State zip Season1Date
## North Carolina:27 27278 : 2 : 2
## : 0 27502 : 2 01/01/2014 to 12/31/2014: 2
## Alabama : 0 27577 : 2 04/04/2015 to 10/31/2015: 2
## Alaska : 0 27601 : 2 04/05/2014 to 10/25/2014: 2
## Arizona : 0 : 1 April to October : 2
## Arkansas : 0 27510 : 1 03/29/2014 to 11/27/2014: 1
## (Other) : 0 (Other):17 (Other) :16
## Season1Time Season2Date
## Sat: 8:00 AM-12:00 PM;: 8 :18
## : 2 11/01/2014 to 03/28/2015: 2
## Sat: 8:30 AM-12:30 PM;: 2 03/01/2015 to : 1
## Sat: 9:00 AM-1:00 PM; : 2 04/15/2013 to 11/26/2013: 1
## Wed: 10:00 AM-2:00 PM;: 2 11/07/2015 to 03/26/2016: 1
## Fri: 11:00 AM-2:00 PM;: 1 11/08/2014 to 03/28/2015: 1
## (Other) :10 (Other) : 3
## Season2Time Season3Date
## :18 :21
## Sat: 10:00 AM-12:00 PM;: 3 04/04/2015 to 10/31/2015: 1
## Sat: 9:00 AM-12:00 PM; : 2 04/09/2014 to 11/19/2014: 1
## Sat: 10:00 AM-1:00 PM; : 1 04/15/2015 to 10/14/2015: 1
## Sat:9:00 AM - 12:00 PM;: 1 06/02/2015 to 08/25/2015: 1
## Tue: 3:00 PM-6:00 PM; : 1 11/28/2014 to 03/21/2015: 1
## (Other) : 1 (Other) : 1
## Season3Time Season4Date
## :21 :27
## Sat: 10:00 AM-12:00 PM;: 1 01/03/2014 to 05/30/2014: 0
## Sat: 9:00 AM-1:00 PM; : 1 02/15/2015 to 02/15/2015: 0
## Sat: 9:00 AM-12:00 PM; : 1 09/26/2015 to 09/26/2015: 0
## Tue: 10:00 AM-2:00 PM; : 1 10/11/2014 to 10/11/2014: 0
## Wed: 3:00 PM-6:00 PM; : 1 11/01/2014 to 12/20/2014: 0
## (Other) : 1 (Other) : 0
## Season4Time x y
## :27 Min. :-79.10 Min. :35.50
## Fri: 9:00 AM-1:00 PM; : 0 1st Qu.:-78.92 1st Qu.:35.74
## Sat: 11:00 AM-2:00 PM;: 0 Median :-78.83 Median :35.82
## Sat: 8:00 AM-12:00 PM;: 0 Mean :-78.77 Mean :35.83
## Sat: 8:30 AM-12:30 PM;: 0 3rd Qu.:-78.61 3rd Qu.:35.95
## Sat: 9:00 AM-2:00 PM; : 0 Max. :-78.35 Max. :36.07
## (Other) : 0
## Location Credit WIC WICcash SFMNP
## :12 N:10 N:20 N:25 N:19
## Private business parking lot : 7 Y:17 Y: 7 Y: 2 Y: 8
## Closed-off public street : 3
## Healthcare Institution : 2
## Local government building grounds: 2
## Other : 1
## (Other) : 0
## SNAP Organic Bakedgoods Cheese Crafts Flowers Eggs Seafood Herbs
## N:20 -: 5 N: 6 N: 9 N: 9 N: 5 N: 9 N:19 N: 5
## Y: 7 N: 7 Y:21 Y:18 Y:18 Y:22 Y:18 Y: 8 Y:22
## Y:15
##
##
##
##
## Vegetables Honey Jams Maple Meat Nursery Nuts Plants Poultry
## N: 4 N: 8 N: 7 N:27 N: 9 N:25 N:15 N: 5 N:11
## Y:23 Y:19 Y:20 Y: 0 Y:18 Y: 2 Y:12 Y:22 Y:16
##
##
##
##
##
## Prepared Soap Trees Wine Coffee Beans Fruits Grains Juices
## N: 8 N: 9 N:18 N:23 N:18 N:25 N: 8 N:24 N:22
## Y:19 Y:18 Y: 9 Y: 4 Y: 9 Y: 2 Y:19 Y: 3 Y: 5
##
##
##
##
##
## Mushrooms PetFood Tofu WildHarvested updateTime
## N:17 N:22 N:26 N:23 11/8/2012 8:10:37 AM : 1
## Y:10 Y: 5 Y: 1 Y: 4 2009 : 1
## 3/19/2015 1:41:06 PM : 1
## 3/19/2015 11:55:01 AM: 1
## 3/19/2015 2:46:17 PM : 1
## 3/19/2015 3:19:10 PM : 1
## (Other) :21
head(req_farmer_stores)
## FMID MarketName
## 217 1011109 Apex Farmers Market
## 1072 1010489 Carrboro Farmers' Market
## 1088 1001607 Cary Downtown Farmers Market
## 1403 1010564 Clayton Farm and Community Market
## 2103 1010872 Duke Farmers Market
## 2104 1009697 Duke Farmers Market at Duke Regional Hospital
## Website
## 217 http://www.apexfarmersmarket.com
## 1072 http://www.carrborofarmersmarket.com
## 1088
## 1403 http://www.cfcmnc.org
## 2103 http://www.hr.duke.edu/benefits/wellness/farmers/index.php
## 2104
## Facebook
## 217 https://www.facebook.com/apexfarmersmarket
## 1072 https://www.facebook.com/carrborofarmersmarket
## 1088
## 1403 https://www.facebook.com/CFCMNC
## 2103
## 2104
## Twitter Youtube OtherMedia
## 217
## 1072
## 1088
## 1403 https://www.twitter.com/ClaytonFarmMkt
## 2103
## 2104
## street city
## 217 220 N. Salem St. Apex
## 1072 301 West Main Street Carrboro
## 1088 Main & Vance Streets Cary
## 1403 348 E. Main Street Clayton
## 2103 Research Drive, Duke University Medical Center Campus Durham
## 2104 3643 N. Roxboro Rd. Durham
## County State zip Season1Date
## 217 Wake North Carolina 27502 04/18/2015 to 10/17/2015
## 1072 Orange North Carolina 27510 04/05/2014 to 10/25/2014
## 1088 Wake North Carolina 27502
## 1403 Johnston North Carolina 27528 04/05/2014 to 10/25/2014
## 2103 Durham North Carolina 27708 04/24/2015 to 09/25/2015
## 2104 Durham North Carolina 27704 05/06/2014 to 09/30/2014
## Season1Time Season2Date
## 217 Sat: 8:30 AM-12:30 PM;
## 1072 Sat: 7:00 AM-12:00 PM; 11/01/2014 to 03/28/2015
## 1088
## 1403 Sat: 9:00 AM-1:00 PM; 11/08/2014 to 03/28/2015
## 2103 Fri: 11:00 AM-2:00 PM;
## 2104 Tue: 3:00 PM-6:00 PM;
## Season2Time Season3Date Season3Time
## 217
## 1072 Sat: 9:00 AM-12:00 PM; 04/09/2014 to 11/19/2014 Wed: 3:00 PM-6:00 PM;
## 1088
## 1403 Sat: 10:00 AM-1:00 PM; 04/04/2015 to 10/31/2015 Sat: 9:00 AM-1:00 PM;
## 2103
## 2104
## Season4Date Season4Time x y Location
## 217 -78.84990 35.73202
## 1072 -79.07772 35.91139
## 1088 -78.87100 35.72870
## 1403 -78.45714 35.65101
## 2103 -78.93923 36.00544
## 2104 -78.89999 36.03596 Healthcare Institution
## Credit WIC WICcash SFMNP SNAP Organic Bakedgoods Cheese Crafts
## 217 N Y N Y N Y Y Y Y
## 1072 N Y N Y Y Y Y Y Y
## 1088 Y N N N N - N N N
## 1403 N N N N N - Y Y Y
## 2103 N N N N N Y Y Y Y
## 2104 Y N N N N N N N N
## Flowers Eggs Seafood Herbs Vegetables Honey Jams Maple Meat Nursery
## 217 Y Y N Y Y Y Y N Y N
## 1072 Y Y Y Y Y Y Y N Y N
## 1088 N N N N N N N N N N
## 1403 Y Y N Y Y Y Y N Y N
## 2103 Y Y N Y Y Y Y N Y N
## 2104 N N N Y Y N N N N N
## Nuts Plants Poultry Prepared Soap Trees Wine Coffee Beans Fruits
## 217 N Y Y Y Y N N Y N Y
## 1072 Y Y Y Y Y Y Y Y N Y
## 1088 N N N N N N N N N N
## 1403 N Y Y Y Y N N N N Y
## 2103 Y Y N Y Y N N Y N Y
## 2104 N Y N N N N N N N Y
## Grains Juices Mushrooms PetFood Tofu WildHarvested
## 217 N N Y Y N N
## 1072 Y N Y N N N
## 1088 N N N N N N
## 1403 N Y N N N N
## 2103 N Y Y N N N
## 2104 N N N N N N
## updateTime
## 217 5/2/2015 3:22:12 PM
## 1072 6/15/2015 4:05:16 PM
## 1088 11/8/2012 8:10:37 AM
## 1403 8/28/2014 6:24:25 PM
## 2103 3/2/2015 9:48:17 AM
## 2104 4/1/2014 9:29:05 AM