程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
您现在的位置: 程式師世界 >> 編程語言 >  >> 更多編程語言 >> Python

JSON type related errors in Python

編輯:Python
The phenomenon and background of the problem

take excel Data import , And want to use it echarts Visualizing , There was a mistake

class MyEncoder(json.JSONEncoder):
def default(self, obj):
if isinstance(obj, bytes):
return str(obj, encoding='utf-8')
return json.JSONEncoder.default(self, obj)

@app.route('/')
def get_data():
# Read excel data
import pandas as pd
io=r'C:\Users\86137\Desktop\python\2020 Water resources .xlsx'
work_book = pd.read_excel(io,sheet_name=0,index_col=[0],usecols=[0,4],skiprows=[0,1,2,3,4])
category=work_book.index
value = work_book.values
data={'category':category,'value':value}
return json.dumps(data,ensure_ascii=False,cls=MyEncoder, indent=4)

Operation results and error reporting contents

TypeError: Object of type Index is not JSON serializable

My solution ideas and tried methods

Added MyEncoder, But the same mistake

What I want to achieve

  1. 上一篇文章:
  2. 下一篇文章:
Copyright © 程式師世界 All Rights Reserved