import pandas
pandas.set_option('display.max_columns', None)
df = pandas.read_excel(r"C:\Users\yr\Documents\WeChat Files\wxid_3b8xebr6yaud22\FileStorage\File\2022-10\spider_data_config.xlsx")

def fun1(s):
    # print(s)
    if type(s) == float:
        return "-"
    else:
        end = int(str(s).find("(")) - 1
        return s[:end]
def fun2(s):
    # print(s)
    if type(s) == float:
        return "-"
    else:

        path = str(s).split("\n")
        if len(path)<2:
            return "-"
        else:
            return path[1]
# df["运行电脑"] = df["运行信息"].map(lambda x:fun1(x))
# df["运行目录"] = df["运行信息"].map(lambda x:fun2(x))
# df.to_excel(r"C:\Users\yr\Desktop\游瑞-2022-8-29-res.xlsx")

t = df[df["日期"]]