ୋɓ௝
                            މʡჿࠅ͜Python
                                            ᄳExcelk
           Excel Դ͜٫຾੬ί༾Ցଧ᎕ࣛdʔᓙሯဲ༊ၑڌʈՈf௰ՊۨٙԷɿ݊d຅ݺࠫᖤ̍
           ў˄εٙ༟ࣘձʮόdExcelٙ༶ၑ஺ܓึܘ࿔d௰ᐲٙઋرٜ݊ટ৪ৗfίԫઋᜊᐲ
           ʘۃሯဲExcelணໄdᆽྼϞՉ༸ଣj৿νЫ͍ίஈଣɓ΅Їᗫࠠࠅٙజڌd΂О፹Ⴌ
           ே̙ঐኬߧৌਕɪאΤᚑɪٙฦ̰dא٫Ыӊ˂ڀ൬ᅰʃࣛ˓ਗһอExcel༊ၑڌdЫ
           Ꮠ༈ኪึ༶͜೻όႧԊdਗ਼ݴ೻ІਗʷfІਗʷ̙˸ਗ਼ɛމ፹ႬٙࠬᎈࠥЇ௰ЭdᜫЫ
           ̙˸ҪࣛගҳءίһϞ͛ପɢٙ΂ਕdʔΎ݊ఊॱήਗ਼༟ࣘልႡe൨ɪڌఊf
           ͉௝ਗ਼ѓൡЫdމОPython݊ίExcelɪʈЪٙʔɚ፯኿d˸ʿPython޴࿁׵Excel
           ʫܔٙІਗʷႧԊVBAٙᎴැf΋ႩᗆExcelνОЪމɓ၇೻όႧԊdԨᐝ༆Չतй
           ʘஈܝdҢึᓃ̈Python޴࿁׵VBAٙ੶ɽ̌ঐf༑ʔεႭdᜫҢࡁ΋ԸႩᗆ͉ࣣՇ
           З˴ԉыl
           ίཥ໘߅ҦჯਹdExcelձPythonʊ຾πίεϋjMicrosoftʮ̡׵1985ϋ೯ڌ
           Exceld˿஢εɛᜓᝣٙ݊d຅ࣛExcel̥ঐίAppleʮ̡ٙ௥ږ෫ཥ໘ɪੂБfٜՑ
           1987ϋdWindowsӻ୕୞׵՟੻Excelو͉jExcel 2.0fMicrosoftԨڢཥɿ༊ၑڌழ
           ᜗ٙ΋Б٫dVisiCorpʮ̡Ϙί1979ϋఱ೯̺əVisiCalcழ᜗dϾܝLotus Software
           ʮ̡ɰ೯БəLotus 1-2-3fMicrosoftʮ̡ԨӚϞኯᔟExcel՟੻̹ఙჯኬήЗj1982
           ϋdMicrosoftʮ̡΋પ̈əMultiplandவ݊ɓಛ̙͜׵MS-DOSӻ୕ၾՉ˼Ъุӻ୕
           ٙཥɿ༊ၑڌழ᜗dʔཀ̴ʔቇ͜׵Windowsӻ୕f
                                                                3
                                                                 
          Excel ਪ˰ٙʬϋܝdPythonί1991ϋሖ͛əfExcelආɝ̹ఙܝܘҞή੻Ցɽ଺ટ
          ॶdPythonڀəˢ༰ɮࣛගʑίၣࠫක೯אӻ୕၍ଣഃत֛ჯਹ౷ʿf2005ϋd຅
          Numpyவࡈਿ׵৬ΐٙ༶ၑၾᇞ׌˾ᅰٙࢁ΁̈ତܝdPythonܘҞήϓމə߅ኪࠇၑٙ
          Ꮄମ፯኿fNumPyഐΥəՇࡈ΋ᚨືᓃࢁ΁dਗ਼߅ኪࠇၑٙהϞක೯ݴ೻዆Υϓఊɓਖ਼
          ࣩfʦ˚dNumPyһ݊͟ೌᅰٙ߅ኪࢁ΁Ͼଡ଼ϓdՉʕܼ̍2008ϋਪ˰ٙpandasdڮ
          ϓə2010ϋܝPythonί༟ࣘ߅ኪၾږፄ༶ၑჯਹٙᄿعમ͜fPandasࢁ΁ٙ̈ତdᜫ
          PythonၾRϓމ༟ࣘ߅ኪჯਹʕ௰஗Դٙ͜೻όணࠇႧԊdᄿع͜׵ν༟ࣘʱؓe୕ࠇ
          ၾዚኜኪ୦ഃʈЪf
          Python ձ Excel ̈ତࣛගܘϘdԨʔ݊Շ٫ਬɓٙ΍ஷᓃjExcelձPythonே݊ɓ၇೻
          όႧԊfኋ၍Python݊ɓ၇೻όႧԊԨʔึᜫЫᜓடdШਗ਼Excelൖމɓ၇೻όႧԊd
          ̙ঐცࠅɓ೦༆ᙑd˲ᛓҢࢉࢉ༸Ըf
          Excel݊ɓ၇೻όႧԊ
          ͉ືʧୗExcelνОЪމɓ၇೻όႧԊdᏍпЫᐝ༆༊ၑڌ޴ᗫٙᙄᕚމО຾੬ɪอ
          ၲfҢࡁਗ਼Ꮸൖίழ᜗ක೯໊ٟʕ఻ࡈ௰Գྼስdᒒе͕ɨԴ͜Excelٙ੬Ԉ፹Ⴌf௰
          ܝʧୗPower QueryձPower PivotdவՇࡈତ˾ExcelʈՈٙεᅰ̌ঐே̙˸pandas
          ಁ˾f
          ৿ν࿁ЫϾԊExcelٙ͜௄ʔ̥݊ΐᒅي૶ఊdЫɓ֛Դ͜ཀᗳЧ=SUM(A1:A4)Ը̋ᐼ
          Ꮇπࣸᇍఖfν؈Ыࠅڀ఻߆ซซவࡈՌᅰνО༶ЪdЫึ೯ତᎷπࣸٙ࠽຾੬΃፠׵
          ɓࡈא఻ࡈᎷπࣸdϾவԬᎷπࣸɰ̙ঐ՟Ӕ׵Չ˼Ꮇπࣸٙ࠽fவᗳٙలࢁՌόխ̣
          ձՉ˼೻όႧԊٙ༶Ъ˙ό޴ࢨೌ఻dࢨй̥ί׵Ыਗ਼೻όᇁᄳίᎷπࣸ༁Ͼʔ݊˖ο
          ᇜ፨ኜf৿νவɓᓃᒔೌجႭ؂Ыjί2020ϋֵdMicrosoft܁̺೯̺lambda              d
                                                                Ռό
          ᜫԴ͜٫ঐ˸ExcelٙІϞʮόႧԊᇜᄳ̙ࠠልԴٙ͜Ռόdɰఱ݊ႭdԴ͜٫ʔΎც
          ࠅ΃፠ৰəExcel˸̮ٙႧԊ€νVBAf࣬ኽExcelପۜڗBrian JonesהԊdவ͍݊
          ᜫExcelϓމɓࡈ˜ॆ͍ٙ™೻όႧԊٙ௰ܝɓ෯ܳྡ1fவจբഹdExcelԴ͜٫Ꮠ༈
          ஗၈խމ˜Excel೻όணࠇࢪ™l
          Excel ೻όணࠇࢪϞɓࡈतйʘஈj˼ࡁεᅰɛ݊ਠਕԴ͜٫אჯਹਖ਼࢕dШʔಀટա
          ཀ͍୕ٙཥ໘߅ኪ઺ԃf˼ࡁ̙ঐ݊ʹ׸ࡰeึࠇࢪאʈ೻ࢪf˼ࡁהԴٙ͜༊ၑڌʈ
          Ո஗ணࠇԸ༆Ӕਠุਪᕚd຾੬ׁଫழ᜗ක೯ٙ௰ԳྼስfϞᛠ׵ϤdவԬ༊ၑڌʈՈ
          1  Ы̙˸ίExcel BlogቡᛘlambdaՌό޴ᗫᑊ׼€https://oreil.ly/4-0y2f
           |
          4   ୋɓ௝jމʡჿࠅ͜PythonᄳExcelk
              ຾੬ίΝɓ΅ڌఊʕ૿ᕏə፩ɝ࠽eࠇၑόձ፩̈࠽d຾੬ცࠅצᛃכԉʑঐᜫ̴ࡁλ
              λ༶ЪdޟЇ̙˸ᎇจ࿁ڌఊආБࡌҷdӚϞ΂ОԣьዚՓf౬̩༑ႭdவԬ༊ၑڌʈ
              ՈॹˇəӪո̙ቦٙᏐ͜ਿᓾண݄dႭ׼˖΁ॹɧဍ̬dӻ୕ॹ˶಻༊fϞࣛࡉdவԬ
              ਪᕚ̙ঐ੭Ը์๘׌Өᗭj৿νЫίɨఊۃҙাࠠอࠇၑʹ׸జڌdЫ̙ঐึᒅ൯אਯ
              ̈፹Ⴌᅰඎٰٙୃdኬߧམᕘᑦฦf৿νЫʔ̥݊͜Іʉٙ፺ආБʹ׸dԟჿ฽Ϟ̙ঐ
              ɪอၲdԷνɨືהࠑf
              อၲʕٙExcel
              Excel ݊อၲ༁ٙ੬܄dί͉ࣣ௴ЪʘࣛdఱϞՇࡈԫ΁ɪə᎘ૢfୋɓۆอၲԸІɛ
              ᗳਿΪଡ଼ଡ଼ᔌնΤ։ࡰึ€HUGO Gene Nomenclature Committeed༈։ࡰึਗ਼఻ࡈ
              ɛᗳਿΪଡ଼ࠠอնΤdλᜫExcelʔΎਗ਼ਿΪΤ၈ᛘ՟މ˚ಂfᑘԷԸႭdމəᒒе
                                                         2
              MARCH1 ஗кйމ1-Mard༈ਿΪଡ଼஗ࠠอնΤމMARCHF1fୋɚۆอၲۆ݊dExcel஗છ
              ঄Ⴌəߵ਷16,000ԷCOVID-19಻༊జѓf༈ԫ΁݊͟׵வԬ಻༊ഐ؈˸ᔚٙExcelᏦ
              ࣩࣸό€.xlsᄳϓdϤࣸό௰ε̥ঐπ׳ߒ65,000അ༟ࣘfவจբഹdɽɓᓃٙ༟ࣘ
              ණఱึաՑவࡈ༟ࣘഅᅰࠢՓٙᅂᚤ3fኋ၍வՇۆอၲޫᗇ׼əExcel࿁׵ତ˾ٟึᑘ
              ԑჀࠠٙήЗdШჃჃೌجˢ੻ɪ˜ࡐ౱ᗼԫ΁™աՑᝓͦٙ೻ܓf
                       ೯͛׵2012ϋd˜ࡐ౱ᗼ™݊ᅙ࣬ɽஷვБɓЗʹ׸ࡰٙၞ໮d˼ٙʹ׸
              ࡐ౱ᗼԫ΁
              ̰Ⴌኬߧ༈Б೯̺൴ཀ20ᄂߕʩʹ׸ฦ̰fԫ΁ᖑ೯๕᎘݊ɓ΅˸ExcelணࠇٙࠬᎈП
              ࠽ᅼۨdவࡈᅼۨɽɽЭПəҳ༟ଡ଼ΥٙॆྼᑦฦࠬᎈfԫܝٙᏨীజѓʕ4ܸ̈˜˸
              ɓஹЕExcel༊ၑڌ༶ЪٙᅼۨdҁΌ΃፠ɛʈЪุd˓ਗਗ਼ɓ΅༊ၑڌٙ༟ࣘልႡ൨
              ɪՑ̤ɓ΅™fৰəʈЪݴ೻ਪᕚd༈༊ၑڌᒔπίɓࡈᜌ፨ɪٙᔬႬjίݔࡈࠇၑό
              ʕd˼ࡁৰ˸ᐼձϾʔ̻݊ѩ࠽f
              ৿νЫ࿁வᗳ݂ԫชጳሳdᛇڎਞቡ͟European Spreadsheet Risks Interest Group 
              €EuSpRIG຾ᐄၪᚐٙHorror Storiesၣ१€https://oreil.ly/WLO-If
              މəᒒеЫٙʮ̡௘׵ᗳЧɪࠑอၲԫ΁ٙ೾ྤdҢࡁԸ޶޶ɨΐ௰ԳྼስdᜫЫίԴ
              ͜Excelࣛһ̋τΌf
                          “                                                       Ž
              2 James Vincent, Scientists rename human genes to stop Microsoft Excel from misreading them as dates,  
                TheVerge, August 6, 2020, https://oreil.ly/0qo-n.
                       “                 ’                         Ž
              3 Leo Kelion, Excel: Why using Microsoft s tool caused COVID-19 results to be lost,  BBC News, October 5, 
                   https://oreil.ly/vvB6o.
                2020, 
                                         https://oreil.ly/0uUj9f
              4  ၪਿϵ߅ʕϞᗫ׵Ϥԫ΁ٙਞϽ˖ᘠ€
                                                                                 | 5
                                                                Excel ݊ɓ၇೻όႧԊ
                                         Anaconda                                       VS Code
                              ̙Զ߅ኪࠇၑٙPython೯Бو͉                                     ੶ɽٙ˖οᇜ፨ኜ
                               Python        Anaconda ٙࣨː຅್ఱ݊            Python ᓒ̂೻ό ʪ஢Դ͜٫ੂБPython೻όᇁ
                                             Python ᇜᙇኜf                                  ձJupyter /PUFCPPLf
                                             ᆽڭPythonᇜᙇኜձࢁ΁                               ʪ஢Դ͜٫ணໄʕᓙᓃၾఊӉ
                          Anaconda Prompt ͍੬ੂБٙն˿౤ͪοʩ                       ਈ፹ʈՈ          ੂБ೻όᇁf
                                             ā୞၌ዚf
                          Jupyter Notebook,  ཫ΋τༀλٙೌᅰୋɧ˙                     ୞၌ዚ          ̙ЪމAnaconda PromptԴٙ͜
                          pandas, xlwings ഃ  ࢁ΁f                                          ዆Υό୞၌ዚf
                             Conda & pip     ʪ஢Դ͜٫τༀᕘ̮ࢁ΁                       Git        ዆ΥGitو͉છՓӻ୕f
                                             אһอତϞࢁ΁ٙࢁ΁၍                                  ʔཀd͉ࣣʔึ͜Ցf
                                             ଣʈՈf
                  ྡ2-1cක೯ᐑྤ
                  Anaconda€Python೯Бو
                  Anaconda̙˸Ⴍ݊༟ࣘ߅ኪޢ௰աᛇڎٙPython೯Бو͉dཫ΋τༀλᅰϵ၇ୋɧ˙
                  ࢁ΁j̴ኹϞJupyter Notebook˸ʿ͉ࣣ੗ණԴٙ͜Չ˼ࢁ΁νpandaseOpenPyXLձ
                  xlwingsfAnacondaࡈɛو̙˸е൬ɨ༱dהϞழ᜗ࢁ΁ே̙ࡒ࢙fAnacondaึτༀ
                  މɓ΅༟ࣘѰdɰ̙˸Ⴠᕦ༆ৰτༀfίϓ̌τༀʘܝdҢࡁਗ਼ίAnaconda Promptɪ
                  ኪ୦఻ࡈ੬͜ն˿dԨੂБʝਗόൖ೿fટഹึʧୗCondaձpipவԬழ᜗ࢁ΁၍ଣʈ
                  Ոd௰ܝ˸CondaൈᏝᐑྤϗ҈fఱ੽ɨ༱ၾτༀAnacondaක֐ыl
                  τༀ
                  ۃֻAnaconda֜˙ၣ१€https://oreil.ly/QV7Nadɨ༱௰อوAnacondaτༀ೻ό€ࡈ
                                                                                                1
                  ɛوfνԴ͜Python 3.xو͉dሗ፯኿64-bit graphical installer fҁϓɨ༱ܝdሗܲ
                  Շɨτༀ೻όd઼ਗτༀ೻ҏdΝจʵ፯הϞཫணணໄfᗫ׵һ༉୚ٙτༀܸͪdሗਞ
                  Ͻ֜˙Ⴍ׼˖΁€https://oreil.ly/r01wnf
                  1 32-bit و͉̥πί׵WindowsЪุӻ୕dͦۃʊ൳Ը൳ˇԈfҬ̈ЫٙWindowsو͉ܘᔊఊdሗίᏦ
                     ࣩᐼ၍ʕۃֻCᅻfν؈ЫΝࣛ޶ՑProgram FilesձProgram Files (x86)༟ࣘѰdவڌͪЫԴٙ݊͜
                     Windows 64-bit و͉fν؈Ы̥޶ՑProgram Files༟ࣘѰdۆЫԴٙ݊͜Windows 32-bitӻ୕f
                     |
                  20
                       ୋɚ௝jක೯ᐑྤ