You can easily use :
len(df['name'].unique())
it will give how many unique value is in the name column.
how to count number of firms in one column? [closed]
You can easily use :
len(df['name'].unique())
it will give how many unique value is in the name column.