import pandas as pd 
import json

data = pd.read_excel("新普惠水肥.xlsx")
data = data.fillna(0)
# 将数据转换为字典
data_str = data.applymap(lambda x: str(x) if isinstance(x, float) else x)
dict_data = data_str.to_dict(orient='records')
result = {}
for i in dict_data:
    result[str(i.get("index"))] = i
with open("xph_ele.json", "w", encoding="utf-8") as k:
    json.dump(result, k, ensure_ascii=False, indent=4)