Percentage of Video Game Genres in Spyder

Question

I want to show the percentage of various genres in my code with the date set and it is giving a following error:

Valueerror: Lengths must match to compare

The part that has the error in my code is like this, help me find the error

base = pd.read_csv ('gamestest.csv')
#base.Platform (a tabela excel possui uma coluna Platform)

porcen = base.DataFrame(base.Genre.unique())
totalPorcPlat = len(base)

for porc in porcen:
    contagemPorcen = base[base.Genre]==porcen].shape(0)
    print ('{}: {:0.2f}%'.format(porcen, contagemPorcen * 100/ totalPorcPlat))

Answer 1

Given a list, lista = ['plataforma 1', 'plataforma 1', 'plataforma 2']

When we do:

for valor in lista:
    print(valor)

The exit is:

plataforma 1
plataforma 1
plataforma 2

In your code is:

for porc in porcen:
    contagemPorcen = base[base['Platform']==porcen].shape(0)
    print ('{}: {:0.2f}%'.format(porcen, contagemPorcen * 100/ totalPorcPlat))

But the correct one would be to use the variable porc (list value) instead of porcen (entire list):

for porc in porcen:
    contagemPorcen = base[base['Platform']==porc].shape(0)
    print ('{}: {:0.2f}%'.format(porc, contagemPorcen * 100/ totalPorcPlat))

Still, there is another error. Instead of .shape(0), the correct is .shape[0].

EDIT

To list in order, you need to store all values, sort and then show.

lista_porcentagens = []
for porc in porcen:
    contagemPorcen = base[base['Platform']==porc].shape[0]
    lista_porcentagens.append((contagemPorcen * 100/ totalPorcPlat, porc))

#ordenar a lista do maior para o menor    
lista_porcentagens.sort(reverse=True)
#printar os valores
for porcentagem, plataforma in lista_porcentagens:
    print ('{}: {:0.2f}%'.format(plataforma, porcentagem))