1、python实现字典(json)修改值
json={"name":"张张","age":28,"msg":{"Province":"河南","City":"郑州"}}
json["name"]="王盈"
json["age"]=30
json["msg"]["City"]="信阳"
print(json)
print(type(json))
2、python实现删除redis数据
import redis
host="你的redis_host"
port=8888
password="你的redis_password"
db="你要清除哪个db的数据"
if __name__ == '__main__':
redis_pool = redis.ConnectionPool(host=host, port=port,password=password,db=db)
redis_client = redis.Redis(connection_pool=redis_pool)
redis_client.flushdb()
3、python实现读取excle数据
import pandas as pd
if __name__ == '__main__':
io = r'你excle文件所在的路径'
data = pd.read_excel(io,sheet_name='你的数据所在的sheet名',header=0,dtype='str')
excel_list=data.values.tolist()
print(excel_list)