python(vscode)/데이터프레임 최대/최소 구하기/첫줄/마지막줄

1. 코드작성

import random
import pandas as pd
import datetime
import time
 
ohlcv = {'min_t' : [], 'open':[],'high':[],'low':[],'close':[],'volume':[]}
now = datetime.datetime.now()
start_time = now
 
# 1. 랜덤데이터 만들기 
for i in range(5):
        now = datetime.datetime.now()
        min_t = now 
        open = random.randrange(10000, 22000)
        high = random.randrange(10000, 22000)
        low = random.randrange(10000, 22000)
        close = random.randrange(10000, 22000)
        volume = random.randrange(10000, 22000)
                
        # ohlcv['min_time'].append(min_time.strip())
        ohlcv['min_t'].append((min_t))
        ohlcv['open'].append(int(open))
        ohlcv['high'].append(int(high))
        ohlcv['low'].append(int(low))
        ohlcv['close'].append(int(close))
        ohlcv['volume'].append(int(volume))
        time.sleep(1)
 
#2. 데이터 프레임으로 변환
df = pd.DataFrame(ohlcv, columns=['min_t','open','high','low','close','volume'])
print("\n#2.실행\n",df)
 
#3. 데이터 최대값 최소값 
print("\n#3.실행 - HIGH MAX\n",df['high'].max())
print("\n#3.실행 - LOW MIN\n",df['low'].min())
 
#4. 데이터 첫줄, 마지막줄 출력 
print("\n#4.실행 - open 첫줄\n",df.loc[df.index[0]]['open'])
print("\n#4.실행 - close 마지막줄\n",df.loc[df.index[-1]]['close'])

 

 

2. 결과