ð CSVâJSON倿
CSV圢åŒã®ããŒã¿ãJSONé åã«ããŸãã¯JSONé åãCSV圢åŒã«å€æã§ããããŒã«ã§ããã¹ãã¬ããã·ãŒãã®ããŒã¿ãAPIãããã°ã©ã ã§æ±ãããã圢åŒã«å€æããããéã«JSONããŒã¿ã衚èšç®ãœããã§éãã圢åŒã«ãããããéã«äŸ¿å©ã§ãã
äœ¿ãæ¹
- ãCSVâJSONããŸãã¯ãJSONâCSVãã®å€ææ¹åãéžã³ãŸãã
- 倿ãããããŒã¿ãå ¥åæ¬ã«è²Œãä»ããŸã(CSVã®å Žåã¯1è¡ç®ãèŠåºãè¡ãšããŠæ±ããŸã)ã
- å€æçµæãäžã®æ¬ã«èªåçã«è¡šç€ºãããŸãããã³ããŒããã¿ã³ã§ã³ããŒã§ããŸãã
èšç®ã®ä»çµã¿
CSVïŒComma-Separated ValuesïŒã¯ã1è¡ã1ä»¶ã®ããŒã¿ãã«ã³ãã§åºåãããåå€ã1ã€ã®é ç®ãšãã衚圢åŒã®ããã¹ãã§ãããã®ããŒã«ã§ã¯1è¡ç®ãèŠåºãïŒé ç®åïŒãšããŠæ±ãã2è¡ç®ä»¥éã®åè¡ããé ç®å: å€ãã®çµãæã€JSONãªããžã§ã¯ãã«å€æããŠãå šäœãJSONé åã«ããŸãã CSVã®çްããæžåŒã¯ RFC 4180 ã§ãŸãšããããŠããŸããå€ã®äžã«ã«ã³ããæ¹è¡ãå«ãããå Žåã¯ããã«ã¯ã©ãŒãã§å²ã¿ãå€ã®äžã®ããã«ã¯ã©ãŒãèªäœã¯2ã€éããŠïŒ""ïŒè¡šããŸãããã®ããŒã«ã¯ãã®èŠåã«åŸã£ãŠã"æ±äº¬, æžè°·åº" ã®ããã«ã¯ã©ãŒãã§å²ãŸããå€ã®äžã®ã«ã³ããåºåããšããŠæ±ããŸããã JSONããCSVãžã®å€æã§ã¯ãé åå ã®ãã¹ãŠã®ãªããžã§ã¯ãã®ããŒãéããŠèŠåºãè¡ãäœããŸãããããªããžã§ã¯ãã«ååšããªãããŒã®åã¯ç©ºæ¬ã«ãªããŸãã
èšç®äŸ
次ã®CSVã倿ããå Žå åå,幎霢,äœæ ç°äž,32,"æ±äº¬, æžè°·åº" äœè€,28,å€§éª å€æçµæã®JSON [ {"åå": "ç°äž", "幎霢": "32", "äœæ": "æ±äº¬, æžè°·åº"}, {"åå": "äœè€", "幎霢": "28", "äœæ": "倧éª"} ] ãæ±äº¬, æžè°·åºãã¯ã¯ã©ãŒãã§å²ãŸããŠãããããéäžã®ã«ã³ãã§åå²ãããã«1ã€ã®å€ãšããŠæ±ãããŸãã
䜿çšäžã®æ³šæ
- CSVã®å€ã¯ãã¹ãŠæååãšããŠå€æãããŸããæ°å€ãçåœå€ãšããŠæ±ãããå Žåã¯ã倿åŸã«åã調æŽããŠãã ããã
- Excelã§ä¿åããCSVã¯ãæåã³ãŒããShift_JISã«ãªã£ãŠããããšããããŸããæååãããå Žåã¯UTF-8ã§ä¿åãçŽããŠãã ããã
- JSONããã®å€æã§ã¯ããã¹ããããªããžã§ã¯ãã¯ã[object Object]ããšããæååã«ãªã£ãŠããŸããŸããå ¥ãåã®ããŒã¿ã¯ããããããå¹³ããªåœ¢ã«å±éããŠãã倿ããŠãã ããã
- å€ã®äžã«æ¹è¡ãå«ãCSVïŒã¯ã©ãŒãå ã®æ¹è¡ïŒã«ã¯å¯Ÿå¿ããŠããŸããã1ä»¶ã®ããŒã¿ã¯1è¡ã§å ¥åããŠãã ãããã¿ãåºåãïŒTSVïŒãã»ãã³ãã³åºåãã«ã察å¿ããŠããŸããã
ãããã質å
ããã«ã¯ã©ãŒãã§å²ãŸããã«ã³ãå ¥ãã®CSVã«ã察å¿ããŠããŸãã?
ã¯ãã"æ±äº¬, æžè°·åº"ã®ããã«ããã«ã¯ã©ãŒãã§å²ãŸãããã£ãŒã«ãå ã®ã«ã³ãã¯ãåºåãæåãšããŠæ±ããæ£ãã1ã€ã®å€ãšããŠè§£éããŸãã
JSONâCSV倿ã§ããªããžã§ã¯ãããšã«ããŒãç°ãªãå Žåã¯ã©ããªããŸãã?
å šãªããžã§ã¯ãã®ããŒãéçŽããŠèŠåºãè¡ãäœæããååšããªãããŒã®å€ã¯ç©ºæ¬ãšããŠåºåããŸãã
倿ã«å€±æããå Žåã¯ã©ãããã°ããã§ãã?
JSONâCSV倿ã§ã¯ãå ¥åãæå¹ãªJSONé å(ãªããžã§ã¯ãã®é å)ã§ããå¿ èŠããããŸããæ§æãšã©ãŒããªãã確èªããŠãã ããã