Part I of a two part tutorial illustrating how to use Python and R in the same Jupyter notebook within Google Colab. This first video walks through how to conduct exploratory data analysis with Python, while the next video show how to model with R.
GitHub repo containing the notebook - https://github.com/tudev/Workshops-2020-2021
OBJECTIVE: Infer which explanatory variables significantly affect the size of trees within Duke Forest. Tree health can be used as a proxy for the overall health of the forest.
DATA DICTIONARY:
ID - Unique tree identifier.
yr - Year of the diameter recording.
cm - Measurement of the diameter of a tree's base. Measurements are made at breast height marked by a nail that holds a tag indicating the identifying tree number. This is the response variable.
annualprec - Total precipitation within the year.
summerpdsi - Palmer Drought Severity Index for the summer. Uses readily available temperature and precipitation data to estimate relative dryness.
wintertemp - Average winter (Jan. - Mar.) temperature.
CONNECT:
LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/
GitHub: https://github.com/ad17171717
Twitter: https://twitter.com/DolinayG
------Video Chapters------
0:00 - Intro
0:50 - Background on Data Set
2:19 - Loading Excel File onto Google Colab
2:47 - Reading Excel File into a pandas DataFrame
5:10 - Calculating Number of Trees Measured per Year
8:16 - Creating a Percentage Change Column
11:46 - Graphing a Correlation Heat Map with Seaborn
16:37 - Graphing a Pair Plot with Seaborn
19:05 - Graphing a Histogram with Matlplotlib
24:59 - Labeling Trees by Size
27:30 - Visualizing clustering with Plotly
...
https://www.youtube.com/watch?v=ws6eWf2LeRg
Tutorial on coding out descriptive statistics in Python. Learn how to analyze data sets using descriptive statistics, code out the mean, median & mode by hand within Python and graph out histograms to visualize the data.
GitHub repo containing the notebook under the "Statistics with Python" directory - https://github.com/ad17171717/YouTube-Tutorials
CONNECT:
LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/
GitHub: https://github.com/ad17171717
Twitter: https://twitter.com/DolinayG
Odysee: https://odysee.com/@adriandolinay:0
|-Video Chapters-|
0:00 - Intro
0:14 - Descriptive Statistics
0:46 - Central Tendency
1:08 - Scenario: Housing Prices
1:38 - Calculating and coding the arithmetic mean
6:26 - Calculating and coding the median
11:38 - Calculating and coding the mode
13:47 - Analyzing the data using the mean, median and mode
15:22 - Time varying data and the change of the distribution's shape
16:30 - References and additional learning
...
https://www.youtube.com/watch?v=5cKcTmQiz1A
To freeze a pane, select the cells and type "Alt + w + f + r". To unfreeze the panes, type "Alt + w + f + f".
CONNECT:
LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/
GitHub: https://github.com/ad17171717
Twitter: https://twitter.com/DolinayG
Odysee: https://odysee.com/@adriandolinay:0
...
https://www.youtube.com/watch?v=bwQuaVCWon0
Saving a pandas DataFrame to csv format.
The notebook can be found in the "YouTube Shorts" folder within the below repo.
GitHub Repo - https://github.com/ad17171717/YouTube-Tutorials
CONNECT:
LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/
GitHub: https://github.com/ad17171717
Twitter: https://twitter.com/DolinayG
Odysee: https://odysee.com/@adriandolinay:0
...
https://www.youtube.com/watch?v=1j5cDXak_ys
Tutorial on updating Python packages within Google Colab.
The notebook can be found in the "Google Colab Tutorials" folder within the below repo. GitHub Repo - https://github.com/ad17171717/YouTube-Tutorials
CONNECT:
LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/
GitHub: https://github.com/ad17171717
Twitter: https://twitter.com/DolinayG
Odysee: https://odysee.com/@adriandolinay:0
|-Video Chapters-|
0:00 - Intro
0:10 - Check Python package version
0:26 - Upgrading a package
1:06 - References and additional learning
...
https://www.youtube.com/watch?v=lHMRQP2HUmw
Brief tutorial on refreshing data sources within a Tableau Desktop Workbook. As of April 2022, refreshing data sources within Tableau Desktop is done manually.
The notebook can be found in the "Data Visualization with Tableau" folder within the below repo.
GitHub Repo - https://github.com/ad17171717/YouTube-Tutorials
CONNECT:
LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/
GitHub: https://github.com/ad17171717
Twitter: https://twitter.com/DolinayG
------Video Chapters------
0:00 - Intro
0:56 - Refreshing data source within Tableau Desktop
1:58 - Conclusion
...
https://www.youtube.com/watch?v=od2igrYEbt4
Tutorial on modeling dividend discount models within Python. Learn how to scrape financial data and create Gordon growth & Multistage dividend discount models.
The notebook can be found in the "Finance with Python" folder within the below repo.
GitHub Repo - https://github.com/ad17171717/YouTube-Tutorials/tree/main/Finance%20with%20Python
CONNECT:
LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/
GitHub: https://github.com/ad17171717
Twitter: https://twitter.com/DolinayG
------Video Chapters------
0:00 - Intro
0:41 - Definition of dividend discount model
1:35 - Definition of Gordon growth model
4:38 - Cost of equity calculation
9:20 - Dividend growth rate calculation
10:51 - Modeling the Gordon growth model
12:18 - Varying the parameters of the Gordon growth model
15:08 - Definition of multistage dividend discount model
16:51 - Modeling the multistage dividend discount model
27:28 - Varying the parameters of the multistage dividend discount model
28:56 - Testing our Python function with different stocks
32:24 - References and additional learning
...
https://www.youtube.com/watch?v=G5ko7rLqjhk