Last Updated on May 18, 2023 by mishou

I. The data

  1. 各都道府県の検査陽性者の状況 (PDF)
  2. 第2表 都道府県、男女別人口及び人口性比―総人口、日本人人口(2022年10月1日現在)(エクセル:20KB)

II. Using Python (positive cases)

You can see all the script here on Google Colaboratory:

III. Excel (deaths)


What the VLOOKUP function does:

Creating a bar chart

You can see the data, functions, and chart here in Excel Online (work in progress):!AmlzIpnp3h4-kA_ot-oP5zpo3v59?e=QWaH8h

You can learn more about VLOOKUP here:

By mishou

Leave a Reply

Your email address will not be published. Required fields are marked *