Skip to content

Instantly share code, notes, and snippets.

@mjam03
Created February 22, 2021 11:10
Show Gist options
  • Save mjam03/9eb46f472b8b63065f768b2d494b1f54 to your computer and use it in GitHub Desktop.
Save mjam03/9eb46f472b8b63065f768b2d494b1f54 to your computer and use it in GitHub Desktop.
test_17
# merge on dates for {Year, Week} pair, then chronologically sort
df_s_ed = pd.merge(left=df_s_ed, right=df_week_map, how='left', on=['Year', 'Week'])
df_s_ed = df_s_ed.sort_values(['Year', 'Week'])
df_s_ed['Country'] = 'Scotland'
df_s_ed = df_s_ed[['Country', 'Year', 'Week' ,'week_start', 'week_end', 'Deaths']]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment