An international shipping schedule data processing method, storage medium

Abstract

The present invention relates to an international shipping schedule data processing method and a storage medium, comprising the following steps: obtaining a target country selected by a user, collecting origin port file data of the target country to form a port file table of the target country; obtaining data of each shipping company that can provide services in the target country, wherein the shipping company data includes a shipping schedule access address of the shipping company; performing all possible pairings according to the origin port and destination port of each shipping company, and regularly creating a shipping company port shipping schedule data search and parsing task pool according to each pairing of the origin port and destination port; executing for each task in the task pool: downloading http data through the shipping schedule access address of the shipping company, and writing the shipping schedule data into a monthly original shipping schedule table; cleaning and de-duplicating the monthly original shipping schedule table; establishing or matching a corresponding shipping fleet for each piece of shipping schedule data in the monthly original shipping schedule table, and outputting the shipping schedule data in the monthly original shipping schedule table according to the shipping fleet.

Description

Technical Field

[0001] The present invention relates to the field of shipping schedule data processing, and specifically refers to an international shipping schedule data processing method and a storage medium. Background Art

[0002] Shipping schedule data generally includes: shipping company, departure port, destination port, departure time, arrival time, ship name, and voyage number. By tracking seagoing ships and transported goods through basic data such as ship positions, ports, and routes, real-time, accurate, and visible individual dynamic information can be provided for participants in the maritime logistics industry, and logistics dynamics and industry intelligence can be provided for commodity traders such as iron ore, crude oil, coal, and natural gas.

[0003] Currently, the shipping schedule data of each shipowner globally is scattered in their respective business systems, and there is no centralized and unified shipping schedule data for relevant parties such as global shippers, consignees, freight forwarders, and booking agents to query and download. Shippers or freight forwarders often need to be authorized by a shipowner with the ability to provide shipping schedule data interfaces to obtain the structured shipping schedule data of a single shipowner. The sources of shipping schedule data are limited, the data content is single, the shipping schedule data cannot be corrected, and it does not include information on co-cabins and transshipments of the fleet.

[0004] Designing an international shipping schedule data processing method and a storage medium to address the problems existing in the above prior art is the objective of the research of the present invention. Summary of the Invention

[0005] In view of the problems existing in the above prior art, the present invention aims to provide an international shipping schedule data processing method and a storage medium, which can effectively solve the problems existing in the above prior art.

[0006] The technical solution of the present invention is as follows:

[0007] An international shipping schedule data processing method includes the following steps:

[0008] Obtain the target country selected by the user, and collect the origin port archive data of the target country to form a port archive table of the target country;

[0009] Obtain the data of each shipowner that can provide services in the target country, where the shipowner data includes a shipowner list, a shipowner route Service list, and a shipowner shipping schedule access address;

[0010] Perform all possible pairings based on the origin ports and destination ports of each shipowner, and regularly create a shipowner port shipping schedule data search and analysis task pool according to each pairing of origin ports and destination ports;

[0011] Execute for each task in the task pool: Download http data through the shipowner's sailing schedule access address, search and determine whether the http data contains sailing schedule data. If so, parse the sailing schedule data and write the sailing schedule data into the monthly original sailing schedule table. The sailing schedule data includes one or more of ship name, voyage number, Service, course, route, sailing date, departure port, destination port, transit port, and voyage.

[0012] Clean and deduplicate the monthly original sailing schedule table, and delete invalid data.

[0013] Establish or match a corresponding fleet for each sailing schedule data in the monthly original sailing schedule table, and output the sailing schedule data in the monthly original sailing schedule table according to the fleet.

[0014] Further, after obtaining the data of each shipowner that can provide services in the target country, it includes:

[0015] Obtain the departure port and destination port of each shipowner through the shipowner's sailing schedule access address, record the departure port and destination port in the data table, and establish a search engine for the departure port and destination port.

[0016] Further, after obtaining the data of each shipowner that can provide services in the target country, it includes: Establish an http search and download engine and an http format parsing engine.

[0017] The process of downloading http data through the shipowner's sailing schedule access address, searching and determining whether the http data contains sailing schedule data includes: Access the shipowner's sailing schedule access address through the http search and download engine to download http data, parse the http data through the http format parsing engine, and search and determine whether the http data contains sailing schedule data.

