Lectures: Local population in Japan
mishouYou can see the code here in Google Colaboratory: https://colab.research.google.com/drive/12mpNyDcAlUAsu5CBqnZMgc9ssqACHuS9?usp=sharing
Python: Leaning Polors ver. 1
I. Running code in Google Colaboratory You can see the sample code here: https://colab.research.google.com/drive/1jNj4GpUfR2mYJjffN2KSZFRZzv5xfwID?usp=sharing Here are some charts created with Plotly Express: II. References https://franzdiebold.github.io/polars-cheat-sheet/Polars_cheat_sheet.pdf https://towardsdatascience.com/visualizing-polars-dataframes-using-plotly-express-8da4357d2ee0 https://plotly.com/python/
Python: Create a Joy Plot
I. What is Joy Plot? https://www.youtube.com/watch?v=dkOaBlIKSkY&list=PLnif9Rfb5AdkmxSH3fAMsozp5eTnSqBYf Joy Plot, a ridgeline plot, is a visualization technique for plotting a repetitive signal. The name “joy plot” is derived from “Joy Division,” the…
Python: ChatGPT shows how to analyze “Strange Case of Dr. Jekyll and Mr. Hyde”
I typed: Tell me who wrote this, Mr. Utterson the lawyer was a man of a rugged countenance that was never lighted by a smile; cold, scanty and embarrassed in…
Python: Learning how to scrape the MOST READ stories in BBC News from ChatGPT
I. Ask ChatGPT about how to scrape the headlines of the most-read stories Copy the element on the web page. Tell ChatGPT to show the Python code for scraping the…
Python: Run a Terminal in Google Colab
You can run a Terminal in Google Colaboratory without Colab Pro. Just run a few codes: # install colab-xterm !pip install colab-xterm # load extensions %colab-xterm extension # open the…
Lecture: How to use Pivot Table in Excel
I. A sample data file (CSV) 2023localWelfareQnn1Download II. Creating a pivot table and a pie chart in Excel You can see the Excel sheets here: 2023localWelfareQnn1
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
Finance: Leaning Stochastic Oscillator, python, yfinance, pandas_ta, plotly.graph_objects
I. Using yfinance + dictionary + matplotlib I.1. Getting historic pricing data using yfinance Load the data and get the pricing data for NASDAQ: !pip install yfinance import yfinance as…
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…