This code analyse data about deliveries of the most common Czech parcel tracking providers.
📝 Analyse
- Market share across providers
- Basic aggregation functions per provider about deliveries and parcel
- Identification of the last state from the tracking per provider
- Finding anomalies
- Identification of duplicates of the tracking states per provider
- Identification of the most common provider
- Identification of the % success of on time delivered parcels
- Identification of cancelled deliveries
- Finding the missing states or bad states orders in the delivery flow
📝 Data source
| Name | Source |
|---|---|
internal eshop database |
Data about orders and customers |
providers |
Data from REST API or from FTP about deliveries from every provider |