[0018] Further, the process of establishing or matching a corresponding fleet for each sailing schedule data in the monthly original sailing schedule table includes: Execute for each sailing schedule data in the monthly original sailing schedule table:

[0019] Obtain the list of created fleets;

[0020] If the ship name and Service included in the sailing schedule data are recorded in the fleet list, match the sailing schedule data to the corresponding fleet in the fleet list;

[0021] If the ship name and Service included in the sailing schedule data are not recorded in the fleet list, create a new fleet, write the new fleet into the fleet list, and match the sailing schedule data to the corresponding new fleet in the fleet list.

[0022] Further, after establishing or matching a corresponding fleet for each of the shipping schedule data in the monthly original shipping schedule, before outputting the shipping schedule data in the monthly original shipping schedule according to the fleet, it includes:

[0023] Calculate the voyage according to the arrival date in the monthly original shipping schedule, and arrange them in ascending order of the voyage within a fleet.

[0024] Further, after establishing or matching a corresponding fleet for each of the shipping schedule data in the monthly original shipping schedule, before outputting the shipping schedule data in the monthly original shipping schedule according to the fleet, it includes:

[0025] Verify whether the fields of the shipping schedule data include the shipowner, origin port, departure terminal, destination port, route, sailing date, voyage, fleet ID. If not, initiate a manual filling request.

[0026] Further, the all-possible pairing according to the origin ports and destination ports of each shipowner includes:

[0027] Perform an all-possible Cartesian product pairing according to the origin ports and destination ports of each shipowner.

[0028] Further, the task attributes of the shipowner port shipping schedule data search and parsing task pool include one or more of the shipowner, origin port, destination port, whether completed, whether successful, retry count, task start time, and task completion time.

[0029] Further, after obtaining the data of each shipowner that can provide services in the target country, it includes: establishing a set search engine for the origin port and destination port, entering the shipowner shipping schedule access address through the search engine to search for the origin ports and destination ports of each shipowner, recording the origin ports and destination ports of each shipowner in the basic data table, and regularly updating the basic data table through the search engine.

[0030] Further provided is a computer-readable storage medium storing a computer program, and when the computer program is executed by a processor, it implements the international shipping schedule data processing method described above.

[0031] Therefore, the present invention provides the following effects and / or advantages:

[0032] This application forms a port archive table for the target country by collecting the origin port archive data of the target country, then searches and obtains various data from the access addresses included in the shipowner data, pairs all possible combinations of the origin port and the destination port, and finally, through data analysis, pairing establishment, and data screening, the shipping schedule data in the monthly original shipping schedule can be output according to the fleet. This solves the technical problem in the prior art of being unable to collect fleet data. By using the above data processing method and software, users can obtain the shipowner shipping schedule data of origin ports around the world, and obtain weekly shipping schedule information, shipowner co-cabin information, voyage information, and port call information.

[0033] This application uses a detection algorithm to obtain the port combinations served by the shipowner, which can timely discover new routes of the shipowner. And regularly update the data to obtain various corresponding data.

[0034] This application verifies voyage anomalies through an existing industry experience rule library, which can obtain more accurate data and reduce manual intervention.

[0035] It should be understood that the above summary and the following detailed description of the present invention are exemplary and explanatory, and are intended to provide further explanation of the present invention as claimed. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 It is a flowchart of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0037] For the convenience of those skilled in the art to understand, the embodiments will be further described in detail below in conjunction with the drawings: It should be understood that the steps mentioned in this embodiment, unless specifically stating their order, can be adjusted according to actual needs in their front and back order, and even can be executed simultaneously or partially simultaneously.

[0038] Refer to Figure 1 , an international shipping schedule data processing method, which includes the following steps:

[0039] S1, obtain the target country selected by the user, and collect the origin port archive data of the target country to form a port archive table for the target country;

[0040] In this step, by the user selecting the target country, the origin port archives of this country are collected through research on the shipping industry, and the origin ports and terminal information in different formats are obtained, and the data in a standard format is unified and written into the national port archive table, which is convenient for subsequent information display, retrieval, and regular maintenance and update.

[0041] For example, the user selects a specific country: VIETNAM, and collects the origin port files of this country through manual or information collection engines, including: DANANG, HAIPHONG, HOCHIMINH, and obtains the following origin port and terminal information:

[0042] DANANG: TIEN SA TERMINAL;

[0043] HAIPHONG: GREEN PORT, VIP GREENPORT, HAIPHONG INTERNATIONAL CONTAINER, TERMINAL, TAN VU TERMINAL, NAM HAIDINH VU PORT;

[0044] HOCHIMINH: CAT LAI TERMINAL, SP-ITC INTERNATIONAL CONTAINER TERMINAL;

[0045] Then, through manual or information processing engines, process this file into data in a unified standard format and write this data into the national port file table. The national port file table obtained at this time is shown in Table 1:

[0046]

[0047] Table 1

[0048] S2. Obtain the data of each shipping company that can provide services in the target country. The shipping company data includes a list of shipping companies, a list of shipping company routes Service, and the access address of the shipping company's sailing schedule;

[0049] This step cooperates with step S1 to sort out the list of shipping companies, the list of shipping company routes Service, and the website address of the shipping company's sailing schedule announcements in the countries that provide services at the origin ports. The results obtained are shown in Table 2.

[0050]

[0051]

[0052] Table 2

[0053] This announcement address contains all the data required by this application.

[0054] Furthermore, after obtaining the data of each shipping company that can provide services in the target country, it includes:

[0055] S2.1. Obtain the origin port and destination port of each shipping company through the access address of the shipping company's sailing schedule, record the origin port and destination port in the data table, and establish a search engine for the origin port and destination port.

[0056] Further, after obtaining the data of each shipowner that can provide services in the target country, the following steps are included: establishing a search engine for departure and destination port sets, entering the shipowner's sailing schedule access address through the search engine to search for the departure and destination ports of each shipowner, recording the departure and destination ports of each shipowner in a basic data table, and regularly updating the basic data table through the search engine.

[0057] In this step, according to the shipowner's sailing schedule announcement website address of each shipowner, a search engine for departure and destination port sets of shipowners is developed using Python. And this search engine is configured as follows: when the engine is started for the first time, it automatically searches for the basic data of departure and destination ports that the shipowner may provide services for and records them in the basic data table of departure and destination ports of shipowners; after that, the search engine for departure and destination port sets of shipowners is automatically started once a month, and the basic data of shipowner ports is updated with the updated search data, adding new ports and deleting invalid ports. Through this engine, a large amount of basic data of departure and destination ports can be collected, such as the data obtained in the above step S1, and at the same time, it is recorded in the data table, so as to establish a search engine through this database for data acquisition in subsequent steps.

[0058] The search engine for departure and destination port sets of shipowners can be implemented through the following code:

[0059] Further, after obtaining the data of each shipowner that can provide services in the target country, it includes:

[0060] S2.2, establishing an http search and download engine and an http format parsing engine;

[0061] S2.3, when downloading http data through the shipowner's sailing schedule access address and searching and judging whether the http data contains sailing schedule data, it includes: accessing the shipowner's sailing schedule access address through the http search and download engine to download http data, parsing the http data through the http format parsing engine, and searching and judging whether the http data contains sailing schedule data.

[0062] In this step, according to the shipowner's sailing schedule announcement website address of each shipowner, an http search and download engine and an http format parsing engine are developed using Python. The http content on the shipowner's sailing schedule announcement website page can be searched and downloaded through the http search and download engine. Then, by parsing the html format of the search results, the ship name, voyage number, Service, course, route, sailing date, departure port, destination port, transit port, and voyage can be separated.

[0063] Moreover, the HTTP search and download engine and the HTTP format parsing engine can adjust the search and parsing codes at any time according to the changes in the key shipping schedule data caused by the changes in the pages of the shipowners' official websites.

[0064] The HTTP search and download engine and the HTTP format parsing engine can be implemented through the following codes:

[0065]

[0066]

[0067]

[0068] S3. Make all possible pairings based on the departure ports and destination ports of each shipowner, and regularly create a task pool for searching and parsing shipowner port shipping schedule data according to each pairing of departure port and destination port; Further, the task attributes of the task pool for searching and parsing shipowner port shipping schedule data include one or more of shipowner, departure port, destination port, whether completed, whether successful, retry count, task start time, and task completion time.

[0069] Further, the making of all possible pairings based on the departure ports and destination ports of each shipowner includes:

[0070] Make all possible Cartesian product pairings based on the departure ports and destination ports of each shipowner.

