from functions.feishu import Feishu


def find_yesterday_data(column_index):
    """
    根据 column_index来获取前一天的数据
    :param column_index:
    :return:
    """
    F = Feishu("ZYNBsZ5lPhsKFltb6ghclfJqngb")
    data = F.search_value(
        sheet_id="eb6d24", ab="{}6:{}6".format(column_index, column_index)
    )
    return data["data"]["valueRange"]["values"][0][0]