Ejercicio - Fechas y Horas - Solución

import pandas as pd

df = pd.read_csv("OrdonezA_ADLs.txt", sep="\t", skiprows = [1], index_col = None)
df.reset_index(inplace=True)
df

df.columns

colnames = df.columns.tolist()
colnames

cols_to_remove = list()

for name in colnames:
    if name.startswith("level"):
        cols_to_remove.append(name)
        
cols_to_remove    

# Forma extendida
clean_colnames = list()
for name in colnames:
    if name not in cols_to_remove:
        clean_colnames.append(name)
clean_colnames

# Forma condensada
clean_colnames = [name for name in colnames if name not in cols_to_remove]
clean_colnames

clean_colnames.remove("Unnamed: 3")
clean_colnames

cadena1 = 'Start time          '

cadena1.rstrip()

clean_colnames = [name.rstrip() for name in clean_colnames]
clean_colnames

df.dropna(axis = 1, how="all", inplace=True)
df

df.columns = clean_colnames
df

df.dtypes

df['Start time'] = pd.to_datetime(df['Start time'])
df['End time'] = pd.to_datetime(df['End time'])
df.dtypes

df['Extracted_start_date'] = df['Start time'].dt.date
df['Extracted_start_time'] = df['Start time'].dt.time
df

df['Extracted_end_date'] = df['End time'].dt.date
df['Extracted_end_time'] = df['End time'].dt.time
df

df.drop(columns = ["Start time", "End time"], inplace=True)
df