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_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

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