自动化无聊的东西excel，无法获得代码来提取人口普查2010 ['AK']

Question

我正在学习第13章(从电子表格中读取数据(中的示例项目。我已经创建了census2010.py代码并将其保存在我的文档中。当我运行报价时，我得到了这个关键错误。

KeyError                                  Traceback (most recent call last)
~AppDataLocalTemp/ipykernel_35244/1301298642.py in <module>
26 
27 import census2010
---> 28 census2010.allData['AK']['Anchorage']
29 anchoragePop = census2010.allData['AK']['Anchorage']['pop']
30 print('The 2010 population of Anchorage was ' + str(anchoragePop))
KeyError: 'AK'

这是我在交互式shell上运行的当前代码。

import openpyxl, pprint
import os
os.chdir('C:\users\brian\documents')
print('Opening workbook...')
wb = openpyxl.load_workbook('censuspopdata.xlsx')
sheet = wb['Population by Census Tract']
countyData = {}
# TODO: Fill in countyData with each county's population and tracts.
print('Reading rows...')
for row in range(2, sheet.max_row + 1):
state = sheet['B' + str(row)].value
county = sheet['C' + str(row)].value
pop = sheet['D' + str(row)].value
countyData.setdefault(state, {})
countyData[state].setdefault(county, {'tracts': 0, 'pop': 0})
countyData[state][county]['tracts'] += 1
countyData[state][county]['pop'] += int(pop)
print('Writing results...')
resultFile = open('census2010.py', 'w')
resultFile.write('allData = ' + pprint.pformat(countyData))
resultFile.close()
print('Done.')
import census2010
census2010.allData['AK']['Anchorage']
anchoragePop = census2010.allData['AK']['Anchorage']['pop']
print('The 2010 population of Anchorage was ' + str(anchoragePop))

不知道如何从我保存在文档中的excel文件中获取数据。

Answer 1

是否可能将当前目录更改为

os.chdir('C:\users\brian\documents'(

要下载并加载excel数据，在这种情况下，脚本将向该路径写入一个名为census2010.py的文件。但是在您使用交互式shell的同一目录中也有一个名为census2010.py的文件

import sys
sys.path.insert(1, 'C:\users\brian\documents')
import census2010

而不仅仅是

import census2010

从不同文件夹导入文件