import pandas as pd
import numpy as np
import cpca
from cpca import drawer
df_path=".\\N039数据源.xlsx"#纵坐标就是一列 内容
df=pd.read_excel(df_path)#只要前面两列,就把很多其他信息给过滤掉
data = cpca.transform(df["内容"].to_list())#df为上一段代码输出的df
drawer.draw_locations(data[cpca._ADCODE],"df.html")
data.to_excel("N039_自动标记地区_import_cpca.xlsx",index=False)
data
C:\Users\wj\AppData\Local\Programs\Python\Python310\lib\site-packages\requests\__init__.py:109: RequestsDependencyWarning: urllib3 (1.26.9) or chardet (5.0.0)/charset_normalizer (2.0.12) doesn't match a supported version!
warnings.warn(