Filter Dataset from a groupby

Question

I have the following dataframe (df_reviews) and need to remove the App versions that were downloaded less than 10 times and tried to do the steps below and a for to perform the filter on the original dataset, but I was not successful Down I put the step-by-step of my way...

By "App Version Name" I made a filter to evaluate how many times each version was downloaded:

App_version = df_reviews.groupby('App Version Name').agg({'Star Rating': ['mean', 'min', 'max', 'count']})

And the result was this:

After that I created a condition to clean up df_reviews, where the version with less than 10 downloads should be dropped from df:

condicao1 = df_reviews['App Version Name'].value_counts() < 10

And to filter df_reviews, I made a for to remove lines whose version has less than 10 downloads, but the for is not working.

for i in range (0, df_reviews.shape[0]):#buscando em linha por linha
    if df_reviews.at[i, "App Version Name"] == condicao1:#serve para acessar o label
        df_reviews['Teste1'] = df_reviews['Teste1'].append(condicao1.loc[[i]])```

Answer 1

Try

df_reviews[df_reviews['App Version Name'].isin(condicao1[condicao1 == False].index)]

That chooses the names that are among those that are False in condicao1. - Jorge Mendes 1 hour ago

by Jorge Mendes: /users/150167/jorge-mendes