Skip to Content
Artificial Autonomy Pte. Ltd.
Artificial Autonomy Pte. Ltd.
Home
About
Contact
Privacy Policy
Macro
Multi-Factor-Risk-Model
Risk-Parity
RKECDX-YTD
RKECDX-1Y
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
RKE-Fund-Switch
News
Portfolio Optimization
Derivatives
DOPRG
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
Counting-Permutations-Combinations
Model-Binomial
Matrix
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
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ynum-use-t-1s-dep0
ynum-x1num-x2num-use-anova
XL-Data-Load-by-Folder-File-Merge
XL-Data-Load-by-File
XL-Data-Quality
XL-Data-Source-Update
XL-Data-Transform-Delete-Columns
XL-Data-Pivot
XL-Data-Transform-Delete-Rows
XL-Data-Pivot-Chart
XL-Data-Legend
XL-Data-Pivot-Chart-Bar-Vertical-Stacked
XL-Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
XL-Data-Box
XL-Data-Histogram
XL-Data-yNum-Bin
XL-Data-Chart-Export
Data-Modality-Multi
Data-Text
Data-Text-Docs
Data-Text-Image
Data-Text-Image-Video
Data-Text-Audio-Voice
Transport-Air-Planes-SIA
Transport-Land-Cars-Used
Transport-Sea-Containers
Transport-Sea-Containers-Ports-Vessels-Latency
Transport-Sea-Ships-Fuel-CO2
Goods-Consumer-Moving-Fast
Goods-Consumer-Moving-Fast-Snacks-TW
Google Cloud
iOS-AA-HelloWorld
www-app-chat-convex
www-app-vercel-v0
www-app-replit
www-app-lovable
www-app-base44
python-streamlit
python-pandas
python-files
python-functions
R
R-class
R-vector
R-function
R-sapply
R-dataframe
AI-Anthropic-Claude
AI-Objective
AI-Risk
AI-Governance
Code-Excel-VBA
Code-Python
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.
Home
About
Contact
Privacy Policy
Macro
Multi-Factor-Risk-Model
Risk-Parity
RKECDX-YTD
RKECDX-1Y
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
RKE-Fund-Switch
News
Portfolio Optimization
Derivatives
DOPRG
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
Counting-Permutations-Combinations
Model-Binomial
Matrix
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
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ynum-use-t-1s-dep0
ynum-x1num-x2num-use-anova
XL-Data-Load-by-Folder-File-Merge
XL-Data-Load-by-File
XL-Data-Quality
XL-Data-Source-Update
XL-Data-Transform-Delete-Columns
XL-Data-Pivot
XL-Data-Transform-Delete-Rows
XL-Data-Pivot-Chart
XL-Data-Legend
XL-Data-Pivot-Chart-Bar-Vertical-Stacked
XL-Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
XL-Data-Box
XL-Data-Histogram
XL-Data-yNum-Bin
XL-Data-Chart-Export
Data-Modality-Multi
Data-Text
Data-Text-Docs
Data-Text-Image
Data-Text-Image-Video
Data-Text-Audio-Voice
Transport-Air-Planes-SIA
Transport-Land-Cars-Used
Transport-Sea-Containers
Transport-Sea-Containers-Ports-Vessels-Latency
Transport-Sea-Ships-Fuel-CO2
Goods-Consumer-Moving-Fast
Goods-Consumer-Moving-Fast-Snacks-TW
Google Cloud
iOS-AA-HelloWorld
www-app-chat-convex
www-app-vercel-v0
www-app-replit
www-app-lovable
www-app-base44
python-streamlit
python-pandas
python-files
python-functions
R
R-class
R-vector
R-function
R-sapply
R-dataframe
AI-Anthropic-Claude
AI-Objective
AI-Risk
AI-Governance
Code-Excel-VBA
Code-Python
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
Home
About
Contact
Privacy Policy
Folder: Mkt
Back
Macro
Multi-Factor-Risk-Model
Risk-Parity
RKECDX-YTD
RKECDX-1Y
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
RKE-Fund-Switch
News
Folder: Quant
Back
Portfolio Optimization
Derivatives
DOPRG
Folder: Risk
Back
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
Folder: Math
Back
Counting-Permutations-Combinations
Model-Binomial
Matrix
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
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ynum-use-t-1s-dep0
ynum-x1num-x2num-use-anova
Folder: Engineering
Back
XL-Data-Load-by-Folder-File-Merge
XL-Data-Load-by-File
XL-Data-Quality
XL-Data-Source-Update
XL-Data-Transform-Delete-Columns
XL-Data-Pivot
XL-Data-Transform-Delete-Rows
XL-Data-Pivot-Chart
XL-Data-Legend
XL-Data-Pivot-Chart-Bar-Vertical-Stacked
XL-Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
XL-Data-Box
XL-Data-Histogram
XL-Data-yNum-Bin
XL-Data-Chart-Export
Folder: Data
Back
Data-Modality-Multi
Data-Text
Data-Text-Docs
Data-Text-Image
Data-Text-Image-Video
Data-Text-Audio-Voice
Folder: Indus
Back
Transport-Air-Planes-SIA
Transport-Land-Cars-Used
Transport-Sea-Containers
Transport-Sea-Containers-Ports-Vessels-Latency
Transport-Sea-Ships-Fuel-CO2
Goods-Consumer-Moving-Fast
Goods-Consumer-Moving-Fast-Snacks-TW
Folder: Infra
Back
Google Cloud
Folder: Dev
Back
iOS-AA-HelloWorld
www-app-chat-convex
www-app-vercel-v0
www-app-replit
www-app-lovable
www-app-base44
python-streamlit
python-pandas
python-files
python-functions
R
R-class
R-vector
R-function
R-sapply
R-dataframe
AI-Anthropic-Claude
Folder: Ethics
Back
AI-Objective
AI-Risk
AI-Governance
Folder: Audit
Back
Code-Excel-VBA
Code-Python
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_00_Data_Explore_Clarify.png
Products › Data_Analytics_PIL_00_Data_Explore_Clarify.xlsm

Data_Analytics_PIL_00_Data_Explore_Clarify.xlsm

SGD 0.00

https://studio.youtube.com/video/lt4gM90JDzA/edit

Hi everyone, in this video, I walk you through the PIL dataset that I've opened in Excel, which contains about 23,000 rows and 9 columns. We explore the data, noting the need for some cleaning, particularly converting the month to a date format and checking the mapping between continents and countries. I also highlight the different container types and movement types, suggesting we might want to relabel the movement types for clarity. Please take note of these data cleaning tasks as we move forward with our analysis.

00:00 Introduction to PIL Dataset

02:01 Data Overview and Structure

03:51 Data Cleaning Considerations

05:29 Units and Measurements Discussion

https://studio.youtube.com/video/lt4gM90JDzA/edit

Hi everyone, in this video, I walk you through the PIL dataset that I've opened in Excel, which contains about 23,000 rows and 9 columns. We explore the data, noting the need for some cleaning, particularly converting the month to a date format and checking the mapping between continents and countries. I also highlight the different container types and movement types, suggesting we might want to relabel the movement types for clarity. Please take note of these data cleaning tasks as we move forward with our analysis.

00:00 Introduction to PIL Dataset

02:01 Data Overview and Structure

03:51 Data Cleaning Considerations

05:29 Units and Measurements Discussion

As of 2026-06-01: We are a dormant company.

Data Analytics, Quantitative Research, Technology

Artificial Autonomy Pte. Ltd.
UEN 201512111K


Contact

Artificial Autonomy Pte. Ltd. | UEN 201512111K
work@artificial-autonomy.com
+65 9172 4555