I. Getting a ticker from Yhoo! finance II. Retriving the data import yfinace as yf # load the data nikkei225 = yf.download(tickers = "NIY=F", start = "2018-03-30", end = "2023-03-30",…
I. Using Macros on Google Sheets Let’s load the data from the following URL for the raw CSV data using Macro and create two histograms for the “english” and “japanese”…
I. If functions in Google Sheets Sample 1 Sample 2 At A1=importdata(“https://pastebin.com/raw/cSZ8pYWh”) At H2=average(B2,C2) At I2=if(H2<30,”Failed”,(if(H2<50,”C”,(if(H2<70,”B”,(if(H2<90,”A”,(if(H2<=100,”S”))))))))) You can see the sheets here: https://docs.google.com/spreadsheets/d/1fbs69LCn2SAPdcQQ_nehb8vn-ETL2x2uQNePp7M5A9k/edit?usp=sharing II. If statements in Python Sample 1…
I. For loops II. While loops You can sees the scripts here: https://colab.research.google.com/drive/1ezBPp2m551xItS6me7rNOVTz3UF-UyNt?usp=sharing Not completed yet.
I. For loops II. While loops You can sees the scripts here: https://colab.research.google.com/drive/1ezBPp2m551xItS6me7rNOVTz3UF-UyNt?usp=sharing
I. Creating charts on Google Sheets Here is the data: https://pastebin.com/raw/cSZ8pYWh 1.Histogram 2. Bar chart grouped by nationality using Pivot Table 3.Scatter plot This might be interesting but cumbersome. You…
I. What is Flash Fill in Excel? Here are some samples. You can learn Flash Fill in Excel here: https://www.excel-easy.com/examples/flash-fill.html II. Python does what Flash Fill does Sample 1 Python…
I. Creating pivot tables in Google Sheets Sample 1: Attendance Sample 2: Questionnaire Sample 3: Exam resykts You can see the pivot tables here: https://docs.google.com/spreadsheets/d/1gZtgnRSkkx0ymXSgNE__WX7W4YIF3W0chUJvT2U63b4/edit?usp=sharing II. Creating pivot tables with…
I. The tables These are the sample datasets for the lectures. 1.HTML tables These are sample datasets for learning Python with Cheat Sheets. Table 1 Table 2 Table 3 2.CSV…
Work in progress. I. Classes and objects Class: The class is a user-defined data structure that binds the data and methods into a single unit. You can create objects with…
mishou