| 12345678910111213 |
- 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)
|
