Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- data = pd.read_excel('/datasets/seo_data.xlsx', sheet_name='traffic_data')
- data = data[(data['subcategory_id'] != 'total')]
- data['visits'] = data['visits'].astype('int')
- print(data.groupby('source')['visits'].sum())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement