Question

Define a Python function named borough_count that has one parameter. The parameter is a string representing the name of a CSV file. The CSV file is a subset of NYC's dataset of all film permits issued since April 2016. Each row in the CSV file has the format: Event Id, Police Precinct(s), Event Type, Borough, Category Your function must return a dictionary. The keys of this dictionary will be the boroughs read in from the file (boroughs are at index 3). The values in the dictionary will be a list containing the event ids of the permits (records) issued for that boroughs (event id are at index 0). To do this, you will need to use a CSV reader to read in the file and process it row-by-row. Data for police precinct(s) may include commas, so it is important you use the build-in CSV libraries. (Hint: When processing a row, the borough may not have been added as a key to your accumulator. Using Dictionary's get function allows you to retrieve a borough's list (if it is already a key) OR specify an empty list if it is not.) Sample test cases: borough_count ("empty.csv") would evaluate to { } (finds bug if accumulator variable not initialized correctly) borough_count("simple.csv') would evaluate to { 'Bronx': ['244863', 446401'], 'Queens': ['186438'] } (finds bug if accumulator variable not updated correctly)

Define a Python function named borough_count that has one parameter. The parameter is a string representing the name of a CSV file. The CSV file is a subset of NYC's dataset of all film permits issued since April 2016. Each row in the CSV file has the format:
Event Id, Police Precinct(s), Event Type, Borough, Category
Your function must return a dictionary. The keys of this dictionary will be the boroughs read in from the file (boroughs are at index 3). The values in the dictionary will be a list containing the event ids of the permits (records) issued for that boroughs (event id are at index 0). To do this, you will need to use a CSV reader to read in the file and process it row-by-row.
Data for police precinct(s) may include commas, so it is important you use the build-in CSV libraries.
(Hint: When processing a row, the borough may not have been added as a key to your accumulator. Using Dictionary's get function allows you to retrieve a borough's list (if it is already a key) OR specify an empty list if it is not.)

Sample test cases:
borough_count("empty.csv") would evaluate to { } (finds bug if accumulator variable not initialized correctly)
borough_count("simple.csv") would evaluate to { 'Bronx' : ['244863','446401'], 'Queens' : ['186438'] } (finds bug if accumulator variable not updated correctly)

Answer 1

PYTHON CODE:

def borough_count(file_name):
import csv

file = open(file_name,'r')
reader = csv.reader(file)
my_Dict = {}
for rows in reader:
if rows[3] in my_Dict:
my_Dict[rows[3]] += [rows[0]]
else:
my_Dict[rows[3]]=[rows[0]]
print(my_Dict)

def main():
  
borough_count('empty.csv')
borough_count('simple.csv')
if __name__ == '__main__':
main()

I hope this might help you and don't forget to give UPVOTE as it means a lot, Thanks:)