[0071] In this step, make all possible Cartesian product pairings based on the departure port and destination port of the shipowner. The Cartesian product refers to, in mathematics, the Cartesian product (also known as the direct product) of two sets X and Y, denoted as X×Y, where the first object is a member of X and the second object is one of all possible ordered pairs of Y.

[0072] Regularly calculate all possible pairings of the origin port and the destination port. For example, on the 1st of each month, pair according to the origin port + destination port of the shipowner, and then create a monthly shipowner port schedule data search and parsing task pool based on each pairing. The task attributes include the shipowner, origin port, destination port, whether completed, whether successful, number of retries, task start time, and task completion time. After the task is created, it is written into the task pool data table and waits to be executed. For example: For the ship schedule in May 2022, the shipowners are CMA and MSK, the origin ports are Xiamen and Shanghai, and the destination ports are Singapore and Hamburg. Then the Cartesian set is: {(CMA, Shanghai, Singapore), (CMA, Shanghai, Hamburg), (MSK, Shanghai, Singapore), (MSK, Shanghai, Hamburg), (CMA, Xiamen, Singapore), (CMA, Xiamen, Hamburg), (MSK, Xiamen, Singapore), (MSK, Xiamen, Hamburg)}. Eight ship schedule data search and parsing tasks for May will be automatically placed into the task pool.

[0073] S4. Execute for each task in the task pool: Download http data through the shipowner schedule access address, search and determine whether the http data contains ship schedule data. If so, parse the ship schedule data and write the ship schedule data into the monthly original ship schedule table. The ship schedule data includes one or more of the ship name, voyage number, Service, course, route, sailing date, origin port, destination port, transit port, and voyage.

[0074] In this step, deploy a task execution engine for the ship schedule search virtual machine cluster. This engine randomly selects a task from the task pool and starts working using the shipowner origin port and destination port set search engine in step S2.1 and the shipowner's http search download engine and http format parsing engine in step S2.2. If reasonable ship schedule data is found, parse the components of the ship schedule data. If the content of the ship name, voyage number, Service, course, route, sailing date, origin port, destination port, transit port, and voyage is parsed, write it into the original ship schedule table. If there is no reasonable downloaded data, retry downloading up to 5 times. If no reasonable search data is obtained after 5 attempts, it is determined that the shipowner does not provide services at this destination port and is not written into the original ship schedule table.

[0075] At this time, the obtained ship schedule table can include the ship name, voyage number, Service, course, route, sailing date, origin port, destination port, transit port, and voyage. The obtained original ship schedule table is shown in Table 3.

[0076]

[0077] Table 3

[0078] S5. Clean and deduplicate the monthly original ship schedule table and delete invalid data.

[0079] This step is used for data cleaning, for example, cleaning and removing duplicate original shipping schedule data where the shipowner + ship name + voyage number + departure port + destination port are all the same, as well as empty lines with no data.

[0080] S5.1, Tag the data table. Perform a tagging process from 1 to 7 based on the day of the week information corresponding to the sailing date. For example, if the sailing date of January 1, 2022, corresponds to Saturday, it is tagged as "Saturday Flight".

[0081] S6, Establish or match a corresponding fleet for each piece of the shipping schedule data in the monthly original shipping schedule table, and output the shipping schedule data in the monthly original shipping schedule table according to the fleet.

[0082] Further, the establishing or matching a corresponding fleet for each piece of the shipping schedule data in the monthly original shipping schedule table includes: performing the following operations on each piece of the shipping schedule data in the monthly original shipping schedule table:

[0083] S6.1, Obtain the list of established fleets;

[0084] S6.2, If the ship name and Service included in the shipping schedule data are recorded in the fleet list, match the shipping schedule data to the corresponding fleet in the fleet list;

[0085] S6.3, If the ship name and Service included in the shipping schedule data are not recorded in the fleet list, create a new fleet, write the new fleet into the fleet list, and match the shipping schedule data to the corresponding new fleet in the fleet list.

[0086] Further, after establishing or matching a corresponding fleet for each piece of the shipping schedule data in the monthly original shipping schedule table and before outputting the shipping schedule data in the monthly original shipping schedule table according to the fleet, it includes:

[0087] S6.4, Calculate the voyage according to the arrival date in the monthly original shipping schedule table, and arrange them in ascending order of the voyage within a fleet.

[0088] Further, after establishing or matching a corresponding fleet for each piece of the shipping schedule data in the monthly original shipping schedule table and before outputting the shipping schedule data in the monthly original shipping schedule table according to the fleet, it includes:

