I. The data 各都道府県の検査陽性者の状況 (PDF) 第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…
Work in progress. I. What shall we learn? Retrieving the data from the images on the pages linked on a web page. II. Downloading image files You can see the…
I. The data The data is here: https://www.worldometers.info/coronavirus/ II. Scraping the data III. Creating a bar chart Here is the code for creating a bar chart using Plotly Express. The…
I. The sample data set II. Grouped by nationality III. MultiIndex Columns flattened You can see the code here on Google Colaboratory: https://colab.research.google.com/drive/1Wg3VBWwA1Rg-il41inVCnVB7Aoo53bLz?usp=sharing You can learn more about how to…
I. Setting ups for Vim keybindings Select "vim" at Tools>Settings>Editor>Key bindings>vim II. Using Vim keybindings 1. Create or select a cell Create a new code cell belowCtrl + m, b…
Work in progress. I. Retriveing the data Let's load the historical data of NASDAQ Composite, Dow Jones Industrial Average, and S&P 500 using yfinance and create a dictionary of the…
I. Creating classes The following code creates an Asset class to represent individual assets, and an AssetManager class to manage a collection of assets. class Asset: def __init__(self, name, category,…
I. Getting a ticker from Yhoo! finance II. Retriving the data # create subplots from plotly.subplots import make_subplots import plotly.graph_objects as go fig = make_subplots(rows=3, cols=1,subplot_titles=("Nikkei225","Toyota", "Fast Retailing")) fig.append_trace(go.Scatter( x=nikkei225.index,…
Work in progress. 1. Basics 1 Self-taught learning2. Basics 2 Making your cheat sheets3. Basics 3 Google Colaboratory4. Basics 4 Mathematical operators5. Basics 5 Autofill and List Comprehensions6. Basics 6 Tables7. Basics 7 Classes and Objects8. Basics…
Work in progress. 1. Basics 1 Self-taught learning2. Basics 2 Making your cheat sheets3. Basics 3 Google Colaboratory4. Basics 4 Mathematical operators5. Basics 5 Autofill and List Comprehensions6. Basics 6 Tables7. Basics 7 Classes and Objects8. Basics…
mishou