pandas时间处理

# pandas 默认支持的时间点的类型为：timestamp
#     默认支持的时间序列类型为DatetimeIndex
# numpy 默认支持时间类型 datatime64[ns]
# pandas 是封装了numpy

import pandas as pd


# 加载数据
detail = pd.read_excel('meal_order_detail.xlsx')
# print(detail.dtypes)
date = detail['place_order_time']
# print(date)

# 如何将普通的时间序列转化为pandas默认支持的时间序列
# detail['place_order_time'] = pd.to_datetime(date)
# detail['place_order_time'] = pd.DatetimeIndex(date)
# print(date.dtypes)
# print(type(date))

# se = pd.Series(['2019-06-19', '2019-06-20'])
# print(se)
# se = pd.to_datetime(se)
# se = pd.DatetimeIndex(se)
# print(type(se))

# 时间序列操作

# year = [i.year for i in date]
# month = [i.month for i in date]
# day = [i.day for i in date]
# print(year)
# print(month)
# print(day)

# hour, minute, second 都可以通过列表推导式进行获取

# 获取周几
# weekday = [i.weekday_name for i in date]
# print(weekday)

# 获取季度
# quarter = [i.quarter for i in date]
# print(