Skip to Content
Artificial Autonomy Pte. Ltd.
Artificial Autonomy Pte. Ltd.
About
Contact
Privacy Policy
1Y
RKECDX
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
Transport-Air-Planes-SIA
Transport-Sea-Containers
Transport-Sea-Ships-Voyages
Portfolio Optimization
Derivatives
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
ML-XL-000-Excel-Functions
ML-XL-010-Model(Algo(Data))-Regression-Linear
ML_XL_011_Model(Algo(Data))_Regression_Linear_Beta
Non-Linear Regression
Neural Network
Graph Neural Networks (GNN)
SVM = Support Vector Machines
Reinforcement Learning (RL)
Architecture-2017-Transformer
Fine-Tuning
Deployment
RAG = Retrieval Augmented Generation
Multi-Agent Systems
Checklist
02-Data-Extract-Transform-Load
ycat-use-chi-sq-fit
ycat-xcat-use-chi-sq-dep0
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ybin-xnum-use-regr-logistic
ynum-use-t-1s-dep0
ynum-xnum-use-2s-t-dep1-paired-prepost
ynum-xnum-use-2s-t-dep0
ynum-x1num-x2num-use-anova
Data-Load-by-Folder-File-Merge
Data-Load-by-File
Data-Quality
Data-Source-Update
Data-Transform-Delete-Columns
Data-Pivot
Data-Transform-Delete-Rows
Data-Pivot-Chart
Data-Legend
Data-Pivot-Chart-Bar-Vertical-Stacked
Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
Data-Box
Data-Histogram
Data-yNum-Bin
Data-Chart-Export
Data-Text
Data-Text-Code
Data-Image
Data-Image-Video
Data-Audio-Voice
Amazon Web Services
Microsoft Azure
Google Cloud
Alibaba Cloud
Oracle Cloud Infrastructure
Salesforce
IBM Cloud
Tencent Cloud
Huawei Cloud
Code-Excel-VBA
Code-Python
python-streamlit
iOS-AA-HelloWorld
vercel-v0-app
lovable-dev
replit.com
app.base44.com
bolt.new
bubble.io
firebase.google.com
AI-Anthropic-Claude
HR-Payroll-CPF
Edu-Rent-a-Study-Buddy
Game-Chess
Game-Chess-Jelly
Game-Chess-Belly
GCE-A-H1-8865-Mathematics
GCE-A-H2-9570-Economics
GCE-A-H2-9628-China-Studies-In-English
GCE-A-H2-9173-Geography
Products
(0)
Cart (0)
Artificial Autonomy Pte. Ltd.
Artificial Autonomy Pte. Ltd.
About
Contact
Privacy Policy
1Y
RKECDX
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
Transport-Air-Planes-SIA
Transport-Sea-Containers
Transport-Sea-Ships-Voyages
Portfolio Optimization
Derivatives
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
ML-XL-000-Excel-Functions
ML-XL-010-Model(Algo(Data))-Regression-Linear
ML_XL_011_Model(Algo(Data))_Regression_Linear_Beta
Non-Linear Regression
Neural Network
Graph Neural Networks (GNN)
SVM = Support Vector Machines
Reinforcement Learning (RL)
Architecture-2017-Transformer
Fine-Tuning
Deployment
RAG = Retrieval Augmented Generation
Multi-Agent Systems
Checklist
02-Data-Extract-Transform-Load
ycat-use-chi-sq-fit
ycat-xcat-use-chi-sq-dep0
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ybin-xnum-use-regr-logistic
ynum-use-t-1s-dep0
ynum-xnum-use-2s-t-dep1-paired-prepost
ynum-xnum-use-2s-t-dep0
ynum-x1num-x2num-use-anova
Data-Load-by-Folder-File-Merge
Data-Load-by-File
Data-Quality
Data-Source-Update
Data-Transform-Delete-Columns
Data-Pivot
Data-Transform-Delete-Rows
Data-Pivot-Chart
Data-Legend
Data-Pivot-Chart-Bar-Vertical-Stacked
Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
Data-Box
Data-Histogram
Data-yNum-Bin
Data-Chart-Export
Data-Text
Data-Text-Code
Data-Image
Data-Image-Video
Data-Audio-Voice
Amazon Web Services
Microsoft Azure
Google Cloud
Alibaba Cloud
Oracle Cloud Infrastructure
Salesforce
IBM Cloud
Tencent Cloud
Huawei Cloud
Code-Excel-VBA
Code-Python
python-streamlit
iOS-AA-HelloWorld
vercel-v0-app
lovable-dev
replit.com
app.base44.com
bolt.new
bubble.io
firebase.google.com
AI-Anthropic-Claude
HR-Payroll-CPF
Edu-Rent-a-Study-Buddy
Game-Chess
Game-Chess-Jelly
Game-Chess-Belly
GCE-A-H1-8865-Mathematics
GCE-A-H2-9570-Economics
GCE-A-H2-9628-China-Studies-In-English
GCE-A-H2-9173-Geography
Products
(0)
Cart (0)
Folder: Info
Back
About
Contact
Privacy Policy
Folder: Mkt
Back
1Y
RKECDX
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
Folder: Indus
Back
Transport-Air-Planes-SIA
Transport-Sea-Containers
Transport-Sea-Ships-Voyages
Folder: Quant
Back
Portfolio Optimization
Derivatives
Folder: Risk
Back
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
Folder: Machine
Back
ML-XL-000-Excel-Functions
ML-XL-010-Model(Algo(Data))-Regression-Linear
ML_XL_011_Model(Algo(Data))_Regression_Linear_Beta
Non-Linear Regression
Neural Network
Graph Neural Networks (GNN)
SVM = Support Vector Machines
Reinforcement Learning (RL)
Architecture-2017-Transformer
Fine-Tuning
Deployment
RAG = Retrieval Augmented Generation
Multi-Agent Systems
Folder: Analytics
Back
Checklist
02-Data-Extract-Transform-Load
ycat-use-chi-sq-fit
ycat-xcat-use-chi-sq-dep0
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ybin-xnum-use-regr-logistic
ynum-use-t-1s-dep0
ynum-xnum-use-2s-t-dep1-paired-prepost
ynum-xnum-use-2s-t-dep0
ynum-x1num-x2num-use-anova
Folder: Engineering
Back
Data-Load-by-Folder-File-Merge
Data-Load-by-File
Data-Quality
Data-Source-Update
Data-Transform-Delete-Columns
Data-Pivot
Data-Transform-Delete-Rows
Data-Pivot-Chart
Data-Legend
Data-Pivot-Chart-Bar-Vertical-Stacked
Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
Data-Box
Data-Histogram
Data-yNum-Bin
Data-Chart-Export
Folder: Data
Back
Data-Text
Data-Text-Code
Data-Image
Data-Image-Video
Data-Audio-Voice
Folder: Infra
Back
Amazon Web Services
Microsoft Azure
Google Cloud
Alibaba Cloud
Oracle Cloud Infrastructure
Salesforce
IBM Cloud
Tencent Cloud
Huawei Cloud
Folder: Audit
Back
Code-Excel-VBA
Code-Python
Folder: Dev
Back
python-streamlit
iOS-AA-HelloWorld
vercel-v0-app
lovable-dev
replit.com
app.base44.com
bolt.new
bubble.io
firebase.google.com
AI-Anthropic-Claude
Folder: Admin
Back
HR-Payroll-CPF
Folder: Edu
Back
Edu-Rent-a-Study-Buddy
Game-Chess
Game-Chess-Jelly
Game-Chess-Belly
GCE-A-H1-8865-Mathematics
GCE-A-H2-9570-Economics
GCE-A-H2-9628-China-Studies-In-English
GCE-A-H2-9173-Geography
Products
Data_Analytics_PIL_05_Data_Explore_Year2020_3D-Surface-Histogram.png
Products › Data_Analytics_PIL_05_Data_Explore_Year2020_3D-Surface-Histogram

