Skip to content

Instantly share code, notes, and snippets.

@GurjotSinghMahi
Created February 18, 2021 16:20
Show Gist options
  • Save GurjotSinghMahi/ac66547c9bc870e919b571556f062d75 to your computer and use it in GitHub Desktop.
Save GurjotSinghMahi/ac66547c9bc870e919b571556f062d75 to your computer and use it in GitHub Desktop.
# read the csv file and parse the dates
df = pd.read_csv("raw_data.csv", parse_dates=['SubmissionDate', 'starttime', 'endtime'])
df['Time'] = pd.to_datetime(df['SubmissionDate']).dt.time
#print(df['Time'].dtype)
# increase hours by 2
df['increased_hours'] = df['SubmissionDate'] + pd.tseries.offsets.DateOffset(hours=2)
# increase minutes by 20
df['increased_minutes'] = df['SubmissionDate'] + pd.tseries.offsets.DateOffset(minutes=20)
# increase seconds by 40
df['increased_seconds'] = df['SubmissionDate'] + pd.tseries.offsets.DateOffset(seconds=40)
# Convert respective columns in datetime format and extract time only
df['increased_hours'] = pd.to_datetime(df['increased_hours']).dt.time
df['increased_minutes'] = pd.to_datetime(df['increased_minutes']).dt.time
df['increased_seconds'] = pd.to_datetime(df['increased_seconds']).dt.time
df['original_time'] = pd.to_datetime(df['SubmissionDate']).dt.time
# Print the dataframe
print(tabulate(df[['original_time', 'increased_hours', 'increased_minutes', 'increased_seconds']], headers = 'keys', tablefmt = 'psql'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment