#### Finace: Plot Stock Prices Using Python for beginners, plotly.express ver. 1

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",…

#### Python: Basics 14 Macros

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”…

#### Python: Basics 13 If functions

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…

#### Python: Basics 12 Loops

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.

#### Python: Basics 12 Loops

I. For loops II. While loops You can sees the scripts here: https://colab.research.google.com/drive/1ezBPp2m551xItS6me7rNOVTz3UF-UyNt?usp=sharing

#### Python: Basics 11 Charts

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…

#### Python: Basics 10 Flash fill

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…

#### Python: Basics 8 Pivot_table

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…

#### Python: Basics 9 Sample Data Sets

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…

#### Python: Basics 7 Classes and Objects

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…