pd.pivot_table(logs_filtered, index['Full URL']) For greater specificity, the required values can be declared and aggregations – sum, mean, etc – applied using the aggfunc parameter.