マスターデータを基本入力ファイルにしてみる (2)

e-Stat からダウンロードした総人口データ（CSVデータ）

e-Stat は、政府統計ポータルサイトです。
https://www.e-stat.go.jp/

このサイトから、都道府県別の総人口データをダウンロードできます。

出典：都道府県・市区町村のすがた（社会・人口統計体系）
https://www.e-stat.go.jp/regional-statistics/ssdsview

Excelで開くと

メモ帳で開くと（データ部分）

"調査年 コード","調査年","地域 コード","地域","/項目","A1101_総人口【人】","注釈"
"2019100000","2019年度","00000","全国","","126,167,000",""
"2019100000","2019年度","01000","北海道","","5,250,000",""
"2019100000","2019年度","02000","青森県","","1,246,000",""
"2019100000","2019年度","03000","岩手県","","1,227,000",""
"2019100000","2019年度","04000","宮城県","","2,306,000",""
"2019100000","2019年度","05000","秋田県","","966,000",""
"2019100000","2019年度","06000","山形県","","1,078,000",""
"2019100000","2019年度","07000","福島県","","1,846,000",""
"2019100000","2019年度","08000","茨城県","","2,860,000",""
"2019100000","2019年度","09000","栃木県","","1,934,000",""
"2019100000","2019年度","10000","群馬県","","1,942,000",""
"2019100000","2019年度","11000","埼玉県","","7,350,000",""
（略）

「調査年」は、1975年度から2019年度までのデータが1ファイルとして入っています。「地域コード」は前ゼロ付きの数字5桁です（Excelで開くと、前ゼロがとれて表示されます）。