Need help on group by function.

[Sree]

Hi Guru's,

i am beginner of Python. i am struck with converting "R" script(below) into Python.

total_sales = sum(transactions['PureSales'])

job_roles <- transactions %>%
group_by(JobRole,job_classification) %>%
summarise(
     order_lines = n(),
     prop_order_lines = order_lines/nrow(transactions),
    orders = n_distinct(OrderNumber),
    sales = sum(PureSales),
    prop_sales = sum(PureSales)/total_sales
  ) %>%
ungroup

Could you please help, i can i write same code in python?


thanks a bunch in advance.

Sree.