DataFrame ETL

spotifyWrapped.py

msPlayedList = (data['ms_played']).tolist()
est = pytz.timezone('US/Eastern')
utc = pytz.utc
fmt = '%Y-%m-%d %H:%M:%S'
for ind in data.index:
    date = (data['ts'][ind])
    holdTS = datetime(int(date[0:4]), int(date[5:7]),
        int(date[8:10]), int(date[11:13]),
        int(date[14:16]), int(date[17:19]), tzinfo = utc)
    estTS = holdTS.astimezone(est).strftime(fmt)
    data.at[ind, 'ts'] = estTS
dateList = data['ts'].tolist()