sponsor_frequency = pd.DataFrame(columns=['Sponsor','Engagement Rate'])

for index, row in sponsored_df[['Sponsor','Engagement Rate']].iterrows():
    for i in row['Sponsor']:
        text = i.replace('@',"")
        if text.isspace():
            continue
        else:
            sponsor_frequency = sponsor_frequency.append(pd.DataFrame({"Sponsor": [text],"Engagement Rate": [row['Engagement Rate']] }))

        
sponsor_frequency.reset_index(drop=True, inplace=True)
s = sponsor_frequency.groupby(['Sponsor']).size().reset_index(name='counts')
s = s.sort_values(by='counts', ascending=False)

fig = px.bar(s.head(20), x='Sponsor', y='counts')
fig.update_layout(title_text='Top 20 Brands that collaborate with Influencer', title_x=0.5)