Use pandas apply to run a function across rows, columns, Series values, or groups. With grouped data, it processes each group separately, making it useful for turning detailed records into dashboard-ready summaries. section 6.5.1
Aggregate daily sales
Group records by Day, then sum Sales within each group: grouped = df.groupby('Day'); data = grouped.apply(lambda df: df['Sales'].sum(), include_groups=False).reset_index(). The function receives one day's rows, while include_groups=False prevents it from operating on the group label. reset_index() restores Day as a regular column. section 6.5.1


