import pandas as pd
import numpy as np
path = '产业布局-企业.xlsx'
# 详情页链接
title = pd.read_excel(path, usecols=[2])
title_arr = np.asarray(title.stack()) # Dataframe类型堆叠变成Series类型再转成numpy数组
title_list = title_arr.tolist()
print(title_list)
import pandas as pd
import numpy as np
path = '产业布局-企业.xlsx'
# 详情页链接
title = pd.read_excel(path, usecols=[2])
title_arr = np.asarray(title.stack()) # Dataframe类型堆叠变成Series类型再转成numpy数组
title_list = title_arr.tolist()
print(title_list)