Aggregating the total count of translations initiated by analyzing page query strings

import pandas as pd

trnsltd = pd.read_csv('/home/mlncn/Nextcloud/agaric-nextcloud/agaric/clients/FindItCambridge/analytics/translated-pages-20200614-20210615.csv', thousands=',')

trnsltd.drop(columns = ['Avg. Time on Page', 'Entrances', 'Bounce Rate', '% Exit', 'Page Value'], inplace=True)
cols = trnsltd.columns.drop('Page')
pattern = '.+\?language=([a-z][a-z]).*'
language = trnsltd.Page.str.extract(pattern, expand=True)
trnsltd['Language'] = language
"trnsltd.drop(columns = [], inplace=True)"

languages = trnsltd.groupby('Language').agg({'Pageviews': 'sum', 'Unique Pageviews': 'sum'})
sorted_languages = languages.sort_values(by='Pageviews', ascending=False)

See https://gitlab.com/agaric/python/site-analytics/-/blob/main/translations-initiated.py for everything in the current script.