I have an Excel file with a column that contain both date and time in a single cells as follows:
I'm wondering how to extract this cell, split date and time (that are separated by a "T") and write them into 2 new columns "Date" and "Time", and able to use them afterwards to, for example, do Time math operations.
I'd have a start from pandas:
df = pd.read_excel('file.xlsx') def convert_excel_time(excel_time): return pd.to_datetime()
but I actually don't know if it is achievable with pandas.
If I have this:
I would like to calculate how many minutes passed (for the same date) for the same ID column (2nd column).
I guess I can use python tdelta, or is there a pandas alternative?