Answers for "pandas timestamp to dateimt object"

convert date time to date pandas

df['date_column'] = pd.to_datetime(df['datetime_column']).dt.date

from unix timestamp to datetime pandas

# convert unix timestamp to datetime UTC
df['datetime'] = df['_ts'].map(lambda x: pendulum.from_timestamp(x)) 
df = df.set_index('datetime')
# convert timezone from UTC to GMT+7
df.index = df.index.tz_convert('Asia/Bangkok')