py,riqi

目录

# -*- coding: utf-8 -*-
"""
Created on Wed Dec 15 20:51:04 2021

@author: 62669
"""

import numpy as np
import pandas as pd
import datetime

today = datetime.date.today()
type(today)
a=str(today)

now = datetime.datetime.now()
print(type(now))

t1 = datetime.datetime(2019,10,22)

t2 = datetime.datetime(2019,10,22,11,45,36)

t2-t1

print( t2-t1 )

tx = datetime.timedelta(100)

print(t2-tx)

from dateutil.parser import parse

date ='20170501'
date2 ='21/12/2019'

print(parse(date),type(parse(date)))

########pandas timestamp

date2 ='21/12/2019'
t1 = pd.Timestamp(date2)

t2 = pd.to_datetime(date2)

date3 =['21/12/2019','22/12/2019','23/12/2019','aa']
a = pd.to_datetime(date3,errors='ignore')
print(pd.to_datetime(date3,errors='ignore'))
print(pd.to_datetime(date3,errors='coerce'))
print(pd.to_datetime(date3,errors='ignore'))


ex = pd.date_range('2000-1-1', periods=1000, freq='M')
print(ex)

ex.date

#6字符串转换成datetime格式: strptime
df_data1  = pd.DataFrame(columns=['date','values'])
df_data1['date'] = ['2019-01-01','2019-01-02','2019-01-03','2019-01-04','2019-01-05']
df_data1['values'] = np.random.randn(5)

type(df_data1['date'][2])

df_data1['date1'] = df_data1['date'].map(lambda x:datetime.datetime.strptime(x,'%Y-%m-%d'))
df_data1
df_data1.info()

#6datetime变回string格式: strftime
df_data  = pd.DataFrame(columns=['date','values'])
df_data['date'] = pd.date_range('2019/01/01',periods=5)
df_data['values'] = np.random.randn(5)
df_data

df_data.info()

df_data['date1'] = df_data['date'].apply(lambda x:x.strftime('%Y-%m')) #datetime格式转成str