Python实现批量导入数据到数据库

Python实现批量导入数据到数据库
excel数据批量导入mysql数据库，django后台数据批量导入
数据分析可视化 

# write excel contents into database by for row in range(4, rows_number):
                for row in range(5, rows_number):
                    name = table.cell(row, 2).value # get product name from each row in excel
                    if name:  # check if have contents in excel row? if yes, execute below codings; if no, break
                        productId = self.new_product(name, stage, odmName)  # 调用函数 new_product 判断数据库是否已有该产品，

                        new_issue = Issue()
                        new_issue.platformName_id = productId
                        new_issue.processName = sheet_name                             # write process name
                        new_issue.issue_desc = table.cell(row, 3).value                # write issue description
                        issueCategory_1 = table.cell(row, 4).value                     # write issue interaction
                        category_1_id = self.new_category_1(issueCategory_1)
                        new_issue.issue_interaction_id = category_1_id
                        issueCategory_2 = table.cell(row, 5).value                     # write issue symptom
                        category_2_id = self.new_category_2(issueCategory_2, category_1_id, issueCategory_1)
                        new_issue.issue_symptom_id = category_2_id
                        new_issue.impact_scope = table.cell(row, 6).value              # write issue impact scope
                        new_issue.input_qty = table.cell(row, 7).value                 # write total input quantity
                        new_issue.defect_qty = table.cell(row, 8).value                # write defect quantity
                        new_issue.fail_rate_stage = table.cell(row, 9).value           # write failure rate by every build stage
                        new_issue.sn =  table.cell(row, 10).value                      # write fail units S/N information
                        new_issue.sku =  table.cell(row, 11).value                     # write fail units SKU information