Lecture: COVID-19 in Japan, python, excel ver. 7

Last Updated on April 28, 2022 by shibatau

The part III is added.

This is the page for my Local Welfare

I. All the prefectures in Japan from the data of NHK

Please download the data for the prefectures in Japan in the following page. Click on データのダウンロードはこちら on the page:


1. Aichi prefecture

You can see the scripts here:


The chart created with Pandas:

Please use Plotly express if you want to show Japanese on the chart:

II. Mie Prefecture from the data that it has published

You can get the data that Mie prefecture has published here. Click on 〇三重県で判明した感染者情報について・患者情報オープンデータはこちら on the following page.


1. Creating a line plot with Python

You can see the Python scripts in the following link, though they are not completed yet.


2.Creating a line plot with Pivot Tables in Excel

III. Creating a bar chart of the deaths per capita by prefecture from Ministry of Health, Labour and Welfare

The Data

死亡者数(累積)on https://www.mhlw.go.jp/stf/covid-19/open-data.html

Population by prefecture: https://pastebin.com/raw/9LeEAw67

1.Using Excel online

You can see the sample sheets on Excel online:


2.Using Python

The scripts are here:


Not completed yet.

About shibatau

I was born and grown up in Kyoto. I studied western philosophy at the University and specialized in analytic philosophy, especially Ludwig Wittgenstein at the postgraduate school. I'm interested in new technology, especially machine learning and have been learning R language for two years and began to learn Python last summer. Listening toParamore, Sia, Amazarashi and MIyuki Nakajima. Favorite movies I've recently seen: "FREEHELD". Favorite actors and actresses: Anthony Hopkins, Denzel Washington, Ellen Page, Meryl Streep, Mia Wasikowska and Robert DeNiro. Favorite books: Fyodor Mikhailovich Dostoyevsky, "The Karamazov Brothers", Shinran, "Lamentations of Divergences". Favorite phrase: Salvation by Faith. Twitter: @shibatau

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.