Skip to content

Instantly share code, notes, and snippets.

@GurjotSinghMahi
Created February 18, 2021 14:20
Show Gist options
  • Save GurjotSinghMahi/14328c09cfb3e86f36f6543681d95f21 to your computer and use it in GitHub Desktop.
Save GurjotSinghMahi/14328c09cfb3e86f36f6543681d95f21 to your computer and use it in GitHub Desktop.
# Convert Date to respective day name
df['Date'] = (df['Date']).astype('datetime64[D]')
# convert Date to day name
df['old_day'] = df['Date'].dt.day_name()
df['old_date'] = pd.to_datetime(df['Date']).dt.date
df['new_date'] = pd.to_datetime(df['old_date']).dt.date
# increase day by 1 if Sunday and by 2 if Saturday
df.loc[df['old_day'] == 'Sunday', 'new_date'] = df['old_date'] + pd.tseries.offsets.DateOffset(days=1)
df.loc[df['old_day'] == 'Saturday', 'new_date'] = df['old_date'] + pd.tseries.offsets.DateOffset(days=2)
df['new_date'] = pd.to_datetime(df['new_date']).dt.date
df['new_day'] = df['new_date'].astype('datetime64[D]').dt.day_name()
# Print the dataframe
print(tabulate(df[['old_date', 'old_day', 'new_date', 'new_day']], headers = 'keys', tablefmt = 'psql'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment