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:

https://colab.research.google.com/drive/1E4AUtEXN4QJH4lh4v_FLKFj6EszIPJKo?usp=sharing

III. Excel (deaths)

Using VLOOKUP

What the VLOOKUP function does:

Creating a bar chart

You can see the data, functions, and chart here in Excel Online (work in progress):

https://1drv.ms/x/s!AmlzIpnp3h4-kA_ot-oP5zpo3v59?e=QWaH8h

You can learn more about VLOOKUP here:

https://www.excel-easy.com/examples/vlookup.html

By mishou

Leave a Reply

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