I have to answer the questions in the script below based on

I have to answer the questions in the script below based on a csv file similar to the picture below. I had to shorten the pictuture because there were over 1000 records, so you only see a few of the records. I have answered the first 7 completed and need help with 8-11.

resdf=pd.read_csv(\'res.csv\',encoding=\'utf8\')
resdf.apply(lambda x: pd.lib.infer_dtype(x.values))

rawdata=resdf.values
rawdata

\"\"\"
question-1: Find how many different zipCode in the table
\"\"\"
zipvar=rawdata[:,1]
zip = np.unique(zipvar)
a=np.count_nonzero(zip)
a

\"\"\"
question-2: Find how many different councilDistrict in the table
\"\"\"
couvar=rawdata[:,3]
cou = np.unique(couvar)
b=np.count_nonzero(cou)
b

\"\"\"
question-3: Find how many different zipCode in the table
\"\"\"
zipvar=rawdata[:,1]
zip = np.unique(zipvar)
c=np.count_nonzero(zip)
c

\"\"\"
question-4: Find how many different policeDistrict in the table
\"\"\"
polvar=rawdata[:,4]
pol = np.unique(polvar)
d=np.count_nonzero(pol)
d

\"\"\"
question-5: Find out which policeDistrict has the largest number of
restaurants. If you got more than one policeDistricts, put them in a list,
e.g. [\'SOUTHERN\',\'NORTHERN\']
\"\"\"
z,indices = np.unique(rawdata[:,4], return_inverse=True)
e=z[np.argmax(np.bincount(indices))]
e

\"\"\"
question-6: Find out which policeDistrict has the largest number of
restaurants. If you got more than one policeDistricts, put them in a list,
e.g. [\'SOUTHERN\',\'NORTHERN\']
\"\"\"
z,indices = np.unique(rawdata[:,4], return_inverse=True)
f=z[np.argmax(np.bincount(indices))]
f

\"\"\"
question-7: Find out which zipCode has the largest number of
restaurants. If you got more than one zipCode, put them in a list,
e.g. [21215,21217]
\"\"\"
z,indices = np.unique(rawdata[:,1], return_inverse=True)
g=z[np.argmax(np.bincount(indices))]
g

\"\"\"
question-8: List all different neighborhood in the SOUTHERN policeDistrict.
Put your answer in a list, e.g. [\'Cherry Hill\', \'Curtis Bay\', \'Federal Hill\']
\"\"\"

\"\"\"
question-9: After finding out all BURGER KING restaurants. Find out in which
policeDistrict, it has more than one BURGER KING restaurants. If you got
more than one policeDistricts, put them in a list,
e.g. [\'SOUTHERN\',\'NORTHERN\'].

NOTE: the name like BURGER KING # 10293 is also a BURGER KING restaurant,
\"\"\"

\"\"\"
question-10: Are there any relplicated names in the location 1 column? If
the answer is yes, put them in a list,
e.g. [\'Hopkins Pl Baltimore, MD\',\'Hayward Ave Baltimore, MD\']. If not, assign
empty list to it.
\"\"\"

\"\"\"
question-11: How many different zipCodes are used in the CENTRAL
policeDistrict?
\"\"\"

\"\"\"
Fill in you answer into the follow structure. e.g.
suppose a=[3 4 5] and b=39
answer={\'question-1\':a,\'question-2\':b}
\"\"\"

answer={\'question-1\':a ,\'question-2\':b ,
        \'question-3\':c ,\'question-4\':d ,
        \'question-6\':e ,\'question-6\':f ,
        \'question-7\':g ,\'question-8\':h ,
        \'question-9\':i ,\'question-10\':j ,
        \'question-11\':k }

\"\"\"
DON\'T CHANGE THE FOLLOWING CODE
\"\"\"
with open(\'myoutput.txt\',\'w\') as outfile:
json.dump(answer,outfile)

nam BREWSTER\'S TAVERN BROADWAY DINER BROOKEYS BROOKLYN BOOSTER CLUB BROOKLYN INN, LLC BROOKLYN PLEASURE CLUB BROTHERS PLACE, INC BRUCE MCKELDIN TING LLC BUD PAOLINOS RESTAURANT BUFFALO WINGGS AND BEER BULL ROBINSON LIQUORS (AKA 2736 GREENMOUNT AV BULLSEYE BAR & GRILLE BURGER KIN BURGER KIN BURGER KIN BURGER KIN BURGER KING 10293 BURGER KING 13360 BURGER KING #10294 BURGER KING #10295 BURGER KING #1950 BURGER KING #2610 BURKE\'S CAFE, INCORPORATED BURKE\'S CAFA/ COMEDY FACTORY BUSTER\'S PUB BUTTS & BETTY STAVERN, INC Zipcode neighborhood councilDistrict policeDistrict Location 1 1 souTHEASTERN 2201 GOUGH ST 21231 Upper Fells Point 1 souTHEASTERN 6501 EASTERN AVE 21224 Pulaski Industrial Area 13 NORTHEASTERN 4201 BELAIR RD 21206 Belair-Edison 21225 Brooklyn 10 SOUTHERN 646 PATAPSCO AVE 21225 Brooklyn 705 PATAPSCO 10 SOUTHERN 21225 Brooklyn 10 SOUTHERN 430 PATAPSCO AVE 9 souTHERN 1846 pRATT ST 21223 Carrollton Ridge 21231 Fells Point 1 souTHEASTERN 702 BROADwAY 2 souTHEASTERN 3919 LoMBARD ST 21224 Baltimore Highlands 3 NORTHEASTERN 7653 HARFORD RD 21234 North Harford Road 12 NORTHERN 21218 Harwood 454 WHITERIDGE AVE 3 NORTHEASTERN 7653 HARFORD RD 21234 North Harford Road 9 souTHERN 21230 Carroll Park 1735 WASHINGTON BLVD 21231 Fells Point 1 souTHEASTERN 2033 EASTERN AVE 4100 PULASKI HWY 11 CENTRAL 8 FAYETTE ST 21202 Downtown 21217 Druid Heights 11 CENTRAL 1201 NORTH AVE 21211 Remington 7 NORTHERN 555 29TH ST 21202 Pleasant View Gardens 12 souTHEASTERN 1241 ORLEANS ST 6 NORTHwESTERN 4400 REISTERSTowNRD 21215 Central Park Heights 21230 Cherry Hill 10 SOUTHERN 1437 PATA PSCO AVE 7 wESTERN 21215 Mondawmin 2401 LIBERTY HEIGHTS AVE 11 CENTRAL 36 LIGHT ST 21202 Downtown 11 CENTRAL 36 LIGHT ST 21202 Downtown 1 souTHEASTERN 3208 LoMBARD ST 21224 Baltimore-Linwood 1 souTHEASTERN 2200 GOUGH ST 21231 Upper Fells Point

I have done from 8 to 11 using data frame.

Feel free to ask any doubt.

\"\"\"
question-8: List all different neighborhood in the SOUTHERN policeDistrict.
Put your answer in a list, e.g. [\'Cherry Hill\', \'Curtis Bay\', \'Federal Hill\']
\"\"\"

list(resdf[\"neighbourhood\"][resdf[\"policeDistrict\"]==\'SOUTHERN\'])

df=pd.DataFrame(resdf[\"policeDistrict\"][resdf[\"name\"]==\'BRUGUR KING\'])
df=pd.DataFrame(df.policeDistrict.value_counts() > 1)
list(df[df[\"policeDistrict\"]==True].index.get_values())

\"\"\"
question-11: How many different zipCodes are used in the CENTRAL
policeDistrict?
\"\"\"
resdf[\"zipCode\"][resdf[\"policeDistrict\"]==\'CENTRAL\'].nunique()

I have to answer the questions in the script below based on a csv file similar to the picture below. I had to shorten the pictuture because there were over 1000

I have to answer the questions in the script below based on

Solution

Get Help Now

Submit a Take Down Notice