会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 132603个问题

import xlrd,xlwt
from xlutils.copy import copy

#读取excel
def read_excel():
    #打开excel文件
    read_wb = xlrd.open_workbook('./creat_excel/08count_data.xlsx')
    #获取工作簿
    read_ws = read_wb.sheet_by_index(0)
    #遍历数据集
     #统计
    count_price = []#各水果总价列表
    fen_type = {} #各品级水果总价字典
    for r in range(1,read_ws.nrows):
        count = read_ws.cell_value(r,2)*read_ws.cell_value(r,3)
        count_price.append(count)
        key = read_ws.cell_value(r,0)
        fen_type[key] = count
        if fen_type.get(key):
            fen_type[key] += count
        else:
            fen_type[key] = count
    return count_price,fen_type

#保存数据
def save_excel(count,fen):
    #打开excel文件
    read_wb = xlrd.open_workbook('./creat_excel/08count_data.xlsx')
    read_ws = read_wb.sheet_by_index(0)
    #复制并修改
    new_wb = copy(read_wb)
    new_ws = new_wb.get_sheet(0)
    #总价计算
    for r in range(1,read_ws.nrows):
        new_ws.write(r,4,count[r-1])
    #创建单独工作表
    new_ws2 = new_wb.add_sheet('汇总数据')
    for i,key in enumerate(fen.keys()):
        _type = key
        data = fen.get(key)
        #汇总类和总价
        new_ws2.write(i,0,key)
        new_ws2.write(i,1,data)
    #保存数据
    new_wb.save('./creat_excel/09count_data.xlsx')

if __name__=='__main__':
    c,f = read_excel()
    save_excel(c,f)

执行结果

image.png汇总结果不正确

Python 全系列/ 第十四阶段:自动化操作办公软件、邮件、定时任务等/办公自动化 25217楼
JAVA 全系列/第二十一阶段:分布式医疗云平台/系统管理前后端开发(旧) 25218楼
Python 全系列/第二阶段:Python 深入与提高/模块 25219楼


java.net.ConnectException: Connection refused: connect

at java.base/java.net.DualStackPlainSocketImpl.connect0(Native Method)

at java.base/java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)

at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:400)

at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:243)

at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:225)

at java.base/java.net.PlainSocketImpl.connect(PlainSocketImpl.java:148)

at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:402)

at java.base/java.net.Socket.connect(Socket.java:591)

at org.apache.commons.net.SocketClient.connect(SocketClient.java:182)

at org.apache.commons.net.SocketClient.connect(SocketClient.java:203)

at com.bjsxt.commons.FtpUtil.uploadFile(FtpUtil.java:39)

at com.bjsxt.service.impl.PicUploadServiceImpl.fileUpload(PicUploadServiceImpl.java:49)

at com.bjsxt.web.controller.PicUploadController.fileUpload(PicUploadController.java:31)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:564)

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

at java.base/java.lang.Thread.run(Thread.java:844)

image.png


上传截图出现无法连接的错误,不知道什么原因


JAVA 全系列/(旧的隐藏)第七阶段:JAVA 高级技术/Nginx 25222楼
Python 全系列/第九阶段:Python_Django2 框架(隐藏)/Django视图层 25224楼
Python 全系列/第一阶段:Python入门/编程基本概念 25225楼
JAVA 全系列/(旧的隐藏)第八阶段:电商高级项目_架构/编码/电商ego-基于solr_实现商品数据检索 25226楼
Python 全系列/第一阶段:Python入门/函数和内存分析 25228楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637