Django ORM Datetime¶

일반적 ORM 객체등은 원칙적 datetime.dateime 객체이다
datetime.date 객체로만 관리되면 문제가 없지만
datetime.datetime 에서 date 만 활용하는 경우에도 시간대가 다르면 날짜도 다르게 출력
Pandas Datetime Index 객체 는 추가적 편리한 메소드들을 제공

1 tzinfo Convert : datetime¶

In [1]:

# Django ORM 데이터 tz_info 변경 및 확인
# Django DateTime => datetime.datetime 객체를 출력
import pytz
seoul = pytz.timezone("Asia/Seoul")
# time_check = PriceKRX.objects.all().last().datetime
# time_check.replace(tzinfo=seoul)

2 tzinfo Convert : pd.DataFrame¶

In [ ]:

# DataFrame 의 tz_info 변경
import pytz
import pandas as pd
seoul = pytz.timezone("Asia/Seoul")
# df.datetime = list(map(
#     lambda x : seoul.localize(x), 
#     df.datetime.tolist())
# )

In [ ]:

import pytz
from krxstock.shinhan import get_invest
seoul = pytz.timezone("Asia/Seoul")
df = get_invest("005930")
df["시간"][0].replace(tzinfo=seoul)

# from krx.tasks import get_trading_invest
# get_trading_invest()

In [ ]:

from glob import glob
from krx.tasks import get_trader_price
# files = glob("../jupyter/data/trade/csv/*.*")
# get_trader_price(files[0])

Python Datetime¶

1 tzinfo Convert : datetime¶

In [1]:

import datetime
timestamp = 1528797322
date_time = datetime.datetime.fromtimestamp(timestamp)
print( date_time.strftime("%m/%d/%Y, %H:%M:%S") )
print( date_time.strftime("%d %b, %Y") )
print( date_time.strftime("%d %B, %Y") )

06/12/2018, 18:55:22
12 Jun, 2018
12 June, 2018

In [4]:

# datetime 모듈의 활용
import datetime
print( datetime.datetime.today().strftime('%Y-%m-%d') )
print( datetime.datetime(year=2000, month=1, day=1) )
print( datetime.datetime.strptime('09/19/18 13:55:26', '%m/%d/%y %H:%M:%S') )
datetime.datetime.today() - datetime.timedelta(days=7)

2022-02-11
2000-01-01 00:00:00
2018-09-19 13:55:26

Out[4]:

datetime.datetime(2022, 2, 4, 10, 42, 4, 776721)

In [1]:

from datetime import datetime
dateString = "7-May-2018"
dateFormatter = "%u-%b-%Y"
datetime.strptime(dateString, dateFormatter)

Out[1]:

datetime.datetime(2018, 5, 1, 0, 0)

In [5]:

time_text = '2019.12.13.AM 00:00'
import pandas as pd
pd.to_datetime(time_text, format='%Y.%m.%d.%p %H:%M').strftime('%Y-%m-%d %H:%M')

Out[5]:

'2019-12-13 00:00'

2 Lambda¶

In [6]:

# Check if given numbers are in range using lambda function
test = lambda x : True if (x > 10 and x < 20) else False
print(test(12))
print(test(3))
print(test(24))

# https://thispointer.com/python-how-to-use-if-else-elif-in-lambda-functions/
# https://stackoverflow.com/questions/60261960/how-to-use-lambda-if-else-in-map-on-list-in-python
list(map(lambda x : 'ok' if x == "apple" else None, ['apple', 'banana', 'cherry']))

True
False
False

Out[6]:

['ok', None, None]

In [1]:

test = {
    "A":1,
    "B":2,
}

In [7]:

test.get("d", 10)

Out[7]:

In [3]:

test

Out[3]:

{'A': 1, 'B': 2}