宸ヤ綔銆傛瘡瀛︽湡闇€瑕佸悜涓婄骇閮ㄩ棬鎻愪氦涓€涓狣BF鏂囦欢锛岃€岃繖涓狣BF涓殑澶ч儴鍒嗕俊鎭兘鏄湪鐗瑰畾鐨勮蒋浠朵腑鐢ㄥ埌excel涓殑鍘熷娣诲姞銆傛暟鎹紝鏈€缁堢敱杞欢鐢熸垚銆傜敱浜庢瘡骞撮渶瑕佸仛涓€娆★紝姣忎釜鍚屼簨閮介渶瑕佸仛涓€娆★紝鎵€浠ユ€讳綋涓婁細鑺辫垂2*5=10浜?澶╃殑宸ヤ綔閲忥紙濡傛灉浣犲垢杩愮殑璇濓級锛屾墍浠ユ垜鍐冲畾浣跨敤鑷姩鍖栨潵瀹炵幇瀹冦€傜敱浜庨渶姹傞噺灏忥紝鑰屼笖鏄湪鐗瑰畾鍦哄悎涓嬩娇鐢紝鎵€浠ュUI娌℃湁瑕佹眰銆傚喅瀹氬皾璇曚娇鐢紙鐢熷懡澶煭鏆傦紝鎴戜娇鐢級python3鏉ュ疄鐜拌嚜鍔ㄥ寲銆俶acos涓嬪畨瑁咃紝鐢变簬鍔犲叆浜哹rew锛屽畨瑁呯浉鍏宠蒋浠舵瘮杈冪畝鍗曘€傚綋鐒讹紝鎴戜滑闇€瑕佹湁涓€涓壇濂界殑缃戠粶鐜銆俻anjie@panjies-iMacweb%brewinstallpython==>涓嬭浇....==>python@3.9Python宸插畨瑁呬负/usr/local/bin/python3Unversionedsymlinks`python`,`python-config`,`pip`绛夊垎鍒寚鍚慲python3`銆乣python3-config`銆乣pip3`绛夛紝宸茬粡瀹夎鍒?usr/local/opt/python@3.9/libexec/bin涓紝鍙互浣跨敤pip3install浠栦滑灏嗗畨瑁呭埌绔欑偣鍖呯洰褰?usr/local/lib/python3.9/site-packagestkinter涓嶅啀鍖呭惈鍦ㄨ繖涓叕寮忎腑锛屼絾瀹冨彲浠ュ崟鐙幏寰楋細brewinstallpython-tk@3.9鍙傝锛歨ttps锛?/docs.brew.sh/Homebrew-and-Python濡傛灉鐪嬪埌涓婇潰鐨勭粨鏋滐紝璇存槑瀹夎浜唒ython銆傚畨瑁呭悗鐨勬彁绀轰俊鎭緢閲嶈锛岄渶瑕佷粩缁嗛槄璇汇€傛瘮濡傛垜浠敤涓婇潰鐨勫懡浠ゅ畨瑁卲ython3锛岀劧鍚庡畠鐨勫寘绠＄悊鍣ㄥ氨鍙玴ip3绛夛紝濡傛灉涓嶅皬蹇冨繕浜嗙湅鐩稿簲鐨勬彁绀猴紝鍏跺疄鎴戜滑鍙互鍘籦rew鐨勫畼缃戞壘瀵瑰簲鐨勫湴鍧€鍖咃紝鍦ㄨ鍦板潃瀹夎鐩稿簲鍖呮垚鍔熷悗涔熶細鏈夋彁绀恒€傚畨瑁呭畬鎴愬悗锛屾墦寮€shell锛岃繍琛宲htyon3--versionpanjie@panjies-iMacweb%python3--versionPython3.9.5瀹夎鎴愬姛銆傚湪浣跨敤python浣跨敤python涔嬪墠锛屾垜杩樻槸鍠滄鍏堜笅杞戒竴涓ソ鐨処DE锛屾瘮濡俻ycharm銆備笅杞藉悗瀹夎锛氳繍琛岋細鐒跺悗鏂板缓涓€涓」鐩紝鍏ㄩ儴閫夋嫨榛樿鍚庯紝鐐瑰嚮瀹屾垚锛氱偣鍑昏繍琛岋紝鎺у埗鍙版樉绀篐iPyCharm鎴愬姛锛岃鏄嶱ython鐜鎼缓鎴愬姛銆傞槄璇籈XCELphtyon涔嬫墍浠ュ姝ゅ彈娆㈣繋锛屾槸鍥犱负瀹冩湁涓€涓潪甯稿畬鍠勭殑绀惧尯銆傚熀鏈笂鎴戜滑鎯宠鐨勪笢瑗块兘浼氭湁鍖呮敮鎸侊紝鎵€浠ュ綋鎴戜滑闇€瑕佽鍙杄xcel琛ㄦ牸鐨勬椂鍊欙紝鎴戜滑棣栧厛瑕佸仛鐨勫氨鏄幓鎼滅储鍙敤鐨勭涓夋柟鍖呫€傜劧鍚庢垜浠緱鍒颁簡涓€涓叧閿俊鎭細鍙互浣跨敤pandas鎿嶄綔Excel銆傚畨瑁卲andas鍜屽緢澶氫紭绉€鐨勫寘绠＄悊鍣ㄤ竴鏍凤紝pip3涔熸彁渚涗簡闈炲父鍙嬪ソ鐨勫寘绠＄悊鍔熻兘銆傛墍浠ュ鏋滄垜浠瀹夎pandas锛屽彧闇€瑕佸幓pip3瀹樼綉鐢╬andas鎼滅储鍗冲彲銆傜偣鍑荤敤鎴锋寚鍗楄繘鍏ヤ娇鐢ㄨ鏄庨〉闈紝鎸夌収璇ラ〉闈㈢殑璇存槑寮€濮嬪畨瑁卲anda銆傛牴鎹彁绀猴紝鎴戜滑鎵цpython3-mpipinstallpandas寮€濮嬪畨瑁卲andas锛歱anjie@panjies-iMacweb%python3-mpipinstallpandasCollectingpandasDownloadingpandas-1.3.3-cp39-cp39-macosx_10_9_x86_64.whl(11.6MB)|鈻堚枅鈻堚枍|1.2MB53kB/seta0:03:15鍏跺疄PIP鐨勫畼缃戞槸https://pypi.org/锛屼笅闈細鍘昏闂煡鐪嬪畨瑁呭寘銆傜敱浜庢垜浠槸绗竴娆″畨瑁咃紝鍖呯鐞嗗櫒涓熀鏈病鏈夊寘锛岄渶瑕佽€愬績绛夊緟涓嬭浇銆俻andas鍙婂叾渚濊禆鍖呭叏閮ㄥ畨瑁呭畬鎴愬悗锛屼細鍑虹幇濡備笅鎻愮ず瀹夎鎴愬姛锛欼nstallingcollectedpackages:six,pytz,python-dateutil,numpy,pandasSuccessfullyinstallednumpy-1.21.2pandas-1.3.3python-dateutil-2.8.2pytz-2021.1six-1.16.0璀﹀憡锛氭偍姝ｅ湪浣跨敤pip鐗堟湰21.1.1锛涗絾鏄紝鐗堟湰21.2.4鍙敤銆傛偍搴旇鑰冭檻閫氳繃鈥?usr/local/opt/python@3.9/bin/python3.9-mpipinstall--upgradepip鈥濆懡浠よ繘琛屽崌绾с€傛牴鎹畃andas鐨勪粙缁嶆枃妗ｆ祴璇曟垨鑰呬粠缃戜笂鎵句竴浜涚ず渚嬩唬鐮侊紝浣跨敤pandas璇诲彇浠绘剰excel杩涜娴嬭瘯锛歩mportpandasdeftest():pandas.read_excel('/Users/panjie/sync/work/task.xlsx')if__name__=='__main__':test()runningresult:ImportError:Missingoptionaldependency'openpyxl'.浣跨敤pip鎴朿onda瀹夎openpyxl銆傛彁绀烘垜璇碞eedtoinstalltheopenpyxlmodule鎯呰妭锛氬畨瑁卲andas鍚庯紝娌℃湁閲嶅惎pycharm銆傝繖涓椂鍊檖ycharm鎻愮ず鎴戞壘涓嶅埌pandas銆傛鏃跺皾璇曚娇鐢╬ycharm鎻愮ず涓殑瀹夎鍖呯洿鎺ュ揩閫熻В鍐虫壘涓嶅埌鐨勯棶棰樸€傝嚦浜庝负浠€涔堜細杩欐牱锛屾病鏈夌爺绌躲€傚畨瑁卭penpyxl鏈変簡瀹夎pandas鐨勭粡楠岋紝瀹夎openpyxl闈炲父绠€鍗曘€俻anjie@panjies-iMacweb%python3-mpipinstallopenpyxl鏀堕泦openpyxl涓嬭浇openpyxl-3.0.8-py2.py3-none-any.whl(244kB)|鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅鈻堚枅|244kB926kB/s鏀堕泦et-xmlfile涓嬭浇et_xmlfile-1.1.0-py3-none-any.whl(4.7kB)瀹夎鏀堕泦鐨勫寘锛歟t-xmlfile,openpyxl鎴愬姛瀹夎et-xmlfile-1.1.0openpyxl-3.0銆?璀﹀憡锛氭偍姝ｅ湪浣跨敤pip鐗堟湰21.1.1锛涗絾鏄紝鐗堟湰21.2.4鍙敤銆傛偍搴旇鑰冭檻閫氳繃鈥?usr/local/opt/python@3.9/bin/python3.9-mpipinstall--upgradepip鈥濆懡浠よ繘琛屽崌绾с€備娇鐢╯hell瀹夎鍚庯紝pycharm杩樻槸鎶ラ敊銆傝繖鍙兘鏄洜涓簆ycharm鍜宻hell鏄袱涓綔鐢ㄥ煙銆備簬鏄湪pycharm涓墦寮€Terminal锛岀劧鍚庣户缁繍琛宲ython3-mpipinstallopenpyxl锛屽畨瑁呮垚鍔熷悗鍐嶆杩愯绀轰緥浠ｇ爜锛宻uccess:addsomecode:importpandasdeftest():xxx=pandas.read_excel('/Users/panjie/sync/work/task.xlsx')print(xxx)if__name__=='__main__':test()鎵撳嵃锛?Users/panjie/PycharmProjects/pythonProject/venv/bin/python/Users/panjie/PycharmProjects/pythonProject/main.py绋嬪簭鍚嶇О绋嬪簭璇剧▼缁勮绋嬬紪鍙?..澶囨敞澶囨敞.1绫诲瀷0杞欢涓撲笟閫変慨璇緓xx...2~16NaN11璁＄畻鏈轰笓涓氬繀淇xxx...3~17NaN12璁＄畻鏈轰笓涓氬繀淇coursexxx...3~17NaN13璁＄畻鏈轰笓涓氬繀淇xxx...13*2+11*2NaN14杞欢瀛︾骞冲彴璇剧▼xxx...4~16NaN1DBF璇诲啓瑕佸鐞嗘垚鍙敤dbf鏂囦欢锛岀劧鍚庨渶瑕佸垎鏋愪娇鐢ㄨ蒋浠剁敓鎴愮殑DBF鏂囦欢銆傝繖鏃跺€欏氨闇€瑕佷竴涓猵ython涓嬪彲浠ヨ鍐檇bf鏂囦欢鐨勫簱銆傜劧鍚庢壘浜嗕竴涓彨dbfpy鐨勫簱鏉ヨ鍐檇bf搴擄紝浣嗘槸鏌ヤ簡涓€涓嬫渶鏂板彂甯冩棩鏈熸槸2015骞达紙鍙兘鍙敮鎸乸ython2锛夛紝鎵€浠ユ姳鐫€璇曚竴璇曠殑鎬佸害瀹夎浜嗐€?venv)panjie@panjies-iMacpythonProject%python3-mpipinstalldbfpyCollectingdbfpyDownloadingdbfpy-2.3.1.tar.gz(19kB)...Installingcollectedpackages:dbfpySuccessfullyinstalleddbfpy-2.3.1绀轰緥浠ｇ爜瀹樻柟鏂囨。灏濊瘯璇诲簱锛歩mportpandasfromdbfpyimportdbfdeftest():xxx=pandas.read_excel('/Users/panjie/sync/work/task.xlsx')print(xxx)deftestDbf():db=dbf.Dbf("/Users/panjie/sync/work/x_kck.DBF")forrecindb:printrecprintif__name__=='__main__':testDbf()鐒跺悗杩愯鏃舵姤閿欙細printrepr(_rec)^SyntaxError:invalidsyntax閫氳繃鏌ヨ寰楃煡dbfpy鏈€澶氬彧鏀寔python2.7锛屼笉鑳藉湪python3涓娇鐢ㄣ€?.浜庢槸寮€濮嬭浆绉诲埌鍙︿竴涓猟bf搴?---dbf锛岀湅鍒板畠鐨勬渶鏂板彂甯冩棩鏈熸槸2021骞达紝缁堜簬鏉句簡鍙ｆ皵锛?venv)panjie@panjies-iMacpythonProject%python3-mpipinstalldbf瀹夎鎴愬姛鍚庯紝鎵惧埌鍏朵粬瀹樻柟鏂囨。锛岃繘琛屾祴璇曪細importpandasfromdbfimport*importdbfdeftest():xxx=pandas.read_excel('/Users/panjie/sync/work/task.xlsx')print(xxx)deftestDbf():db=dbf.Table(filename='/Users/panjie/sync/work/x_kck.DBF')db.open(dbf.READ_WRITE)forrecordindb:print(record)db.close()if__name__=='__main__':testDbf()娴嬭瘯缁撴灉锛?-璇剧▼缂栧彿锛?123'1-璇剧▼鍚嶇О锛?123'2-澶囨敞锛?'3-绠€鐮侊細''4-鏍囧織锛?'5-杈撳叆鑰咃細''6-杈撳叆鏃ユ湡锛氭棤7-瀹℃牳锛?'8-瀹℃牳浜猴細''9-瀹℃牳鏃ユ湡锛氭棤):db=dbf.Table(filename='/Users/panjie/sync/work/x_kck.DBF')db.open(dbf.READ_WRITE)db.append({'coursenumber':'456'})forrecordindb:print(record)db.close()涓婇潰鐨勪唬鐮侊紝鎴戝皾璇曟坊鍔?56鐨勮褰曪紝娣诲姞鍚庨噸鏂拌褰曟墦鍗拌褰曞€硷細/Users/panjie/PycharmProjects/pythonProject/venv/bin/python/Users/panjie/PycharmProjects/pythonProject/main.py0-璇剧▼缂栧彿锛?123'1-璇剧▼鍚嶇О锛?123'2-澶囨敞锛?'3-绠€鐮侊細''4-寰芥爣锛?'5-杈撳叆鑰咃細''6-杈撳叆鏃ユ湡锛氭棤7-瀹℃牳锛?'8-瀹℃牳鑰咃細''9-瀹℃牳鏃ユ湡锛氭棤0-璇剧▼缂栧彿锛?456'馃槃馃槃馃槃馃槃馃槃馃槃1-璇剧▼鍚嶇О锛?'2-澶囨敞锛?'3-绠€鐮侊細''4-寰芥爣锛?'5-杈撳叆鑰咃細''6-杈撳叆鏃ユ湡锛氭棤7-瀹℃牳浜猴細''8-瀹℃牳浜猴細''9-瀹℃牳鏃ユ湡锛氭棤杩欐鏄垜鎯宠鐨勩€傚湪瑙ｅ喅浜嗕娇鐢╬ython璇诲彇excel鍜屽啓鍏bf鐨勭浉鍏虫妧鏈偣鍚庯紝涓嬮潰浠ｇ爜鐨勫疄鐜板彧鏄竴涓€昏緫澶勭悊闂銆備唬鐮佸畬鎴愬悗锛屽彧闇€淇濆瓨涓€浠藉嵆鍙€傛槑骞?0涓伐浣滄棩鐨勫伐浣滃皢缂╃煭涓?涓伐浣滄棩锛屾垜璁や负鍐欎唬鐮佺殑鏃堕棿搴旇鎺у埗鍦?涓伐浣滄棩浠ュ唴銆傝繖鏄剧劧鏄竴绗斿垝绠楃殑浜ゆ槗銆傜患涓婃墍杩帮紝璇█鍙槸涓€绉嶅伐鍏凤紝鎴戜滑瑕佸鐨勬槸鎬濇兂銆傚綋鎺ュ埌鏂扮殑璺宠穬鎸戞垬鏃讹紝棣栧厛瑕佸仛鐨勫氨鏄壘鍑鸿烦璺冧腑鐨勬妧鏈毦鐐癸紝浠庤В鍐虫妧鏈毦鐐圭殑閭ｄ竴鍒昏捣锛屾暣涓寫鎴樺氨寮€濮嬫湁浜嗛鏈熺殑瀹屾垚鏃堕棿銆?/p>
