ã€ãã«ã2019幎5æãã䜿ãããæ°ããå å·ã什åããçºè¡šãããŸãããæ°ããå å·çºè¡šã«æ¥æ¬äžã泚ç®ããŸãããããã§ããã¡æ©ãã什åãã«å¯Ÿå¿ããåæŠè¥¿æŠå€æããŒã«ãäœã£ãŠã¿ãŸãããã西æŠãå ¥åãããšåæŠã衚瀺ããããã°ã©ã ããŸããã®éã§ãåæŠãå ¥åãããšè¥¿æŠã衚瀺ããããã°ã©ã ãäœã£ãŠã¿ãŸãã
西æŠåæŠå€æããŒã«ã®ä»çµã¿ã¯ïŒ
ããã§ã¯ãæåã«è¥¿æŠãã©ã®ããã«åæŠã«å€æããã®ããèããŠã¿ãŸãããããšèšã£ãŠãç°¡åã§ãã西æŠãããã®åæŠã®éå§å¹ŽãåŒããŠ1ãè¶³ãã ãã§ãã
[西æŠããåæŠãžã®å€æåŒ]
åæŠå¹Ž = 西æŠå¹Ž - åæŠéå§å¹Ž + 1
ãã®ãããéå§å¹Žãšçµäºå¹Žã®å€æè¡šãçšæããŠãäžã€ãã€è¥¿æŠã確èªããŠããããšã«ãªããŸãã什åã®çµäºå¹Žã¯åãããªãã®ã§ã9999ãèšå®ããŠããŸãã以äžã«å€æè¡šãCSV圢åŒã§çšæããŸããããã®CSVã®è¡šãå©çšããŠè¥¿æŠãåæŠã«å€æããŸãã
åæŠ, ç¥å·, éå§å¹Ž, çµäºå¹Ž
ææ²», M, 1868, 1912
倧æ£, T, 1912, 1926
æå, S, 1926, 1989
å¹³æ, H, 1989, 2019
什å, R, 2019, 9999
西æŠããåæŠãžã®å€æããã°ã©ã
ããã§ã¯ãããã°ã©ã ãäœã£ãŠã¿ãŸãããã以äžã®ããã°ã©ã ãã西æŠããåæŠãžã®å€æããã°ã©ã ã§ããããã°ã©ã ãã³ããŒããŠããªã§ããç°¡æãšãã£ã¿ã§å®è¡ããŠã¿ãŸãããã
â»ââââââââââââââââââââââââââ
â»ãã西æŠåæŠå€æããŒã«
â»ââââââââââââââââââââââââââ
ã西æŠãå
¥åããšå°ããŠãYã«ä»£å
¥ã# --- (*1)
W=Yã西æŠåæŠå€æåŠçã
ã西æŠ{Y}幎 = {W}ããšèšãã
# 颿°ã®å®çŸ© --- (*2)
â(Yã)西æŠåæŠå€æåŠçãšã¯
ããåæŠCSV=ãåæŠ, ç¥å·, éå§å¹Ž, çµäºå¹Ž
ææ²», M, 1868, 1912
倧æ£, T, 1912, 1926
æå, S, 1926, 1989
å¹³æ, H, 1989, 2019
什å, R, 2019, 9999ã# --- (*3)
ããåæŠè¡šïŒåæŠCSVãCSVååŸã
ããïŒïŒ¹ãè±æ°åè§å€æã
ããåæŠè¡šãå埩
ãããã# 衚ããå€ãåãåºã
ããããåæŠåïŒãã[0]
ããããéå§å¹ŽïŒãã[2]
ããããçµäºå¹ŽïŒãã[3]
ãããã# æå®ãã西æŠã«è©²åœããã調ã¹ã --- (*4)
ããããããïŒéå§å¹ŽâŠYïŒãã€ïŒYïŒçµäºå¹ŽïŒãªãã°
ããããããVïŒY - éå§å¹Ž + 1
ãããããããããV=1ãªãã°ãV=ãå
ã
ããããããã{åæŠå}{V}幎ãã§æ»ãã
ãããããããŸã§ã
ãããããŸã§ã
ãããäžæãã§æ»ãã
ãããŸã§ã
ããã°ã©ã ãå®è¡ãããšè¥¿æŠå¹ŽãèãããŸãã®ã§ã2019ããªã©ãšå ¥åããŠã[OK]ãã¿ã³ãã¯ãªãã¯ããŠã¿ãŸãããããããšãåæŠã«å€æããŠè¡šç€ºãããŸãã
ããã°ã©ã ãèŠãŠã¿ãŸãããã(ïŒ1)ã§ã¯ãå°ãããåœä»€ã䜿ã£ãŠãŠãŒã¶ãŒããå€ãå ¥åããŸããæ¬¡ã«ã(ïŒ2)ã®éšåã§ã¯ãã西æŠåæŠå€æåŠçããšããååã®é¢æ°ãå®çŸ©ããŸãããã®ããã«ããŠã颿°ã«ãŸãšããŠããã°ãã³ããŒïŒããŒã¹ãããŠãå¥ã®ããã°ã©ã ã§ãæµçšããããšãã§ããŸãã
ãããŠã(ïŒ3)ã®éšåã§ãåæŠãšè¥¿æŠã®å¯Ÿå¿CSVããŒã¿ãæå®ããŠããŸãããã®åŸããªã§ããã®é åã«å€æããããã«ãCSVååŸãåœä»€ã䜿ããŸãããã®åŸããå埩ãåœä»€ã䜿ã£ãŠãäžã€ãã€ã©ã®åæŠã«å¯Ÿå¿ããã®ã確èªããŸãã(ïŒ4)ã®éšåã§ã¯ã西æŠãæå®ãã倿°Yããéå§å¹Žä»¥äžãçµäºå¹Žæªæºããå€å®ããŸãã
åæŠãã西æŠãžã®å€æããŒã«ãäœã£ãŠã¿ãã
次ã«ãå ã»ã©ãšã¯éã§ãåæŠãã西æŠã«å€æããããã°ã©ã ãäœã£ãŠã¿ãŸãããããã¡ãã¯ãCSVã®è¡šãã該åœããåæŠã®è¡šèšãæ€çŽ¢ããŠãéå§å¹ŽãçšããŠå€ãèšç®ããŸãããã®ãããèšç®åŒã¯ä»¥äžã®ããã«ãªããŸãã
[åæŠãã西æŠå¹Žãžã®å€æåŒ]
西æŠå¹Ž = åæŠå¹Ž + åæŠéå§å¹Ž - 1
ããã§ã¯ããããããã°ã©ã ããŠã¿ãŸãããã以äžã®ããã°ã©ã ãããªã§ããç°¡æãšãã£ã¿ã«è²Œãä»ããŠå®è¡ããŠã¿ãŸãããã
â»ââââââââââââââââââââââââââ
â»ããåæŠè¥¿æŠå€æããŒã«
â»ââââââââââââââââââââââââââ
ãåæŠãå
¥åããŠãã ããã
(äŸ: å¹³æ30幎ãH30)ããšå°ããŠWã«ä»£å
¥ã# --- (*1)
S=WãåæŠè¥¿æŠå€æåŠçã
ã{W}ã¯{S}幎ã§ãïŒããšèšãã
# 颿°ã®å©çšäŸ
#ã什åå
幎ããåæŠè¥¿æŠå€æåŠçããŠè¡šç€ºã
#ãH30ããåæŠè¥¿æŠå€æåŠçããŠè¡šç€ºã
# 颿°ã®å®çŸ© --- (*2)
â(Wã)åæŠè¥¿æŠå€æåŠçãšã¯
ããåæŠCSVïŒãåæŠ, ç¥å·, éå§å¹Ž, çµäºå¹Ž
ææ²», M, 1868, 1912
倧æ£, T, 1912, 1926
æå, S, 1926, 1989
å¹³æ, H, 1989, 2019
什å, R, 2019, 9999ã
ããåæŠè¡šïŒåæŠCSVãCSVååŸã
ãã# å眮åŠç --- (*3)
ããW=Wã®ãå
幎ããã1幎ãã«çœ®æã
ããW=Wãè±æ°åè§å€æã
ããWãã/\d+/ãã§æ£èŠè¡šçŸãããããŠåæŠå¹Žã«ä»£å
¥ã
ããããããããNULLãªãã°ããäžæãã§æ»ãã
ãã# ååæŠãç¹°ãè¿ã調ã¹ã --- (*4)
ããåæŠè¡šãå埩
ãããã# 衚ããå€ãåãåºã
ããããåæŠåïŒãã[0]
ããããç¥å·ïŒãã[1]
ããããéå§å¹ŽïŒãã[2]
ããããW=Wã®ç¥å·ãåæŠåã«çœ®æã
ããããåæŠïŒWã§åæŠåãäœæåç® # --- (*5)
ããããããïŒããïŒ0ïŒãªãã°
ãããããã西æŠïŒåæŠå¹ŽïŒéå§å¹Žâ1
ãããããã西æŠã§æ»ãã
ãããããããŸã§ã
ãããããŸã§ã
ãããäžæãã§æ»ãã
ãããŸã§ã
ããã°ã©ã ãå®è¡ããã什åå 幎ããããã¯ãR1ããšå ¥åããŠ[OK]ãã¿ã³ãæŒããšã2019幎ãšè¡šç€ºãããŸãã
ããã§ã¯ãããã°ã©ã ã確èªããŠã¿ãŸãããã(ïŒ1)ã®éšåã§ã¯ããŠãŒã¶ãŒã«åæŠãå ¥åããŠããããŸãã(ïŒ2)ã®éšåã§ã¯ãåæŠè¡šèšã西æŠã«å€æãã颿°ãå®çŸ©ããŸãã(ïŒ3)ã§ã¯åæŠãèšè¿°ããéã®è¡šèšã®æºããåžåãã眮æåŠçãè¡ããŸãããŸããèšç®ã楜ã«ãªãããã«ããå 幎ãã®è¡šèšã1ã«å€æããŸããæ¬¡ã«ãè±æ°åè§å€æãåœä»€ã䜿ã£ãŠãå šè§ã§æ°åãåæŠã®ç¥å·ãå ¥åããéã«ãåé¡ãªã察å¿ã§ããããã«å€æããŸãã(ïŒ4)ã®éšåã§ã¯åæŠè¡šãç¹°ãè¿ã調ã¹ãŸãããããŠã(*5)ã®éšåã§åèŽããåæŠããããã©ããã調ã¹ãŸãã
ææ²»ä»¥åã®åæŠã«ã察å¿ããããšã¯å¯èœïŒ
å¯èœã§ããããŸãå©çšããæ©äŒã¯ãªããããããŸããããäžèšã®äºã€ã®ããã°ã©ã ã®å€æ°ãåæŠCSVãã®å€ãæžãæããããšã§ãææ²»ä»¥åã®å¹Žå·ã«ã察å¿ããããšãã§ããŸãã以äžã¯ãæ±æžæä»£ã®ãæä¹ ããå æ²»ããæ ¶å¿ãã«å¯Ÿå¿ããåæŠCSVã§ãã
åæŠCSVïŒãæä¹
,*,1861,1864
å
æ²»,*,1864,1865
æ
¶å¿,*,1865,1868
ææ²», M, 1868, 1912
倧æ£, T, 1912, 1926
æå, S, 1926, 1989
å¹³æ, H, 1989, 2019
什å, R, 2019, 9999ã
ãŸãšã
以äžãä»åã¯ãæ°å¹Žå·ã«å¯Ÿå¿ããåæŠè¥¿æŠå€æããã°ã©ã ãäœã£ãŠã¿ãŸãããåæŠãšè¥¿æŠã®å¯Ÿå¿è¡šããçšæããŠããŸãã°ãæè»œã«å€æããŒã«ãäœæã§ããããšãåãããŸããããã®éã®ãã€ã³ãã¯ãååŸ©ãæ§æãå©çšããŠãäžã€ãã€åæŠã確èªããŠå€å®ããéšåã§ãã
ãŸããä»åã¯å¹Žå·ã®å€æãè¡ãããã°ã©ã ã§ãããååã®èŠç©ããæžãªã©é£ããèšç®ãå¿ èŠãªå Žé¢ã§ããå€æè¡šãªã©ãçšæããã°ãç°¡åãªããã°ã©ã ã§å€æã§ããŸããæ¬çš¿ãåèã«èªäœã®èŠç©ããããŒã«ãäœãã®ãé¢çœããšæããŸãã
èªç±åããã°ã©ããŒããããã¯ãã©ã«ãŠãããã°ã©ãã³ã°ã®æ¥œãããäŒããæŽ»åãããŠããã代衚äœã«ãæ¥æ¬èªããã°ã©ãã³ã°èšèªããªã§ããã ãããã¹ã鳿¥œããµã¯ã©ããªã©ã2001幎ãªã³ã©ã€ã³ãœãã倧è³å ¥è³ã2005幎IPAã¹ãŒããŒã¯ãªãšã€ã¿ãŒèªå®ã2010幎 OSSè²¢ç®è ç« åè³ãæè¡æžãå€ãå·çããŠããã

