Python对数据进行可视化展示(甘特图)

# 解析租期,使用datetime和split将时间拆分为横轴坐标

df['开始日期'] = pd.to_datetime(df['租期'].str.split('-').str[0])

df['结束日期'] = pd.to_datetime(df['租期'].str.split('-').str[1])

for i, row in df.iterrows():

    start = row['开始日期']

    end = row['结束日期']

    duration = (end - start).days

    tenant_list = [x.strip() for x in row['租客'].split(',')]

for idx, tenant in enumerate(tenants):

    for _, row in df.iterrows():

        tenant_list = [x.strip() for x in row['租客'].split(',')]

        if tenant in tenant_list:

            start = row['开始日期']

            end = row['结束日期']