I have a table in this format
User Material Nota
1 youtube 5
2 facebook 4
3 facebook 3
4 facebook 5
6 youtube 2
7 orkut 3
8 twitter 4
and would like to group so that in the final table shows only sites rated by more than 1 different user
Material User Nota
youtube 1 5
6 2
facebook 2 4
3 3
4 5
My code and my logic
import pandas as pd
df = pd.read_csv("tabela1.csv",delimiter=",")
tabela2= pd.DataFrame({'count' : df.groupby(["Material","User","Nota"]).size()})
del tabela2['count']
tabela2.to_csv('tabela_2.csv')
tabela2 = pd.read_csv("tabela_2.csv",delimiter=",")
But so it lists those that have been evaluated by 1 user, I wonder if there is something in grupby that lists only the different ones to group?
What I thought to do both is 1 fixed in the Material column and in this case counting how many times each material appears after deleting the materials that appear less than twice, to treat materials with less than 1 evaluation, however I believe that for a very large base this will be very costly in time