python常用代码

python常用代码

1.excel某一列转为list

def excel_one_line_to_list(standard_anytunnel):
    result = []
    df = pd.read_excel(standard_anytunnel, usecols=[9], names=None)  # 读取第9列，不要列名
    df_li = df.values.tolist()

    for s_li in df_li:
        result.append(s_li[0])
    return result

2.实现vlookup功能

def add_vip_status(src_File, des_Flie):
    df_grade = pd.read_excel(src_File)
    df_grade.head()
    df_sinfo = pd.read_excel(des_Flie)
    df_sinfo.head()
    # 筛选第二张表少量列
    df_sinfo = df_sinfo[["any_tunnel_vip", "status"]]
    df_sinfo.head()
    df_merge = pd.merge(left=df_grade, right=df_sinfo, left_on="vip", right_on="any_tunnel_vip")
    df_merge.head()
    df_merge.to_excel("result.xls", index=False)

python常用代码

原文：https://www.cnblogs.com/TaoLeonis/p/14537116.html