Skip to content

Instantly share code, notes, and snippets.

@saksters

saksters/group-gsc-dates-to-week.py

Created March 15, 2021 19:46
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save saksters/39ff4b4e698e550b0aef7198c22914af to your computer and use it in GitHub Desktop.
Save saksters/39ff4b4e698e550b0aef7198c22914af to your computer and use it in GitHub Desktop.
Download ZIP
Groups GSC daily clicks together into weekly intervals from Sunday to Saturday
Raw
group-gsc-dates-to-week.py
import pandas as pd
df = pd.read_csv('Dates.csv')
df['Date'] = pd.to_datetime(df.Date)
df_week = df.resample('W-SAT', on='Date').Clicks.sum()
df_week.to_csv('export.csv')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment