示例#1
0
    def get_daily_data(cls, root_path, company_name, unit, year_value,
                       month_value, date_value):
        data_frame = DataFrameFunction.get_data_frame_from_merged_pkl(
            root_path, company_name)
        target_date = datetime(int(year_value), int(month_value),
                               int(date_value))
        data_frame = data_frame[(data_frame['date'] == target_date)]

        result = None
        if unit == '1H':
            result = data_frame.to_json(date_format='iso').replace(
                'T', ' ').replace(':00.000Z', '')

        return json.loads(result)
示例#2
0
    def get(cls, root_path, company_name, unit, from_value, to_value):
        data_frame = DataFrameFunction.get_data_frame_from_merged_pkl(
            root_path, company_name)
        from_values = from_value.split('/')
        to_values = to_value.split('/')
        from_date = datetime(int(from_values[0]), int(from_values[1]), 1)
        to_date = datetime(int(to_values[0]), int(to_values[1]),
                           1) + relativedelta(months=1, days=-1)
        data_frame = data_frame[(from_date <= data_frame['date'])
                                & (data_frame['date'] <= to_date)]

        result = None

        if unit == 'y':
            result = cls.sum_group_by_year(data_frame)
        elif unit == 'ym':
            result = cls.sum_group_by_year_and_month(data_frame)
        elif unit == 'ymd':
            result = cls.sum_group_by_year_and_month_and_date(data_frame)

        return json.loads(result)
示例#3
0
 def count(cls, root_path, company_name):
     data_frame = DataFrameFunction.get_data_frame_from_merged_pkl(
         root_path, company_name)
     return len(data_frame.index)