Python Converting Datetime into an integer

Question

I have an excel document with two columns, one of which is labelled "YYYY/MM/DD" and the other "HH:MM:SS." I then combined the two columns to make a "datetime" column that outputs the text "YYYY/MM/DD HH:MM:SS"

df['datetime'] = df['YYYY/MM/DD'].astype(str) + ' ' + df['HH:MM:SS'].astype(str) 
df['datetime'] = pd.to_datetime(df['datetime'])

Now I want to convert datetime to an integer but am having no luck. This is what I have tried to do:

df['wtime'] = int(float(df['datetime']))

I just want an integer value returned so I can eventually get the start and end time of the data set.

Answer 1

Try this:

import datetime
current_date = datetime.datetime.now()
print("String Format of Current Date and Time:", current_date)
# String Format of Current Date and Time: 2022-11-16 13:19:43.211656

Or

curr_date_str = str(current_date)
curr_date_strip = curr_date_str.split('.')[0]
curr_date_strip = curr_date_strip.replace(':', '')
curr_date_strip = curr_date_strip.replace('-', '')
curr_date_strip = curr_date_strip.replace(' ', '')
print("Stripped Format of Current Date and Time:", int(curr_date_strip))
# Stripped Format of Current Date and Time: 20221112200439