[0089] S6.5, Verify whether the fields of the shipping schedule data contain the shipowner, departure port, loading terminal, destination port, route, sailing date, voyage, fleet ID. If not, initiate a request for manual filling.

[0090] In this step, a fleet list is pre-stored, and the fleet list includes the ship name and Service, etc. And the fleet list can be established and increased.

[0091] By extracting each piece of information from the monthly original shipping schedule and analyzing the fleet information, if the shipowner + shipowner's Service in the record is in the created fleet list, then associate the shipowner + shipowner's Service of this record with the created fleet list; if no corresponding fleet can be found, create a new fleet ID, and determine other shipowners with the same ship name as co-charter shipowners, put the shipowners and Services into the co-charter shipowner set of the fleet, and put all ports with the same ship name into the port call set of the fleet; repeat the above steps until all original shipping schedule data has been processed. Calculate the voyage according to the arrival date in the original shipping schedule, and arrange the port call order in ascending order of the voyage.

[0092] Finally, check that the required fields in the shipping schedule, such as: shipowner, origin port, departure terminal, destination port, route, sailing date, voyage, fleet ID, these items are data segments that must have values. If data is missing, initiate a request for manual filling to require manual filling.

[0093] Record or create a fleet list according to Table 3, and the information output in the corresponding order is shown in Table 4.

[0094] Shipowner:

[0095] SEALAND, ONE, INTERASIA, OOCL, PIL, COSCO, EMC.

[0096] Service:

[0097]

[0098] Table 4

[0099] Furthermore, a computer-readable storage medium is provided, storing a computer program, and when the computer program is executed by a processor, it implements the described international shipping schedule data processing method.

[0100] Those skilled in the art should understand that the embodiments of the present invention can be provided as a method, a system, or a computer program product. Therefore, the present invention can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present invention can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0101] The present invention is described with reference to the flowcharts and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the present invention. It should be understood that each flow and / or block in the flowcharts and / or block diagrams, and combinations of flows and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to the processors of general-purpose computers, special-purpose computers, embedded processors, or other programmable data processing devices to produce a machine, such that the instructions executed by the processors of the computer or other programmable data processing devices produce means for implementing the functions specified in one flow Figure 1 one flow or more flows and / or blocks Figure 1 or means for implementing the functions specified in one block or more blocks.

[0102] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, such that the instructions stored in the computer-readable memory produce a manufactured article including instruction means that implement the functions specified in one flow Figure 1 one flow or more flows and / or blocks Figure 1 or means for implementing the functions specified in one block or more blocks.

[0103] These computer program instructions can also be loaded onto a computer or other programmable data processing device, such that a series of operation steps are executed on the computer or other programmable device to produce a computer-implemented process, so that the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in one flow Figure 1 one flow or more flows and / or blocks Figure 1 or means for implementing the functions specified in one block or more blocks.

[0104] It should be noted that in the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in the claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The present invention can be implemented by means of hardware including several different elements and by means of a suitably programmed computer. In a unit claim listing several means, several of these means can be embodied by the same item of hardware. The use of the words first, second, and third, etc. does not denote any order. These words can be interpreted as names.

[0105] Although the preferred embodiments of the present invention have been described, those skilled in the art can make additional changes and modifications once they learn the basic creative concept. Therefore, the appended claims are intended to be construed to include the preferred embodiments and all changes and modifications falling within the scope of the present invention.

[0106] Obviously, those skilled in the art can make various modifications and variations to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalent technologies, the present invention is also intended to include these modifications and variations.

[0107] In the present invention, unless otherwise clearly specified and defined, the terms "installed", "connected", "connected to", "fixed", etc. shall be understood in a broad sense. For example, it may be a fixed connection, a detachable connection, or integrated; it may be a mechanical connection or an electrical connection; it may be directly connected or indirectly connected through an intermediate medium, and it may be the internal connection of two components or the interaction relationship between two components. For those of ordinary skill in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances. [[ID=?]]

[0108] In the description of this specification, the description referring to terms such as "one embodiment", "some embodiments", "example", "specific example", or "some examples" means that the specific features, structures, materials, or characteristics described in connection with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic expressions of the above terms should not be understood as necessarily referring to the same embodiment or example. Moreover, the specific features, structures, materials, or characteristics described can be combined in a suitable manner in any one or more embodiments or examples. In addition, without contradiction, those skilled in the art can combine and combine the different embodiments or examples described in this specification and the features of different embodiments or examples.

