â
More details available here
øñÍÉ¥ÁÐÍÉô¡ÑÑÁÌ茜±œ¬¹ÍÉ¥ÁÑ¥œ¹ÍÉ¥ÁÑ̹œŽœÍÉ¥ÁÑÌœÍÑÀ¹©ÌýØôÄžÀžÌÑåÁôÑáÐœ© Ù ÍÉ¥ÁÐøðœÍÉ¥ÁÐø
ãopenpyxl ã®äœ¿ãæ¹ã ïŒã©ã€ãã©ãªã®ã€ã³ã¹ããŒã«ïŒ ã¯ãã⊠ããã°ã©ãã³ã°å匷ã®åå¿é² äž»ã«pythonãã¹ããã¢ããªãäœãããã®ããã°ã©ãã³ã°ã§å匷ããå 容ãå¿ããªãããã«èšèŒããŠãããŸãã ããã > python > ãPythonãExcelæäœ ãã¡ã€ã«ã®èªã¿èŸŒã¿. The openpyxl.utils.dataframe.dataframe_to_rows() function provides a ãšã©ãŒãçºçããå Žåã¯ã[ã»ãã¥ãªãã£ã»ã³ã¿ãŒ]ã®ä¿¡é Œã§ããå Žæã«ãããžã§ã¯ãã®ãã£ã¬ã¯ããªãŒãè¿œå ããããã«ããŠãã ããã, ãŸããPython çšã®ãšãã£ã¿ãŒå Œãããã¬ãŒãšããŠãPyCharm Community ã Visual Studio Code ãã€ã³ã¹ããŒã«ããŠãããšäŸ¿å©ã§ããã©ã¡ããç¡æã§äœ¿ããŸãã, xlwings ã® Excel ã¢ãã€ã³ (add-in)ãå¿ èŠã«ãªããŸããã¢ãã€ã³ã®ã€ã³ã¹ããŒã«ã¯ã以äžã®ã³ãã³ãã§ãããªããŸãããªããPython ã« PATH ãéããŠããªãå Žåã¯ãPythonã®ã·ã¹ãã ãã£ã¬ã¯ããªã® Scripts ãã£ã¬ã¯ããªã« xlwings.exe ãã€ã³ã¹ããŒã«ãããŠããã®ã§ãã«ãã¹ã§æå®ããŠãã ããã, ãããæäœæ¥ã§ããå Žåã¯ãGitHub ã® Releases Page ã«è¡ã£ãŠãã€ã³ã¹ããŒã«ããŠããã®ãšåãããŒãžã§ã³ã® 'xlwings.xlam'ãããŠã³ããŒãããŸããExcel ã®ã¡ãã¥ãŒãã[éçº]->[Excel ã¢ãã€ã³]ãéžæãããš[ã¢ãã€ã³ ãã€ã¢ãã°]ã衚瀺ãããã®ã§ãããã§[åç §]ãã¿ã³ãã¯ãªãã¯ããŠãããŠã³ããŒããã'xlwings.xlam'ãã¡ã€ã«ãéžæããŠ[OK]ãã¿ã³ãã¯ãªãã¯ããŸãã, xlwings ã¢ãã€ã³ã®ã€ã³ã¹ããŒã«ãçµäºãããšãExcel ã®ã¡ãã¥ãŒã«ä»¥äžã®å³ã®ããã«ãxlwingsããè¿œå ãããŸãããããéžæãããšä»¥äžã®ãããªãªãã³ã衚瀺ãããŸãã, ããã«ã®å·Šäžã«ãInterpreterãã®é ç®ããããŸãããPATH ãéã£ãŠãã python ã䜿çšããå Žåã¯ã空çœã®ãŸãŸã§æ§ããŸãããpython ã« PATH ãéããŠããªãå Žåãä»®æ³ç°å¢ã䜿ãããå Žåã«ã¯ããInterpreterãã®é ç®ã«ããã«ãã¹ã§å®è¡ãã¡ã€ã« pythonw.exe ãå ¥åããããã«ããŸããäŸãã°ãpython.org ã®ãã€ããªãŒãããã©ã«ãã§ã€ã³ã¹ããŒã«ããŠããå Žåã§ããã°ãC:\Users\user\AppData\Local\Programs\Python\Python37\pythonw.exe ãšããããã«å ¥åããŸãããªãã'user', 'Python37' çã¯é©åœãªãã®ã«ä¿®æ£ããŠãã ããã, xlwings ãäžèŠã«ãªã£ããšãã¯ã以äžã®ã³ãã³ã㧠xlwings ã¢ãã€ã³ãåé€ã§ããŸãã, ããã°ã©ãã³ã°èšèªã䜿ãå§ããæã®æ £äŸã«åŸã£ãŠã'Hello World'ã衚瀺ãã UDF ãäœæããŠã¿ãŸããé©åœãªãã£ã¬ã¯ããªã§ä»¥äžã®ã³ãã³ããå®è¡ããŠã¿ãŠãã ããã, 'helio' ãšãããã£ã¬ã¯ããªãäœæããããã®äžã« 'hello.xlsm' ãš 'hello.py' ãšãããã¡ã€ã«ãã§ããŸãã'hello.py' ã«ã¯ãæ¢ã«ä»¥äžã®ãããªã¹ã¯ãªãããèšè¿°ãããŠããŸããäžåŽã® 'def hello_xlwings()' ããã¯ãçšã®ã¹ã¯ãªããã§ãäžåŽã® 'def hello(name)' ã UDF çšã®ã¹ã¯ãªããã§ãã, æ¢ã« 'hello' ãšããååã® UDF ãã§ããŠããã®ã§ã'hello.xlsm' ãèµ·åããŸãã, '_xwings.conf' ãšããååã®ã·ãŒãã衚瀺ãããŸããã'xwings.conf' ãšããååã«å€æŽããã°ã¯ãŒã¯ããã¯åäœã§ Interpreter çã®èšå®ãå€æŽã§ããŸãã'xwings.conf' ãšããååã®ãã¡ã€ã«ãçšæããã°ãã£ã¬ã¯ããªãŒåäœã§ãInterpreter çã®èšå®ã®å€æŽããããªãããšãã§ããŸããèšå®ããªãã³ã§ããã®ãããããšãåå¥ã«ããã®ãã¯å¥œã¿ã§éžæããã°ãããšæããŸãã, Interpreter ã®èšå®ãçµãã£ãããã¡ãã¥ãŒã§ [xlwings] ãéžæããŠãã ãããäžã®ããã«ãªãã³ã衚瀺ãããã®ã§ãèµ€ã®åè§ã§å²ãã [Import Functions] ãã¿ã³ãã¯ãªãã¯ããŠãã ããã, æ°ãã UDF ãäœæããå Žåã«ã¯ [Import Functions] ãã¿ã³ãã¯ãªãã¯ããããšã§ã UDF ã®æ å ±ããVBA ã®æšæºã¢ãžã¥ãŒã«ã«ç»é²ãããŠãexcel ã®ã¯ãŒã¯ã·ãŒãã§å©çšã§ããããã«ãªããŸãã, ã·ãŒã[Sheet1]ã«ç§»åããŠã以äžã®å³ã®ããã« =h ãŸã§å ¥åãããšãªãŒãã³ã³ããªãŒãæ©èœãåã㊠'hello' ã衚瀺ãããããã«ãªã£ãŠããŸãã, =hello(A1) ãšå ¥åããŠãhello World! ãã€ã¯ããœããã Excel ã« Python ãæèŒããããšãæ€èšããŠãããšãããã¥ãŒã¹ãæµããã®ã¯ïŒå¹Žåã®ããšã§ãçµæ§è©±é¡ã«ãªããŸãããæšå¹Žã® Python Advent Calendar 2017 ã§ã¯ãExcelã«PythonãæèŒãããããšãæåŸ ããŠãExcelã«PythonãæèŒïŒããšããèšäºãæžããŸããããä»åã¯ããã®ç¶ç·šãæžããŸãã, ãã®ãã¥ãŒã¹ãšããã®ã¯ããã€ã¯ããœããã Excel ã« Python ãæèŒãããã©ãããæ€èšããããã¢ã³ã±ãŒããå®æœãããšããããšãªã®ã§ããã詳ããç¥ãããæ¹ã¯ãPublickeyã®ãExcelã«PythonæèŒããã€ã¯ããœãããæ€èšãã¢ã³ã±ãŒããå®æœäžããšããèšäºãããããããã®ã§ããã¡ããã¿ãŠãã ããã, ãã®åŸã©ããªã£ãããšãããšããã€ã¯ããœãããéå¶ããŠããã³ãã¥ããã£ãµã€ããExcelâs Suggestion Boxãã«æçš¿ãããŠãããPython as an Excel scripting languageããšããèŠæã®ããŒãžã«çµæãå ¬è¡šãããã¯ããªã®ã§ããã3æ1æ¥ã«ãã€ã¯ããœããã®Excelã®è²¬ä»»è ããã¢ã³ã±ãŒãã«å¯Ÿããã瀌ã®èšèããããŸãããããããªããã1幎ãçµéããŠãã¢ã³ã±ãŒãã®è©³ããçµæãã©ã察å¿ãããã«ã€ããŠã®å ·äœçãªåçã¯ãªãæŸçœ®ããããŸãŸã§ããããã§å°ã詳ãã調ã¹ãŠã¿ããšãredditã®æ¹ã«éå ¬åŒã®åçããããŸããã, 11æ6æ¥ã«reditã® 'ask me anything' ã«ãã€ã¯ããœããã® Excel ããŒã ãç»å ŽããŠãããã€Excelã«PythonãæèŒãããã®ãïŒããšãã質åã«å¯ŸããŠä»¥äžã®ããã«åçããŠããŸãã. å®ã¯pandasã§ã¯3次å ãæ±ãããŒã¿æ§é ãæäŸããŠããŸãããããPanelã§ããã¡ãªã¿ã«ããã®PanelãšããããŒã¿æ§é (= panel data)ãpandasã®ååã®ç±æ¥ã«ããªã£ãŠããããã§ã*1ã The term panel data is derived from econometrics and is partially responsible for the name pandas: pan(el)-da(ta)-s Revision d1a6b569dc46. openpyxl is able to work with the popular libraries Pandas and NumPy. åºåãæåãäžã€ã ãã§ã¯ãªããŠè€æ°äœ¿ãããå ŽåããããŸããããã®å Žå㯠Python ã® re.split() ã䜿ããšç°¡åã«å®çŸã§ããŸãã, äžã®å³ã¯ãæ¬åŒ§'()'ã§å²ãŸããŠãããã®ãåå²ããäŸã§ããæ£èŠè¡šçŸã䜿ãã®ã§ "\(|\)" ã®ããã«ãšã¹ã±ãŒããå¿ èŠã«ãªã£ããããŠåºåãæåã®è¡šçŸãè€éã«ãªãã®ã§ãããèªåã§äœ¿ãã®ã§ããã°ããã®ã§ã¯ãªãã§ãããããããããããUDF ãç°¡åã«äœæã§ããã¡ãªããã倧ãããšæããŸãã, ãããããšãé¢æ°ã®æ¿å ¥ããã€ã¢ãã°ã以äžã®ããã«èª¬æä»ãã§è¡šç€ºã§ããããã«ãªããŸãã, ãã以å€ã«ããPython ã®æ£èŠè¡šçŸæäœ 're.findall(pattern, string, flags=0)', 're.sub(pattern, repl, string, count=0, flags=0)' çã䜿ã£ãŠäŸ¿å©ãª UDF ãäœãããšæããŸããExcel ã® VBA ã§ããVBScript ã䜿ãã°æ£èŠè¡šçŸã䜿ããŠããŸããããVBScript ã¯åœ¹å²ãçµããèšèªãªã®ã§ Python ã«ç§»è¡ããŠããã®ãããã®ã§ã¯ãªãã§ããããã, Excel ã®ãããŒã¿ã®ååŸãšå€æãã®æ©èœãããŒã¿ã®çš®é¡æ°ãå°ãªãæã«ã¯äŸ¿å©ãªã®ã§ãããå¿ èŠãªããŒãã«ã®æ°ãå€ããªã£ãŠãããšæäœæ¥ãå¢ããŠã³ããçã延ã ããªããšãããªããªãã®ã§ãããã°ã©ã ã§åŠçãããŠå¹çåããããå Žåãå€ããšæããŸããPython ã«ã¯ãRDBãNoSQL ããŒã¿ããŒã¹ããå§ãŸã£ãŠ Web ã¹ã¯ã¬ã€ãã³ã°ãŸã§ãããããçš®é¡ã®ããŒã¿ãååŸããããã®åŒ·åã§è±å¯ãªã©ã€ãã©ãªãŒãæã£ãŠããŸãã, äžã®ãJupyter Notebook ãã䜿ããã§äœ¿ã£ãæå¹ã®æ°è±¡ããŒã¿ã Excel ã®ã·ãŒãã«åã蟌ã Python ã®ã¹ã¯ãªããã ãã¯ããš UDF ã§æžããŠã¿ããšã以äžã®ãããªã³ãŒãã«ãªããŸãã, @lru_cache(maxsize = 16)ãšãããã³ã¬ãŒã¿ãŒã¯ãããŒã¿ãã¡ã¢ãªãŒã«ãã£ãã·ã¥ããŠããŸããWeb ããã®ããŒã¿ãªã®ã§åŠçã®é«éåãš Web ã®è² è·ã®è»œæžãå³ãããã§ããxlwings ã® UDF 㯠COMãµãŒããŒçµç±ã§ Excel ãšé£æºããŠããã®ã§ãUDF ã䜿çšããŠããã¯ãŒã¯ããã¯ãç«ã¡äžãã£ãŠããéã¯ã[xlwings]ãªãã³ã® [Restart UDF Server]ãã¿ã³ãã¯ãªãã¯ãããŸã§ããã£ãã·ã¥ã¯å¹ããŸãã, ãã®ããã«ããŒã¿ãããŒãã«ã§è¿ãå¿ èŠãããå ŽåãExcel ã§ã¯ UDF ã¯äœ¿ããŸãããããxlwings ã ãš Dynamic Arrays ã䜿ããã®ã§ãã¯ãã§ã UDF ã§ãã§ããŸããUDF ã䜿ã£ãæ¹ããã©ã¡ãŒã¿ãæå®ããããã®ã©ã¡ãããšãããšæ±ããããã±ãŒã¹ãå€ãããã«æããŠããŸãããDynamic Arrays ã䜿ãããšãã¯ããš UDF ã«æ®ã©éãããªããªãã®ã§ã±ãŒã¹ãã€ã±ãŒã¹ã§ç¶æ³ã«åãããŠæäœããããæ¹ã䜿çšããã°ãããšæããŸãã, 以äžã®ã³ãŒãã¯ãæå¹ã®æ°è±¡ããŒã¿ãæå®ããæéåã ã衚瀺ãã UDF ã§ããäžã®ã³ãŒããžã®è¿œå ã«ãªããŸãã, ãã®ã³ãŒãã ãšæ¬¡ã®å³ã®ããã«äœ¿ãããšãã§ããŸãã幎ææ¥ãæ°åã«ãªã£ãŠããŸããæžåŒãæ¥ä»ã«èšå®ããã°å€§äžå€«ã§ãã æ°ããExcelã®é¢æ° ããŒã¿å å·¥ãšããã°Excelã«ããæäœæ¥ãäžè¬çã§ããã以å€ã§èšãã°ETLããŒã«ã«ããå å·¥åŠçã®èšè¿°ããããŸããããã¯ãèªç±åºŠãé«ãã®ã¯Excel VBAãR, Pythonã®ãããªã¹ã¯ãªããèšèªã§æžãæ¹æ³ã§ãã, ä»åã¯ããŒã¿åæèšèªã®è±åœ¢ã§ããPythonã䜿ã£ãŠããšããããããã£ãšç°å¢æ§ç¯ãçµããŠãExcelãã¡ã€ã«ãèªã¿èŸŒãã§å å·¥ããŠcsvãã¡ã€ã«ãšããŠåºåãããŸã§ãæžããŠã¿ãããšæããŸãã, æ軜ã«ç°å¢æ§ç¯ã§ããPythonãã©ãããã©ãŒã ã§ãããAnacondaãã®ã€ã³ã¹ããŒã©ãŒãããŠã³ããŒãããŸããäžå€®ã®ã¿ããããWindowsããéžã³ãç¹å¥ãªäºæ ãç¡ããã°éããã«ææ°ã®Ver3.7ãéžã³ãç¶ããŠãDownloadããã¿ã³ãæŒããšãããŠã³ããŒããå§ãŸããŸãã, â»600MGçšåºŠãšãªããªãã®éããªã®ã§ãããŠã³ããŒãã«ã¯å°ãæéãããããããããŸããã, ããŠã³ããŒããããã¡ã€ã«ãå®è¡ããŸãã2019幎5ææç¹ã§ã®ãã¡ã€ã«åã¯ãAnaconda3-2019.03-Windows-x86_64.exeãã§ãããã»ããã¢ããç»é¢ã§ã¯ç¹å¥ãªäºæ ãç¡ããã°åæèšå®ã®ãŸãŸãNextããã¿ã³ãæŒããŠé²ãã§ããã§ãããã€ã³ã¹ããŒã«å ã®ãã£ã¬ã¯ããªãã¹ã¯ã¹ããŒã¹ïŒç©ºçœïŒããªãæ¹ãæãŸãããšã®ããšãªã®ã§ãä»åã¯ãC:\Anaconda3ããšãããã£ã¬ã¯ããªãäœã£ãŠæå®ããŠã€ã³ã¹ããŒã«ããŸããã, AnacondaïŒPythonïŒã§ExcelãåŠçããã«ã¯å°çšã®ã©ã€ãã©ãªãå¿ èŠã§ããExcelåŠçç³»ã®ã©ã€ãã©ãªã¯ãpandas, xlwt, xlrd, openpyxl, XlsxWriterãªã©å€æ°ãããŸãã®ã§ããã£ãšç¹åŸŽã䞊ã¹ãŠã¿ãŸãã, â»è©³çŽ°ã¯èªã¿èŸŒãã§ããªãã®ã§ãéçºè ã¢ã«ãŠã³ããšãŠãŒã¶ãŒã¢ã«ãŠã³ããåºå¥ãããã«ãšãã«èª²éããããã©ãããããŒãžã§ã³ç®¡çããŠãŒã¶ãŒéã§ã©ããªãããã®ãããªã©ã®å®åçãªè«ç¹ã¯åãããŸããã, â»ä»ã«ããpyvotããšããã©ã€ãã©ãªããããŸããããé·ããæŽæ°ããªããããªã®ã§å²æããŸããã, ç¹åŸŽããã£ãšèŠãæããèšç®ã ããããªãpandasäžæã§ãExcelãã¡ã€ã«ã§ãªããã«åºåããå Žåã¯openpyxlãXlsxWriterã䜿ãã€ã¡ãŒãžã§ãããããpyxllã¯çºæ³ãå¥æãããŠèå³ãæã¡ãŸãããããã®å Žã§ã¯å²æããŸãã, ãšããããšã§ãPandasãå ¥ããŠã¿ãããšæããŸãããŸããã以å€ã«ããŒã¿åæç³»ã®æäœéã®ã©ã€ãã©ãªãšããŠãnumpy, matplotlib, Jupiter Notebookã¯å ¥ããããšããã§ãã, ã€ã³ã¹ããŒã«ããã«ã¯ãAnacondaã®äžã«å ¥ã£ãŠãããANACONDA NAVIGATORããèµ·åããŸãã, å·Šã¿ããããEnvironmentsããéžã¶ãšåçš®ã©ã€ãã©ãªã衚瀺ãããã®ã§ãäžå€®äžã®ãã«ããŠã³ã«ãŠãAllããéžã³ã該åœããã©ã€ãã©ãªãå ¥ã£ãŠãããã©ããã確èªããŸãã, ã»ã»ã»pandas, numpy, matplotlib, Jupyter Notebookå šãŠã®ã©ã€ãã©ãªãã€ã³ã¹ããŒã«æžã¿ã§ããã®ã§ããã®ã¹ãããã¯äžèŠã§ããã, ã€ã³ã¿ã©ã¯ãã£ããã€ã¹ããŒãã«Pythonã³ãŒããå®è¡ã§ããJupyter Notebookãèµ·åãããã®ã§ãANACONDA NAVIGATORã®å·Šã¿ããããHomeããéžæããJupyter Notebookã®ãLaunchããã¿ã³ãæŒããŠå®è¡ããŸãã, ç¶ããŠãç»é¢ã®å³äžã«ãããNewããã¿ã³ãæŒããŠãPython 3ããéžæãããšãå¥ã¿ãã«ãŠã³ãã³ãã©ã€ã³ãéããŸããããã«ã¹ã¯ãªãããæžããŠãRunããã¿ã³ãæŒããšå®è¡ã§ããã®ã§ãããããã§ã¯äœåºŠãåãåŠçãããåæã§ã¹ã¯ãªãããã¡ã€ã«ãäœã£ãŠåŒã³åºãããšåœ¢åŒã«ããããšæããŸãã, æ¯åã³ãã³ãã©ã€ã³ããã¹ã¯ãªãããå ¥åããã®ãæéãªã®ã§ãã¹ã¯ãªãããã¡ã€ã«ãäœããŸããå¥ã®ãšãã£ã¿ã§æžããŠãè¯ãã®ã§ããããã£ããJupyter Notebookãå ¥ã£ãŠããã®ã§Jupyter Notebookã䜿ããŸãã, ããã»ã©æŒãããNewããã¿ã³ãããText FileããæŒããšå¥ã¿ãã«ãŠããã¹ããšãã£ã¿ãéããŸãããã®ãŸãŸã ãšæåãæžããŠãé»æåã°ããã§ã·ã³ã¿ãã¯ã¹ãã€ã©ã€ããå¹ããŠããªãããã§ãããäžã¿ãã®ãFileããããSaveããæŒããŠæ¡åŒµåããpyãã«ãŠä¿åããããšPythonã¹ã¯ãªãããããè²åãã«å€ãããŸãã, ãšãããããExcelãã¡ã€ã«ãéããŠcsvãšããŠåºåããæ§æãæžããŠã¿ãŸãããµã³ãã«ããŒã¿ãšããŠãe-statããã幎霢(5æ³éçŽ)ãç·å¥³å¥äººå£(å¹³æ30幎12æ確å®å€ã什åå 幎ïŒææŠç®å€ïŒãã®Excelãã¡ã€ã«ãããŠã³ããŒãããŸãŠã¿ãŸããã, xls圢åŒãšãã埮åŠãªãã©ããããã£ãã®ã¯ããŠããããªããªãPythonã§æ±ãã«ã¯æ§é ãæ±ãçæ³çãªããŒã¿ã§ãããããèªã¿èŸŒãã§ãåŠçã§ããããŒã¿ã»ããã«å€æããŠcsv圢åŒã«ãŠåºåããã¹ã¯ãªãããæžããŠã¿ãŸãããããªããããŒã¿åŠçããã«ããã£ãŠæ³šæãããç¹ã¯ã, ãšããããæžããã³ãŒãããã¡ãã暪æã¡ã®csvãšããŠåºåããåŸã«ã瞊æã¡ã«å€æããŠå床åºåããã¹ã¯ãªããã§ãã, ãªããããžãã¯ãã³ããŒãããŒãã³ãŒãã£ã³ã°ãªæååãæ£èŠãããŸãããèªã¿èŸŒããã¡ã€ã«ãããŸã綺éºãªããŒã¿ã§ã¯ãªãã§ãããã©ããå¥ã®å¹ŽåºŠã®ãã¡ã€ã«ãåŠçããããšãããä»æ§ãéã£ãŠæžãçŽããªããšãããªãé¡ã®ãã®ãšæãããã®ã§ããšããããã¯ãããªæãã§ãã, jupyterã«æ»ã£ãŠæ©éå®è¡ããŠã¿ãŸããã%run -i {fileName}ãã«ãŠããã£ãšå®è¡ã§ããŸãã, ç¹ã«åé¡ãªãå®è¡å®äºããã¹ã¯ãããã«æ»ããš2ã€ã®ãã¡ã€ã«ãã§ããŠããŸãããUTF-8ã®csv圢åŒãªã®ã§ãExcelã®ãå€éšããŒã¿ã®åã蟌ã¿ãã®ã«ã³ãåºåãã«ãŠæ©èœã§åã蟌ãã§ã¿ãŸãã, 以äžããããªæãã§ãPythonã§pandasã䜿ã£ãŠExcelãã¡ã€ã«ãèªã¿èŸŒãã§å å·¥ããŠcsvãã¡ã€ã«ãšããŠåºåãããŸã§ããšããããšã§æžããŠã¿ãŸãããã³ãŒãã®çŽ°ãã説æã¯æ¢ã«ããããããã®èšäºã«è²ããšããŠãããã§ã¯ç°å¢æ§ç¯ãã©ã€ãã©ãªæ¯èŒãããŒã¿è§£éã«å¯ããŠã®åå¿é²ãšããŸãããã©ããã®èª°ãã®åèã«ãªãã°ã幞ãã§ãã, IT&ããŒã±ãã£ã³ã°çéã§ãããžã§ã¯ããããŒãžã£ãŒãšããŠçãæ®ãããã®ãµãã€ãã«ããã¯ã2020幎9æçã, IT&ããŒã±ãã£ã³ã°çéã§æ°åå ¥ç€Ÿè ãå®å®ããŠæé·ã§ããããã®åãæ¹ãèå¯ããŠã¿ãã2020幎8æçã, Firebaseã§2åç®ã®Webã¢ããªéçºãCloud FirestoreããŒã¹ã§æ¬æ Œçã«éçºææŠãããšãã®åæã«ã€ããŠ, GASã§Google Analyticsã®ã¢ã¯ã»ã¹ãã°ïŒãŠãŒã¶ãŒãšã¯ã¹ãããŒã©æ å ±ïŒãèªåååŸããŠã¿ããUser Activity APIã, é£é é æå®ïŒãªãã® ããã¿ïŒãããªããå¿æŽå€§äœ¿ïŒçŠå³¶çæ£åçºïŒãããªãã¬ããœãåæã«å¿æŽãã人ããã€ãã£ãŒãã©ãäžå¿ã®å€èšèªããã°ãæžããŠãŸããæ¬æ¥ã¯ãã¬ããžãããžã¡ã³ããšãããŒã¿åæãšãã®äœã§ãå±ã§ãããä»ã¯å幎éã®è²å äŒæ¥äžã.
Ktm 2ã¹ã å ¬é 4, Table_exists_action Truncate | Replace éã 29, éã°ã çŸä»£ èªèš³ 9, èçŒé é«çŽ ãã¬ãŒã³ã 4, Galaxy S10 æ¥éå é»åš 11, ãªãããã³ã«ã㌠æäœã ç°¡å 24, ãã€ã¯ ããªãŒã㌠ãã«ã 亀æ 14, ããå çç¥ããªãã® 3話 åç» 6, Opencv é¡ èªè ã¢ã¶ã€ã¯ åç» 10, ããªã«d5 Mmcs å€éšåºå 10, Balmuda The Speaker ã¬ãã¥ãŒ 5, Diga Please Wait åå 14, ç³ç¥äºå· æ°Žäœ æ¿æ©åº 10, ã¡ã³ã¿ã«ãšãŒã¹ ãã¹ã æå³ 9, æ°çç§åé¡é 1幎 çã 4, é«å±±è³ªåº Cm æ 4, é»ãç æŒ ãã£ã©ã¡ã€ã¯ èžèœäºº 4, æ±äº¬å°çš® Re ã¢ãã¡åç»ããã° 4, Autocad å å解 12, ããã±ã ææ³ ãªããããããã 7, Premiere æžãåºã Mp4 軜ã 35, Galaxy S10 æ¥éå é»åš 11, ãã¹ã¯ããã æéå² å£çŽ 5, ããããã¬ãŒã ã°ãªã«é ã©ã£ã¡ 4, ã¹ãã Word å°èª¬ 6, 蟲工倧 ç·šå ¥ äœéšè« 5, Unity Scene View Wireframe 4, Oracle Date æ¥ä»ã®ã¿ 5, åŠå©Šæ€èšº äœé æžãã 13, E Tax ãšã©ãŒ Sc00x010 9, Giant Escape R3 å¡è£ 17,