Lectures: Local population in Japan
mishouYou can see the code here in Google Colaboratory: https://colab.research.google.com/drive/12mpNyDcAlUAsu5CBqnZMgc9ssqACHuS9?usp=sharing
Lectures: The results for the first questionnaires in 2023 ver. 2
I. Basic English I https://colab.research.google.com/drive/1R7H-giDP0qdsRDaIc6ndwt7DXEdNRXFQ?usp=sharing II. Computer English I https://colab.research.google.com/drive/1AOvffFt5JgyS936eF30Qgu1Y7X-EcoOC?usp=sharing III. Local Welfare You can see the result here on Google Colaboratory: https://colab.research.google.com/drive/1qbdRzGX2tAJJY9xG9WPgpGqN7mVvcAM3?usp=sharing
Lecture: Reading a table in a PDF and merging data frames using Excel or Python, vlookup, tabula-py
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…
Excel: How to ask ChatGPT ver. 3
I. If you don't know how to ask ChatGPT about Excel usage, why don't you ask ChatGPT? I typed: I want to ask you about how to use Excel but…
Lectures: Assignment 1
I. Assignment 1 Copy the ten news headlines in the "Most read" section on the BBC top page and paste them on MS Excel. Create such a table (10 x…
Lectures: How to use Google Sheets
I. Google Sheets tips You can learn Google Sheets tips here: 40 Advanced Google Sheets Tips for Marketing Pros I have created some sheets using the tips above and add…
Lectures: Retrieving texts from Youtube video, googletrans, youtube_transcript_api, youtube_dl, speech_recognition
I. What will you learn? You can learn how to get English and Japanese texts from a Youtube video in this post. When Closed Caption is enabled, you can use…
Lectures: Japan Government Budget
I.2019年度予算と年金資金の流れ 1.予算 金利は低く株価は高くが国民のため？ 遠のく財政健全化 19年度予算案101兆円 2.年金の資金の流れ https://www.mhlw.go.jp/file/06-Seisakujouhou-12500000-Nenkinkyoku/0000102243.pdf II.2020年度予算と補正予算 1.予算 https://www3.nhk.or.jp/news/special/yosan2020/ 2.補正予算 https://www3.nhk.or.jp/news/html/20201215/k10012765931000.html III.2021年度予算 https://www3.nhk.or.jp/news/special/yosan2021/ IV.GDPの推移 https://www3.nhk.or.jp/news/html/20210518/k10013036691000.html V.関連リンク ＥＴＦ ６．５兆円過去最高 日銀の株式買い、歯止めなく 教えて！年金積立金運用 どのように運用されているの？ 我が国の財政事情
Keys and commands in my new environment ver. 3
KEYS AND COMMANDS II.1.Alacritty II.2.trash_cli II.3.Linux/Unix commands II.4.Fish II.5.Vim key bindings II.6.Neovim II.7.Ranger II.8.RStudio II.9.Brave Browser & Vimium I. My environment OS Garuda Linux i3WM on iMac. Terminal & Shell…
Lectures: Simulations for the Monty Hall Problem
Question: Stay or switch?