中欧班列货物出口量分析数据

通过“智慧联运管理平台”系统采集货物出口预约进场数据，分析各个线路每月货物出口变化趋势，更加清晰地了解不同班列每月出口货物总体情况，用于企业合理高效地规划调度列车的排班计划，提升中欧班列运输效能。1、数据采集：通过“智慧联运管理平台”系统采集货物出口预约进场数据，包括订单编号、集装箱编号、客户名称、班列编号、线路方向、出境口岸等数据；2、数据处理：对采集到的数据进行清洗、分类和汇总，对客户名称、班列编号进行匿名化处理；3、数据加工：使用SUMIFS函数，计算本月该线路的月累计20GP箱数、月累计20HQ箱数、月累计40GP箱数、月累计40HQ箱数、月累计45GP箱数；通过公式计算：本月该线路货运出口量=x1*25+x2*28+x3*54+x4*68+x5*80，x1、x2、x3、x4、x5分别是：月累计20GP箱数、月累计20HQ箱数、月累计40GP箱数、月累计40HQ箱数、月累计45GP箱数，25、28、54、68、80根据不同型号集装箱容积设置；该线路本月货运出口占比=本月该线路的货运出口量/本月货运出口总量；货运出口量环比增长率=（本月该线路的货运出口量-上月该线路的货运出口量）/上月该线路的货运出口量；4、数据应用：分析各个线路每月货物出口指数环比、占比变化趋势，更加清晰的了解不同班列每月出口货物量情况，帮助中欧班列更加合理高效的规划进出口班列安排，提高运输效能。

This dataset is collected via the "Smart Intermodal Management Platform" system to gather cargo export appointment and entry data, analyze the monthly export volume trend of each route, and gain a clearer understanding of the overall monthly cargo export status of different trains, so as to help enterprises reasonably and efficiently plan train scheduling and improve the transportation efficiency of China-Europe Railway Express. 1. Data Collection: Collect cargo export appointment and entry data through the "Smart Intermodal Management Platform" system, including order number, container ID, customer name, train number, route direction, exit port and other related information. 2. Data Processing: Clean, classify and summarize the collected data, and perform anonymization processing on customer names and train numbers. 3. Data Calculation: Use the SUMIFS function to calculate the month-to-date (MTD) 20GP container count, MTD 20HQ container count, MTD 40GP container count, MTD 40HQ container count and MTD 45GP container count of the current month for this route. Calculate the monthly cargo export volume of the route via the formula: Monthly cargo export volume of the route = x1*25 + x2*28 + x3*54 + x4*68 + x5*80, where x1, x2, x3, x4, x5 respectively refer to the MTD 20GP, 20HQ, 40GP, 40HQ and 45GP container counts, and the values 25, 28, 54, 68, 80 are set based on the volume capacity of corresponding container types. The monthly cargo export proportion of the route = Monthly cargo export volume of the route / Total monthly cargo export volume. The month-on-month growth rate of cargo export volume = (Monthly cargo export volume of the current month - Monthly cargo export volume of the previous month) / Monthly cargo export volume of the previous month. 4. Data Application: Analyze the month-on-month changes and proportion trends of the monthly cargo export index of each route, so as to clearly understand the monthly cargo export volume of different trains, help China-Europe Railway Express reasonably and efficiently plan the arrangement of import and export trains, and improve transportation efficiency.

搜集汇总

数据集介绍

特点

该数据集记录了中欧班列货物出口的详细信息，包括订单、集装箱、班列等数据，用于分析出口趋势和优化运输计划。数据规模为21684条，每日更新，适用于交通运输行业的调度和效能提升。