TQDM从.xlsx表的每行一个进度栏

Question

我编写了一个脚本，该脚本从Excel表上读取并执行了每行的数据操作。我想看到一个进度栏，显示了操作的全部进度。如您在图像中看到的那样，每行之后显示进度条。

快照：

这是代码。

print('Reading Rows...')
for row in tqdm(range(2, sheet.max_row + 1)):
    # Each row in the spreadsheet has data for one census tract
    state = sheet['B' + str(row)].value
    county = sheet['C' + str(row)].value
    pop = sheet['D' + str(row)].value


    # ToDo: Open a new text file and write the content of countyData to it
    countyData.setdefault(state, {})
    #Make sure the key for this county in this state exists.
    countyData[state].setdefault(county, {'tracts':0, 'pop':0})
    
    # Each row represnts one census tract, so increment by one
    countyData[state][county]['tracts'] += 1
    countyData[state][county]['pop'] += 1
    
    #Todo: Open a new file and write the contents of countyData to it.
    print('Writing results...')
    resultFile = open('census2010.py', 'w')
    resultFile.write('allData = ' + pprint.pformat(countyData))
    resultFile.close()
print('Done')

Answer 1

您可以删除此行

print('Writing results...')

，看看它是否仍然显示出这种方式，可能会引起打印语句。

例如，查看以下代码

for i in tqdm(range(int(9e6))):
    if(i%10000==0):
        print("hello")
    pass

在Hello消息后将显示新的进度栏，并删除打印语句解决了它。