Skip to content

Instantly share code, notes, and snippets.

@alcheng10
Created February 9, 2020 09:25
Show Gist options
  • Save alcheng10/a7be3e3e76632eb7046d0801c7329123 to your computer and use it in GitHub Desktop.
Save alcheng10/a7be3e3e76632eb7046d0801c7329123 to your computer and use it in GitHub Desktop.
# With your date dimension in df_date, join up and filter
data = df_date.join(data.set_index('Date'), how='left')

# Show all empty rows after the LEFT JOIN
data[data.isnull().any(axis=1)]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment