OpenApi.py 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. '''
  2. 数据预处理类
  3. '''
  4. __author__ = 'lmstack'
  5. import pandas as pd
  6. import requests
  7. import json
  8. class OpenApi:
  9. def __init__(self):
  10. pass
  11. # def data_split(self, dfin, drive_interval_threshold=120, charge_interval_threshold=300,
  12. # drive_stand_threshold=120, charge_stand_threshold=300,
  13. # default_time_threshold = 300, drive_time_threshold=300, charge_time_threshold=300,
  14. # stand_time_threshold = 1800):
  15. # '''
  16. # 数据分段函数,会调用_data_split_by_status和_data_split_by_time函数。
  17. # 其中_data_split_by_status 将数据分为charge、drive、stand、和none段;
  18. # _data_split_by_time 将每个段内的数据,根据时间跳变继续分段。
  19. # '''
  20. def get_device_fault(self, start_time="", end_time=""):
  21. # start_time = "2021-12-30 00:00:00"
  22. # end_time = "2021-12-31 00:00:00"
  23. url = 'http://open.li-ai.com.cn/admin/v1/deviceFault'
  24. headers = {'Content-Type':"application/json; charset=utf-8","token":"2A26DD0ADE53456D928562A17131A3B5"}
  25. data = {}
  26. if start_time != "":
  27. data['startTime'] = start_time
  28. if end_time != "":
  29. data['endTime'] = end_time
  30. response = requests.post(url, json=data, headers=headers)
  31. df = pd.DataFrame(columns=['sn', 'imei','faultTime', 'updateTime', 'overTime', 'faultStatus', 'questionType', 'questionTypeText', 'childProblem','childProblemText'])
  32. for d in json.loads(response.text)["data"]:
  33. df = df.append(d, ignore_index=True)
  34. return df