chanelcolgate / hydroelectric-project

0 stars 0 forks source link

Lấy dữ liệu phụ tải và giá biên #26

Open PhanDuyLinh opened 2 years ago

PhanDuyLinh commented 2 years ago

import requests
from datetime import date, timedelta
import datetime
from time import sleep
import pandas as pd
from itertools import repeat

payload = {}
headers = {}
phuTaiList = []
giaBienList = []
dateTimeList = []

sdate = datetime.datetime(2021, 1, 1, 0, 0, 0)   # start date
edate = datetime.datetime(2021, 10, 27, 0, 0, 0)   # end date

delta = edate - sdate       # as timedelta

for i in range(delta.days + 1):
    day = sdate + timedelta(days=i)
    url = "https://www.nldc.evn.vn/Chart24hHandle.ashx?d=" + day.strftime('%d/%m/%Y') + "&isChangeDate=0"
    response = requests.request("GET", url, headers=headers, data=payload)
    sleep(0.5)
    data = response.json()

    b = day
    for x in range(48):
        dateTimeList.append(b.strftime("%m/%d/%Y %H:%M:%S")) #
        b = b + datetime.timedelta(seconds=1800)

    phuTaiList = phuTaiList + data['data'][0]
    giaBienList = giaBienList + data['data'][1]

Dict = {'phuTai': phuTaiList, 'giaBien': giaBienList, 'DateTime': dateTimeList}
data2 = pd.DataFrame.from_dict(Dict)
print(data2)
#data2.to_csv("PhuTai_GiaBien.csv")```