Python: Run a Terminal in Google Colab
mishouYou 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…
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…
Python: Scraping the data from linked pages using OCR ver. 2
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…
Python: Scraping COVID-19 data and create charts
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…
Python: How to flatten MultIndex Columns in Pandas
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…