时间处理 时间序列
df.index = pd.DatetimeIndex(df.index)
df['date'] = df['time'].dt.date
df["date"] = pd.to_datetime(df['时间'])
df['time'] = df['time'].dt.tz_convert('Asia/Shanghai')
df['time'] = df['time'].dt.strftime("%Y-%m-%d %H:%M:%S")
dc.index = pd.to_datetime(dc.index, format='%Y%m%d', errors='ignore')
pd.DateOffset(days=2)
pd.Timestamp.now()
pd.to_datetime('today')
pd.datetime.today().year == df.start_work.dt.year
df.time.astype('datetime64[ns]').dt.date == pd.to_datetime('today')
import datetime
days = lambda x: datetime.timedelta(days=x)
days(2)
pd.Timedelta(days=2)
pd.to_datetime(ted.film_date, unit='ms')
df.set_index('date').resample('M')['quantity'].sum()
df.set_index('date').groupby('name')['ext price'].resample("M").sum()
df.groupby(by=df.index.date).agg({'uu':'count'})
df.groupby(by=df.index.weekday).uu.count()
df.groupby(['name', pd.Grouper(key='date', freq='M')])['ext price'].sum()
df.groupby(pd.Grouper(key='day', freq='1M')).sum()
df.groupby(['name', pd.Grouper(key='date', freq='A-DEC')])['ext price'].sum()
df['Close'].resample('M').mean()
rng = pd.date_range(start="6/1/2016",end="6/30/2016",freq='B')
df.asfreq('D', method='pad')
df.time.tz_localize(tz='Asia/Shanghai')
df['Time'] = df['Time'].dt.tz_localize('UTC').dt.tz_convert('Asia/Shanghai')
from pytz import all_timezones
print (all_timezones)
df['duration'] = pd.to_datetime(df['end']) - pd.to_datetime(df['begin'])
df.Time.astype('datetime64[ns]') < pd.to_datetime('2019-12-11 20:00:00', format='%Y-%m-%d %H:%M:%S')