text_plain_output_1.png
import pandas as pd

df = pd.read_csv('../input/list-of-indian-satellites/List_of_Indian_satellites.csv', encoding='cp1252')
df

def hlaunch_site(value):
    a = str(value).split(' ')
    if 'Satish' in a:
        return 'Satish Dhawan Space Centre, Sriharikota, Andhra Pradesh'
    else:
        return value
df['launch site'] = df['launch site'].apply(hlaunch_site)
df['launch site'].groupby(df['launch site']).count().sort_values(ascending=False)