什么网站做免单衣服,厦门设计师网站,网站建设太金手指六六十一,如何写一个apppandas和SQL数据分析实战视频教程统计excel C列 化学 和D列 补充申请 两个条件药品数量程序优势在于批量统计#xff0c;把参数写到excel里#xff0c;行为单位# -*- coding: utf-8 -*-Created on Thu Apr 7 08:38:51 2016content内容必须是逗号分隔把参数写到excel里行为单位# -*- coding: utf-8 -*-Created on Thu Apr 7 08:38:51 2016content内容必须是逗号分隔例如化药,中药用于统计excel--sheet---二级条件筛选的数据统计算法1.读取所有excel内容保存到二维列表中2.二级筛选author: Administratorimport csv,xlrd,os,openpyxl#获取所有excel文件名def Get_excelFileNames():excelFiles_list[]for excelFilename in os.listdir(.):if excelFilename.endswith(.xlsx) or excelFilename.endswith(.xls):excelFiles_list.append(excelFilename)return excelFiles_list#获取一个excel内首页表格def Get_sheet1_from_oneExcel(excelFileName):wbxlrd.open_workbook(excelFileName)sheetwb.sheets()[0]return sheet#获取excel的首页信息,去除首行def Get_sheet1_Data_NoFirstLine(excelFileName):sheetGet_sheet1_from_oneExcel(excelFileName)#获取表格行数和列数highest_rowsheet.nrowshighest_columnsheet.ncolssheet_data[]for rowNum in range(1,highest_row):#获取行数据rowDatasheet.row_values(rowNum)sheet_data.append(rowData)return sheet_data#把csv文档内容转换成一个列表不包括首行def Read_CsvRows_noFirstLine(csvFilename):csvRows []csvFileObj open(csvFilename)readerObj csv.reader(csvFileObj)for row in readerObj:if readerObj.line_num 1:continue # skip first rowcsvRows.append(row)csvFileObj.close()return csvRowsdef one_excel_column_statistic(csv_row):#csv特定行包含excel名字sheet名列搜索内容excelFilenamecsv_row[0]#print(excelFilename,excelFilename)sheetNamecsv_row[1]#print(sheetName,sheetName)columnint(csv_row[2])#print(column,column)contentcsv_row[3]#化药,中药必须转换为[化药, 中药]否则无法遍历content_listcontent.split(,)wbxlrd.open_workbook(excelFilename)sheetwb.sheet_by_name(sheetName)#获取excel指定列的类容column_content_listsheet.col_values(column)#print(column_content_list,column_content_list)number0for i in content_list:countcolumn_content_list.count(i)numbercountprint(excel文件名,excelFilename)print(统计内容:,content)print(数量:,number)print(-*20)return numberdef all_excel_column_statistic(csvFileName):csv_contentRead_CsvRows_noFirstLine(csvFileName)for csv_row in csv_content:one_excel_column_statistic(csv_row)def second_condition_statistic(csv_row):count0excelFileNamecsv_row[0]sheet_dataGet_sheet1_Data_NoFirstLine(excelFileName)Condition1csv_row[2].split(,)[1]Column1_letter(csv_row[2].split(,)[0])index1column_letter_index_convert(Column1_letter)Condition2csv_row[3].split(,)[1]Column2_letter(csv_row[3].split(,)[0])index2column_letter_index_convert(Column2_letter)for rowData in sheet_data:if rowData[index1]Condition1 and rowData[index2]Condition2:count1print(excel文件名,excelFileName)print(统计内容:,Condition1Condition2)print(数量:,count)print(-*20)return countdef all_second_condition_statistic(csvFileName):csvRowsRead_CsvRows_noFirstLine(csvFileName)for csv_row in csvRows:second_condition_statistic(csv_row)#excel列的def column_letter_index_convert(letter):list_letter_index[[A,0],[B,1],[C,2],[D,3],[E,4],[F,5],[G,6],[H,7],[I,8],\[J,9],[K,10],[L,11],[M,12],[N,13],[O,14],[P,15],[Q,16],[R,17],\[S,18],[T,19],[U,20],[V,21],[W,22],[X,23],[Y,24],[Z,25]]for i in list_letter_index:if i[0]letter.upper():indexi[1]return indexcsvFileNameconfig.csvall_second_condition_statistic(csvFileName)excelFileName1月.xlsxcsv_row[1月.xlsx, Sheet1, C,化药, 3,补充申请]print(问题反馈邮箱231469242qq.com)print( .-. )print( \ \ )print( \ \ )print( 喵 喵 喵 | | )print( | | )print( /\---/\ _,---._ | | )print( /^ ^ \, . ; )print( ( O O ) ; )print( .o__, \ )print( / _,--.__ \ )print( / _ ) , -. -. \ )print( / , / , \ \ \ \ )print( / / / , (,_)(,_) )print((,; (,,) )varinput(enter anykey to quit)