Claims

1. A method for processing international shipping schedule data, characterized by: The following steps are involved: Obtain the target country selected by the user, and collect the origin port file data of the target country to form a port file table of the target country; Obtain data on shipowners that can provide services in the target country, including a list of shipowners, a list of shipowner routes and services, and an address for shipowners to visit during sailing schedules. Obtain the departure port and destination port of each shipowner through the shipowner's sailing schedule access address, record the departure port and destination port in a data table and establish a search engine for the departure port and destination port; We match all possible options based on the departure and destination ports of each shipowner, and regularly create a shipowner port schedule data search and analysis task pool based on each pairing of departure and destination ports; The matching of all possibilities according to the departure ports and destination ports of each shipowner includes: matching of all possibilities according to the departure ports and destination ports of each shipowner using the Cartesian product; For each task in the task pool, the following steps are executed: downloading HTTP data through the shipowner's sailing schedule access address, searching and determining whether the HTTP data contains sailing schedule data; if so, parsing the sailing schedule data; and writing the sailing schedule data into the monthly original sailing schedule table. The sailing schedule data includes one or more of the following: ship name, voyage number, service, heading, route, sailing date, departure port, destination port, transit port, and voyage length; Clean and remove duplicates from the monthly original sailing schedule and delete invalid data; A corresponding fleet is established or matched for each of the sailing schedule data in the monthly original sailing schedule table, and the sailing schedule data in the monthly original sailing schedule table is output according to the fleet.

2. The method for processing international shipping schedule data according to claim 1, characterized in that: After obtaining the data of each shipowner that can provide services in the target country, the method includes: establishing an http search and download engine and an http format parsing engine; Said downloading of http data through the shipowner's sailing schedule access address and searching and judging whether the http data contains sailing schedule data comprises: accessing the shipowner's sailing schedule access address and downloading http data through the http search and download engine, parsing the http data through the http format parsing engine, and searching and judging whether the http data contains sailing schedule data.

3. The method for processing international shipping schedule data according to claim 1, characterized in that: The step of establishing or matching a corresponding fleet for each of the ship schedule data in the monthly original ship schedule table includes: executing the following steps for each of the ship schedule data in the monthly original ship schedule table: Get the list of created fleets; If the ship name and service included in the sailing schedule data are recorded in the fleet list, the sailing schedule data is matched to the corresponding fleet in the fleet list; If the ship name and service included in the sailing schedule data are not recorded in the fleet list, a new fleet is created and written into the fleet list, and the sailing schedule data is matched to the corresponding new fleet in the fleet list.

4. The method for processing international shipping schedule data according to claim 1, characterized in that: After establishing or matching a corresponding fleet for each of the sailing schedule data in the monthly original sailing schedule table, and before outputting the sailing schedule data in the monthly original sailing schedule table according to the fleet, the method includes: The voyage distance is calculated based on the arrival date in the monthly original sailing schedule and is arranged in ascending order of voyage distance within a fleet.

5. The method for processing international shipping schedule data according to claim 1, characterized in that: After establishing or matching a corresponding fleet for each of the sailing schedule data in the monthly original sailing schedule table, and before outputting the sailing schedule data in the monthly original sailing schedule table according to the fleet, the method includes: Verify whether the fields of the sailing schedule data contain shipowner, departure port, shipping terminal, destination port, route, sailing date, voyage, and fleet ID. If not, initiate a manual filling request.

6. The method for processing international shipping schedule data according to claim 1, characterized in that: The task attributes of the shipowner port schedule data search and parsing task pool include one or more of shipowner, departure port, destination port, whether completed, whether successful, number of retries, task start time, and task completion time.

7. The method for processing international shipping schedule data according to claim 1, characterized in that: After obtaining the data of each shipowner that can provide services in the target country, the method includes: establishing a search engine for a collection of ports of departure and destination, entering the shipowner's sailing schedule access address through the search engine to search for the ports of departure and destination of each shipowner, and recording the ports of departure and destination of each shipowner in a basic data table, and regularly updating the basic data table through the search engine.

8. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, an international shipping schedule data processing method according to any one of claims 1 to 7 is implemented.

Images