Advertisement
AlexErin1308

Task #12

Mar 6th, 2024
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.24 KB | Source Code | 0 0
  1. import pandas as pd
  2.  
  3. data = pd.read_excel('/datasets/seo_data.xlsx', sheet_name='traffic_data')
  4. data = data[(data['subcategory_id'] != 'total')]
  5. data['visits'] = data['visits'].astype('int')
  6.  
  7. print(data.groupby('source')['visits'].sum())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement