use SQL to analyse the data from JSON files.

used to parse:

def cleanStr$4$SQL$($s$)$:

return s$.$replace$("\text{'}","\text{'}\text{'}").$replace$("$

$","")$

def getAttributes$($attributes$)$:

L $=[]$

for $($attribute$,$ value$)$ in list$($attributes$.$items$())$:

if isinstance$($value$,$ dict$)$:

L $+=$ getAttributes$($value$)$

else:

L$.$append$(($attribute$,$value$))$

return L

def parseBusinessData$()$:

print$("$Parsing businesses..."$)$

#read the JSON file

with open$(\text{'}.//$yelp$\_$business.JSON',$\text{'}$r$\text{'})$ as f:

outfile $=$ open$(\text{'}.//$yelp$\_$business.txt$\text{'},\text{'}$w$\text{'})$

line $=$ f$.$readline$()$

count$\_$line $=0$

#read each JSON abject and extract data

while line:

data $=$ json.loads$($line$)$

business $=$ data$[\text{'}$business$\_$id$\text{'}]$ #business id

business$\_$str $="\text{'}"+$ cleanStr$4$SQL$($data$[\text{'}$name$\text{'}])+"\text{'},"+\backslash$

$"\text{'}"+$ cleanStr$4$SQL$($data$[\text{'}$address$\text{'}])+"\text{'},"+\backslash$

$"\text{'}"+$ cleanStr$4$SQL$($data$[\text{'}$city$\text{'}])+"\text{'},"+\backslash$

$"\text{'}"+$ data$[\text{'}$state$\text{'}]+"\text{'},"+\backslash$

$"\text{'}"+$ data$[\text{'}$postal$\_$code'$]+"\text{'},"+\backslash$

str$($data$[\text{'}$latitude$\text{'}])+","+\backslash$

str$($data$[\text{'}$longitude$\text{'}])+",$

examples from each file:

yelp$\_$user:

$\{"$average$\_$stars": $3\mathrm{.}94,$ "compliment$\_$cool": $1556,$ "compliment$\_$cute": $211,$ "compliment$\_$funny": $1556,$ "compliment$\_$hot": $1285,$ "compliment$\_$list": $101,$ "compliment$\_$more": $134,$ "compliment$\_$note": $1295,$ "compliment$\_$photos": $162,$ "compliment$\_$plain": $2134,$ "compliment$\_$profile": $74,$ "compliment$\_$writer": $402,$ "cool": $40110,$ "elite": $[2014,2017,2011,2012,2015,2009,2013,2007,2016,2006,2010,2008],$ "fans": $835,$ "friends": $["$U$\_$sn$0$B$-$HWdTSlHNXIl$\_4$XA$",$ "pnfVIB$7$UhvCQ$7$X$2$K$0$Q$2$XIw", "jVYzrVblDFSuL$3$GHtt$8$ZSA", $"$Z$7$bpqY$89$ZiBHXdo$7$UN$1$kiw", $"8$Aqr$35$f$254$lOeitNowt$7$ig$","$zjcN$27$kCVeK$8$K$2$ONe$9$Qt$4$g$","8$drMKNHWavs$2$g$6$uf$0$pLtvg$","\_$K$2$ViyfmVq$6$nzIitR$0$TIlg", "rUV$1$FUhji$5$xMjNBpcq$5$SXg$",$ "yrGIgk$5$eaWy$-$eewLNv$4$KHQ$","3$Vd$\_$ATdvvuVVgn$\_$YCpz$8$fw$",$ "ebC$\_$pH$92$K$4$uxyDenoXb$5$bg$","$RJrGgtBXkpX$2$oEHM$4$hSqXg$",$ "sdpIz$4-$s$15$T$239$CZ$4$Bd$6$Ag$","$A$0$j$21$z$2$Q$1$HGic$7$jW$6$e$9$h$7$A$",$ "AvC$5$XQAElcGAAn$\_$Wr$5$auEg", $"$JlkHKBnHKdK$8$Tpls$0$AF$5$Aw$","8$AG$5$MctcxTjP$4$svmUrt$0$yQ$","$bKxdvn$7$KpmWjMzlmBvp$-$Xw$","$VVMS$74$JyUk$2$h$53$yfC$-$xNsA", $"-$ro$7$OG$3$jjCSKnF$6$OJinKjg", $"$K$7$thO$1$n$-$vZ$9$PFYiC$7$nTR$2$w$",$ "pRBzWnFzaCEtqhYyJ$2$ZTDQ$",$ "nwESZ$8$e$-$KzXt$2$fKkOuRdIQ", $"$WNZfkL$4$DBspueoGSUOMAqA", $"$uU$6$fQWadr$7$Hx$\_$MP$0$Vmy$3$kQ$",$ "XiLxIJThWsE$0$x$4$d$0$IeSPsg", $"$Y$9$LBTbwO$4$g$0$BmdBIi$0$D$3$CA$","$jGbj$8$fl$575$EIQJcfaA$1$FKQ$","$nxWrhF$\_$hyX$0$wwjrEkQX$8$uQ$","670$k$6$Gr$6$V$4$VqLIKtVEmDuQ", $"$o$5$STsEtfvD$1$Ig$0$J$7$Z$-1$uxA", $"$x$13$yoEggBL$0$pIE$7-$KMnhDQ$","$rCx$7$tb$3$toOJUsvdOeqYY$0$g$","$nkN$\_$do$3$fJ$9$xekchVC$-$v$68$A$","$KzHRsFwryS$7$b$5$Fog$8$kkkGA", $"\_$pBzBgtCTN$9$PNUPfgPDI$8$A$","$PU$5$QaMADa$6$N$\_9$ZoQ$04$ZjOw", "FkfpHzqoDRChwOYhA$6$NPnQ$",$ "CaQy$-$zz$10$ajG$7$KkNSbXi$5$w$","$brQ$7$OjB$6$f$9$nXWGk$45$A$9$A$3$g$"],$ "funny": $10882,$ "name": "Andrea", "review$\_$count": $2559,$ "useful": $83681,$ "user$\_$id$"$: $"$om$5$ZiponkpRqUNa$3$pVPiRg", "yelping$\_$since": $"2006-01-18"\}$

yelp$\_$checkin:

$\{"$time$"$: $\{"$Friday$"$: $\{"20$:$00"$: $2,"19$:$00"$: $1,"22$:$00"$: $10,"21$:$00"$: $5,"23$:$00"$: $14,"0$:$00"$: $2,"18$:$00"$: $2\},$ "Thursday": $\{"23$:$00"$: $1,"0$:$00"$: $1,"19$:$00"$: $1,"18$:$00"$: $1,"16$:$00"$: $2,"22$:$00"$: $2\},$ "Wednesday": $\{"17$:$00"$: $2,"23$:$00"$: $3,"16$:$00"$: $1,"22$:$00"$: $1,"19$:$00"$: $1,"21$:$00"$: $1\},$ "Sunday": $\{"16$:$00"$: $2,"17$:$00"$: $2,"19$:$00"$: $1,"22$:$00"$: $4,"21$:$00"$: $4,"0$:$00"$: $3,"1$:$00"$: $2\},$ "Saturday": $\{"21$:$00"$: $4,"20$:$00"$: $3,"23$:$00"$: $10,"22$:$00"$: $7,"18$:$00"$: $1,"15$:$00"$: $2,"16$:$00"$: $1,"17$:$00"$: $1,"0$:$00"$: $8,"1$:$00"$: $1\},$ "Tuesday": $\{"19$:$00"$: $1,"17$:$00"$: $1,"1$:$00"$: $2,"21$:$00"$: $1,"23$:$00"$: $3\},$ "Monday": $\{"18$:$00"$: $2,"23$:$00"$: $1,"22$:$00"$: $2\}\},$ "business$\_$id$"$: "dwQEZBFen$2$GdihLLfWeexA"$\}$

yelp$\_$review.json:

$\{"$review$\_$id$"$:$"$ClgrKJ$6$dqiM$7$vSKJBJ$2$w$6$Q$",$"user$\_$id$"$:$"$T$5$MGS$0$NHBCWgofZ$6$Q$6$Btng$",$"business$\_$id$"$:"dwQEZBFen$2$GdihLLfWeexA","stars":$4,$"date":"$2013-06-03",$"text":"I've been here at least $5$ times now and each time is better than the last. I Iove what they have done to improve the building and add outdoor dining. Service is always good here and on par with other top places in Mentor. I really suggest the chicken soup on a cold day it's very yummy! Everything I've had on the menu has been great.","useful":$0,$"funny":$0,$"cool":$0\}$

yelp$\_$business.json:

$\{"$business$\_$id$"$: $"$xmY$0$pzNvZKEzuN$0$XEqeV$5$w