Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- data_final = pd.read_csv('/datasets/data_final.csv')
- data_pivot = data_final.pivot_table(index=['category_name', 'subcategory_name'], columns='source', values='visits', aggfunc='sum')
- data_pivot['ratio'] = data_pivot['organic'] / data_pivot['direct']
- data_pivot.loc[data_pivot['direct'] > 1000]
- print(data_pivot.sort_values(by='ratio',ascending=False).tail(10))
-
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement