# convert timezone from UTC to GMT+7 df['timestamp'].map(lambda x: pd.to_datetime(x, yearfirst=True).tz_convert('Asia/Bangkok'))