因为set(df["业务类型"])取得的index值不是按你排序的顺序来的,所以index顺序会乱,需要提取你data1里的index和value进行作图。
import pandas as pd
from pyecharts.charts import Bar
df = pd.read_excel("C:/Users/clw31/Desktop/数据表格.xlsx", sheet_name="Sheet1", header=0)
data1 = df.groupby('业务类型')['订单号'].nunique().sort_values(ascending=False)
index_list = []
value_list = []
for i in data1.index:
index_list.append(i)
for j in data1.values:
value_list.append(int(j))
bar = Bar()
bar.add_xaxis(index_list)
bar.add_yaxis('订单数量', value_list)
bar.render("test2.html")