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