Data_Analytics_PIL_05_Data_Explore_Year2020_3D-Surface-Histogram

SGD 0.05

https://youtu.be/VdXxoqi33Ek

In this video, I summarize our exploration of the PIL dataset after the first four videos. We confirmed that all data points are from the year 2020 and checked the mapping of countries to continents for accuracy. I highlighted that China dominates the dataset in terms of the number of containers and units, with a mean of 79 containers and 5 days, indicating a skewed distribution. I also discussed the removal of outliers and demonstrated how to bin the data for better visualization. Please review the updated statistics and consider how we can further analyze this data moving forward.

00:00 Introduction to PIL Dataset

05:04 Descriptive Statistics

07:41 Outlier Removal

10:09 Binning Observations

13:33 Conclusion and Next Steps

https://youtu.be/VdXxoqi33Ek

In this video, I summarize our exploration of the PIL dataset after the first four videos. We confirmed that all data points are from the year 2020 and checked the mapping of countries to continents for accuracy. I highlighted that China dominates the dataset in terms of the number of containers and units, with a mean of 79 containers and 5 days, indicating a skewed distribution. I also discussed the removal of outliers and demonstrated how to bin the data for better visualization. Please review the updated statistics and consider how we can further analyze this data moving forward.

00:00 Introduction to PIL Dataset

05:04 Descriptive Statistics

07:41 Outlier Removal

10:09 Binning Observations

13:33 Conclusion and Next Steps

We provide consulting and auditing services in
Data Analytics, Quantitative Research, Technology

Artificial Autonomy Pte. Ltd.
UEN 201512111K

Contact

work@artificial-autonomy.com
+65 9172 4555