Question

how would i do this? thanks

Download the following file: top series.csv Move it to Python working folder The archive contains a list of movies and their genre. Prints a list of all the genres that exist in the archive with the number of movies of each of the genres. Example: top_movies.csv: movie, genre Beauty and The Beast, Romance Harry Potter, Adventure The Notebook, Romance Display Genre: Romance - Quantity: 2 Genre: Adventure - Quantity: 1

Answer 1

Code:

import csv  #importing csv module
top_movies = open("top_movies.csv") #opening csv file in read mode
csv_reader = csv.DictReader(top_movies) #getting the DictReader object
#DictReader object yields every row as a dictionary so that you can access
#values of the row by using their column headings
#One thing to be noted is while writing the headings of csv files there must
#be no spaces before or after "," . And if spaces are there then the heading
#also includes spaces so then the key of dictionary also adds spaces
#so avoid common mistake of writing spaces before and after "," while
#separating values in csv file.
genres = [] #list to store the genres
counts = [] #list to store the counts of respective genres
for row in csv_reader:  #for every row in the csv file
    if row["genre"] not in genres:  #if a genre is not in genres list
        genres.append(row["genre"]) #appending it to genres list
        counts.append(0)            #and also appending 0 to store count 
    index = genres.index(row["genre"])  #gets the index of genre in genres list
    counts[index] += 1  #and a count of 1 is added to that respective index
for i in range(len(genres)):    #printing all genres and their counts
    print("Genre:", genres[i], "- Quantity:", counts[i])

Code Screenshot:

Output:

top_moves.csv:

Each and everything is explained clearly in the comment section of the code.

Thank you! Hit like if you like my work.