A trade indicator visualization system and method based on international trade commodity data

Abstract

The present invention discloses a trade indicator visualization system and method based on international trade commodity data, which relates to the technical field of international trade. The system includes: an international trade commodity data acquisition module, which is used to acquire multiple international trade commodity data; each international trade commodity data includes year, trade flow, initiating country, cooperating country, commodity number, commodity name and trade amount; trade flow is import or export; trade indicator calculation module, which is used to calculate trade indicators according to international trade commodity data; trade indicators include export similarity index, trade integration index, trade competitiveness index, trade structure matching index, intra-industry trade index and explicit comparative advantage index; trade indicator visualization display module, which is used to visualize trade indicators. The present invention can realize the calculation and visualization of trade indicators.

Description

Technical Field

[0001] The present invention relates to the technical field of international trade, and in particular to a trade indicator visualization system and method based on international trade commodity data. Background Art

[0002] Studying international trade plays an important role in improving the economic benefits of national enterprises and fiscal revenue, and even promoting national development. How to process and study the massive amount of international trade commodity data is a very important topic. Visualization of international trade data is an essential technical skill, and it also provides a more efficient and intuitive platform for relevant researchers. Although there are visualization systems for international trade data, the current visualization systems rarely involve the functions of trade indicator calculation and visualization. Therefore, simply visualizing the original international trade data can no longer meet the higher requirements of relevant researchers for international trade data analysis.

[0003] In summary, how to realize the calculation and visualization of trade indicators has become an urgent problem to be solved by technical personnel in this field. Summary of the invention

[0004] The purpose of the present invention is to provide a trade indicator visualization system and method based on international trade commodity data to achieve the calculation and visualization of trade indicators.

[0005] To achieve the above object, the present invention provides the following solutions:

[0006] A trade indicator visualization system based on international trade commodity data, the system comprising:

[0007] An international trade commodity data acquisition module is used to acquire multiple international trade commodity data; each of the international trade commodity data includes year, trade flow, initiating country, cooperating country, commodity number, commodity name and trade amount; the trade flow is import or export;

[0008] A trade index calculation module, used to calculate trade indicators based on the international trade commodity data; the trade indicators include export similarity index, trade integration index, trade competitiveness index, trade structure matching index, intra-industry trade index and explicit comparative advantage index;

[0009] The trade indicator visualization display module is used to visualize the trade indicators.

[0010] Optionally, the system further comprises:

[0011] An international trade commodity data retrieval module, used to retrieve a plurality of international trade commodity data having the same year, trade flow, initiating country and commodity number;

[0012] A normalization processing module, used for normalizing the trade amount in each of the international trade commodity data with the same year, trade flow, initiating country and commodity number, to obtain the trade weight between the initiating country and each of the cooperating countries;

[0013] A trade weight display module, used for displaying the trade weight between the initiating country and each of the cooperating countries using a directed network diagram;

[0014] The retrieval data display module is used to display the international trade commodity data with the same year, trade flow, initiating country and commodity number by using a table chart.

[0015] Optionally, the trade index calculation module specifically includes:

[0016] A first trade index calculation unit, used to calculate the first trade index corresponding to any of the years according to the international trade commodity data; the first trade index includes an export similarity index, a trade integration index, a trade competitiveness index, a trade structure matching index and an intra-industry trade index between any of the initiating countries and each of the cooperating countries;

[0017] The second trade index calculation unit is used to calculate the second trade index corresponding to any of the years according to the international trade commodity data; the second trade index includes the explicit comparative advantage index of various commodities exported by any of the initiating countries.

[0018] Optionally, the trade indicator visualization display module specifically includes:

[0019] A first trade indicator retrieval unit, used for retrieving the first trade indicator having the same year and the same initiating country;

[0020] A second trade indicator retrieval unit, used for retrieving the second trade indicator having the same year and the same initiating country;

[0021] A first normalization processing unit is used to perform normalization processing on the first trade indicators that are the same in the year and the initiating country, so as to obtain the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries;

[0022] A second normalization processing unit is used to perform normalization processing on the second trade indicators that are the same in the year and the initiating country, so as to obtain the weights of the comparative trade advantages of various commodities exported by the initiating country;

[0023] A trade competitiveness or complementarity weight display unit, used to display the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries using an undirected network graph;

[0024] A trade comparative advantage level weight display unit, used to display the trade comparative advantage level weights of various commodities exported by the initiating country using an undirected network graph;

[0025] A first search indicator display unit, used for displaying the first trade indicator having the same year and the same initiating country by using a table chart;

[0026] The second search indicator display unit is used to display the second trade indicator with the same year and the same initiating country by using a table chart.

[0027] The present invention also provides the following solution:

[0028] A trade indicator visualization method based on international trade commodity data, the method comprising:

[0029] Acquire multiple international trade commodity data; each of the international trade commodity data includes year, trade flow, initiating country, cooperating country, commodity number, commodity name and trade amount; the trade flow is import or export;

[0030] Calculating trade indicators based on the international trade commodity data; the trade indicators include export similarity index, trade integration index, trade competitiveness index, trade structure matching index, intra-industry trade index and explicit comparative advantage index;

[0031] The trade indicators are visualized.

[0032] Optionally, the method further comprises:

[0033] Retrieving a plurality of international trade commodity data having the same year, trade flow, originating country and commodity number;

[0034] Normalizing the trade amounts in the international trade commodity data with the same year, trade flow, initiating country and commodity number to obtain trade weights between the initiating country and each of the cooperating countries;

[0035] Using a directed network graph to display the trade weight between the initiating country and each of the cooperating countries;

[0036] A plurality of international trade commodity data having the same year, trade flow, originating country and commodity number are displayed in a table chart.

[0037] Optionally, the calculating of trade indicators according to the international trade commodity data specifically includes:

[0038] Calculate the first trade index corresponding to any of the years according to the international trade commodity data; the first trade index includes the export similarity index, trade integration index, trade competitiveness index, trade structure matching index and intra-industry trade index between any of the initiating countries and each of the cooperating countries;

[0039] A second trade index corresponding to any of the years is calculated based on the international trade commodity data; the second trade index includes an explicit comparative advantage index of various commodities exported by any of the initiating countries.

[0040] Optionally, the visual display of the trade indicators specifically includes:

[0041] Retrieving the first trade indicator having the same year and the same initiating country;

[0042] Retrieving the second trade indicator having the same year and the same initiating country;

[0043] Normalizing the first trade indicators that are the same in both the year and the initiating country to obtain the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries;

[0044] Normalizing the second trade index that is the same in the year and the initiating country to obtain the weights of the comparative trade advantages of various commodities exported by the initiating country;

[0045] Using an undirected network graph to display the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries;

[0046] Use an undirected network graph to show the weights of the comparative trade advantages of the initiating country in exporting various commodities;

[0047] Displaying the first trade indicator for the same year and the same initiating country using a table chart;

[0048] The second trade indicator for the same year and the same initiating country is displayed using a tabular chart.

[0049] According to the specific embodiments provided by the present invention, the present invention discloses the following technical effects:

[0050] The present invention discloses a trade indicator visualization system and method based on international trade commodity data, wherein a trade indicator calculation module is provided to calculate trade indicators, and a trade indicator visualization display module is provided to visualize the trade indicators calculated by the trade indicator calculation module, thereby realizing the calculation and visualization of trade indicators. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0052] Figure 1 It is a structural diagram of an embodiment of a trade indicator visualization system based on international trade commodity data of the present invention;

[0053] Figure 2 A structural module block diagram of a trade index calculation and visualization system based on international trade commodity data of the present invention;

[0054] Figure 3 The present invention is a flowchart of an embodiment of a method for visualizing trade indicators based on international trade commodity data. DETAILED DESCRIPTION

[0055] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0056] The purpose of the present invention is to provide a trade indicator visualization system and method based on international trade commodity data to achieve the calculation and visualization of trade indicators.

[0057] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the present invention is further described in detail below with reference to the accompanying drawings and specific embodiments.

[0058] Figure 1 This is a structural diagram of an embodiment of the trade indicator visualization system based on international trade commodity data of the present invention. Figure 1 , the trade indicator visualization system based on international trade commodity data includes:

[0059] The international trade commodity data acquisition module 101 is used to acquire multiple international trade commodity data; each international trade commodity data includes year, trade flow, initiating country, cooperating country, commodity number, commodity name and trade amount; trade flow is import or export.

[0060] In this embodiment, the international trade commodity data includes seven attributes: year, trade flow (import or export), initiating country, cooperating country, commodity number, commodity name, and trade amount. The international trade commodity data covers the years 2000-2018, imports and exports, 62 initiating countries or cooperating countries, 66 commodity numbers, 66 commodity names and corresponding trade amounts.

[0061] The trade index calculation module 102 is used to calculate trade indicators based on international trade commodity data; the trade indicators include export similarity index, trade integration index, trade competitiveness index, trade structure matching index, intra-industry trade index and explicit comparative advantage index.

[0062] The trade index calculation module 102 specifically includes:

[0063] The first trade index calculation unit is used to calculate the first trade index corresponding to any year based on the international trade commodity data; the first trade index includes the export similarity index, trade integration index, trade competitiveness index, trade structure matching index and intra-industry trade index between any initiating country and each cooperating country.

[0064] The second trade index calculation unit is used to calculate the second trade index corresponding to any year based on the international trade commodity data; the second trade index includes the explicit comparative advantage index of any initiating country in exporting various commodities.

[0065] The trade index calculation module 102 is an international trade index calculation module, which calculates the trade index (trade index) based on the international trade commodity data. The international trade index calculation module realizes the function of calculating multiple trade indexes based on the acquired international trade commodity data. The present invention relates to 6 trade indexes, and the calculation method is as follows:

[0066] (1) Export Similarity Index (ESI) calculation formula:

[0067]

[0068]

[0069] Where, ESI ij represents the export similarity index between initiating country i and cooperating country j; ESI ij The value range of is [0, 100]. When the export similarity index is close to 100, it means that the more similar the export structure of the two countries in the same world market is, the stronger the competitiveness is, and vice versa. n represents the number of types of export commodities, and k represents the serial number of the types of export commodities. and They represent the export value (export trade volume) of the kth category (kth type) of goods by country i and country j in the world market w; X iw and X jw Respectively represent the total export volume of country i and country j in the world market w; a ik and a jk Respectively represent the proportion of the k-th product (commodity) in the total exports (total exports) of countries i and j; a ik 、a jk The common export commodities of countries i and j on world market w are the input parameters that need to be imported by this system when calculating the ESI index.

[0070] (2) Calculation formula of trade integration index (TII):

[0071]

[0072] In the formula, i, j and w represent countries i, j and the world market respectively; TII ij represents the trade integration index between the initiating country i and the cooperating country j; X ij represents the export volume of country i to country j; X i represents the total exports of country i, M j represents the total imports of country j; M w Represents the total world imports. ij When TII is greater than 1, it indicates that the trade relationship between countries i and j is close; ij When <1, it indicates that the trade relationship between countries i and j is loose. ij , X i 、M j 、M w It is the input parameter that needs to be imported when calculating the TII index.

[0073] (3) The calculation formula of trade competitiveness index (CI) is as follows:

[0074]

[0075]

[0076]

[0077] In the formula, CS and CC are the modified specialization coefficient and consistency coefficient respectively; n represents the number of types of exported goods, k represents the serial number of the types of exported goods; a ik and a jk The CI index is closer to 1, which means that the trade structure of the two countries is more consistent, that is, the potential trade competitiveness between the two countries is stronger. ik 、ajk The common export commodities of countries i and j in market w are the input parameters that need to be imported when calculating the CI index in this system.

[0078] (4) Trade structure matching index (CI m )Calculation formula:

[0079]

[0080]

[0081]

[0082] In the formula, CS m and CC m are the modified specialization coefficient and consistency coefficient respectively; n represents the number of types of exported goods, k represents the serial number of the types of exported goods; a ik represents the proportion of the kth category of goods in the total exports of country i; a jk CI represents the proportion of the kth category of goods in the total imports of country j. m The closer the index is to 1, the higher the trade complementarity between the two countries and the greater the trade potential. ik 、a jk The common commodity exported by country i and imported by country j in market w is the product of the system in calculating CI m The input parameters that need to be imported when indexing.

[0083] (5) Intra-industry trade index (GL) calculation formula:

[0084]

[0085] In the formula, GL ij represents the intra-industry trade index between the initiating country i and the cooperating country j; n represents the number of types of exported goods, k represents the serial number of the types of exported goods; X ij M represents the import amount of the kth category of goods from country i to country j; ij represents the export value of the kth category of goods from country i to country j; the value range of GL is [0, 1]. The larger the value, the higher the level of intra-industry trade between the two countries, and the lower the trade complementarity; on the contrary, it indicates that the trade complementarity is higher. ij and M ij It is the input parameter that needs to be imported when calculating the GL index in this system.

[0086] (6) Calculation formula of revealed comparative advantage index (RCA):

[0087]

[0088] In the formula, It represents the revealed comparative advantage index of the nth category of goods exported by the initiating country i; and represents the total export volume of the nth category of goods in country i and the world, respectively, X ti and X tw Represents the total export volume of the nth category of goods in country i and the world respectively. Generally speaking, if RCA ≥ 2.5, it indicates that the industry in the country has extremely strong competitiveness; RCA index 1.25 ≤ RCA < 2.5, it means that the export proportion of the industry in the country is greater than the world export proportion, which means that the industry in the country has strong competitiveness in the international market; if RCA < 0.8, it means that the international competitiveness of the industry in the country is relatively weak. X ti , and X tw It is the input parameter that needs to be imported when calculating the RCA index. After the calculation process shows that the trade index is calculated, the user saves the calculation result data of the trade index in the set folder.

[0089] The calculation formulas for the above six trade indices are all existing formulas.

[0090] In the international trade index calculation module, the user imports the corresponding parameter data file according to the calculation formula of the trade index, selects the property control of the trade index and selects the calculation control of the trade index, and the system displays the calculation process and results of the trade index. After the calculation process is completed, the user saves the calculation result data of the trade index in the set folder. The trade index calculation and visualization system of the present invention can calculate 6 trade competitiveness and complementarity indexes, including the Export Similarity Index (ESI), the Trade Integration Index (TII), the Competitive Index (CI), the Complementarity Matching Index (CIM), and the Complementarity Matching Index (CIS). m ), intra-industry trade index (Grubel Lloyd index, GL), and revealed comparative advantage index (Revealed Comparative Advantage index, RCA).

[0091] The trade indicator visualization display module 103 is used to visualize the trade indicators.

[0092] The trade indicator visualization display module 103 specifically includes:

[0093] The first trade indicator retrieval unit is used to retrieve the first trade indicator with the same year and initiating country.

[0094] The second trade indicator retrieval unit is used to retrieve the second trade indicator with the same year and initiating country.

[0095] The first normalization processing unit is used to normalize the first trade index with the same year and initiating country to obtain the trade competitiveness or complementarity weights between the initiating country and each cooperating country.

[0096] The second normalization processing unit is used to normalize the second trade index with the same year and initiating country, so as to obtain the weights of the comparative trade advantages of various commodities exported by the initiating country.

[0097] The trade competitiveness or complementarity weight display unit is used to display the trade competitiveness or complementarity weights between the initiating country and each cooperating country using an undirected network graph.

[0098] The trade comparative advantage level weight display unit is used to display the trade comparative advantage level weights of various commodities exported by the initiating country using an undirected network graph.

[0099] The first search indicator display unit is used to display the first trade indicator with the same year and initiating country by using a table chart.

[0100] The second search indicator display unit is used to display the second trade indicator with the same year and initiating country by using a table chart.

[0101] Among them, the year and the initiating country are the same at the same time, which means the year is the same and the initiating country is the same.

[0102] The trade index visualization display module 103 is an international trade index display module. The user imports the trade index calculation result data, determines the three attributes of trade index, year, and country, retrieves the trade index data of the initiating country and the cooperating country (or commodity) in the year from the trade index calculation result data, and displays the trade competitiveness or complementarity weights between countries (or commodities) in the form of an undirected network diagram (the trade competitiveness or complementarity weights are normalized by normalizing the specific values ​​of the six trade indexes, and then displaying the weights in an undirected network diagram); for the other five trade indexes other than RCA, the trade index calculation result data includes four attributes: year, country 1, country 2, and trade index value ; For the RCA trade index, the trade index calculation result data includes data items: year, country, commodity number, and trade index value. Since the trade index calculation result has four attributes, the attribute values ​​of three attributes can be determined to retrieve (determine) the desired multiple records (same as the "record" concept of the data table in the database). The trade index calculation result is the specific values ​​of the six trade indexes. The specific values ​​of the six trade indexes have no relationship with the four attributes of year, trade flow (i.e. import or export), originating country, and commodity number. It is like the score of a certain subject taken by a certain student in a certain class in a certain year. The year, class, student, and subject are the four attributes. The score is determined by determining the four attributes. The user selects the "Index Data Table" control to display the retrieved trade index data in detail in the form of a table. The table diagram has nothing to do with the undirected network diagram. It is just two forms of expression of trade index data. The network diagram is more vivid, but the network diagram cannot see the specific values. The table diagram is similar to an Excel table, which can see the specific values.

[0103] Among them, for the other five trade indices of the Revealed Comparative Advantage index (RCA), the undirected network diagram in the international trade index display module (calling the forceNetwork function of the R language package) involves node data, starting point, end point, node name, edge, and edge thickness. A node data represents a record of the international trade index data. The starting point represents country 1, the end point represents country 2, the node name includes the name of country 1 and the name of country 2, the edge represents the trade competition or complementary relationship between country 1 and country 2, and the edge thickness represents the weight of the trade index. For the RCA trade index, the undirected network diagram involves node data, starting point, end point, node name, edge, and edge thickness. A node data represents a record of the RCA trade index data. The starting point represents a country, the end point represents the product number, the node name includes the country name and the product name, the edge represents the country's export of the product, and the edge thickness represents the weight of the country's trade comparative advantage level of the export product. The content displayed by the "Index Data Table" control includes four attributes for the other five non-RCA trade indexes: year, country 1, country 2, and trade index value; and four attributes for the RCA trade index: year, country, product number, and trade index value.

[0104] Specifically, the trade indicator visualization system based on international trade commodity data also includes:

[0105] The international trade commodity data retrieval module is used to retrieve multiple international trade commodity data with the same year, trade flow, initiating country and commodity number.

[0106] The normalization processing module is used to normalize the trade amounts in the international trade commodity data with the same year, trade flow, initiating country and commodity number, and obtain the trade weights between the initiating country and each cooperating country.

[0107] The trade weight display module is used to display the trade weight between the initiating country and each partner country using a directed network graph.

[0108] The retrieval data display module is used to display multiple international trade commodity data with the same year, trade flow, initiating country and commodity number using a table chart.

[0109] Among them, the year, trade flow, originating country and commodity number are the same at the same time, that is, the year is the same, the trade flow is the same, the originating country is the same and the commodity number is the same.

[0110] In this embodiment, the international trade commodity data retrieval module, the normalization processing module, the trade weight display module and the retrieval data display module together constitute an international trade data display module. The international trade data display module obtains the import and export trade volume data of multiple countries and multiple categories of trade commodities in multiple years based on the international trade commodity data based on the International Trade Standard Classification (SITC) provided by the United Nations Commodity Trade Statistics Database UN Comtrade, and displays the trade weights and trade volumes between countries in two forms: a directed network diagram and a table diagram. For example, the meaning of trade weight is that if China imports commodities from 60 other countries, there are 60 data (trade volumes), and the maximum value of the 60 data may be hundreds of millions, and the minimum value may be only tens of thousands, thousands or ten thousand times the difference, then these data are normalized to the range of [1, 100], and the thickness of the edge of the network diagram is used to represent the weight size, so that it can be very vividly displayed which country's commodity trade volume China imports is the largest and which is the smallest. The international trade data display module only processes international trade commodity data based on the International Trade Standard Classification (SITC), that is, the original international trade commodity data. In this international trade data display module, the user selects the file path where the import and export trade quota data is located, imports the import and export trade quota data, determines the four attributes of year, trade flow (i.e. import or export), initiating country, and commodity number, retrieves the trade data (import or export) of the country and the commodity with other partner countries in that year from the import and export trade quota data, and displays the trade weight between the initiating country and the partner country in the form of a directed network graph; the user selects the "Trade Data Table" control to display the retrieved trade data in detail in the form of a table graph.

[0111] Among them, the directed network diagram of the international trade data display module involves node data, starting point, end point, node name, edge, edge direction, and edge thickness. A node data represents a record of international trade commodity data. The starting point represents the initiating country, the end point represents the cooperating country, the node name includes the name of the initiating country and the name of the cooperating country, the edge represents the trade relationship between the initiating country and the cooperating country, the edge direction represents the trade flow (export or import), and the edge thickness represents the weight of the trade amount. The content displayed by the "Trade Data Table" control includes 7 attributes of data items: year, trade flow, initiating country, cooperating country, commodity number, commodity name, and trade amount.

[0112] In this embodiment, the directed network diagram is of the international trade data display module (commodity trade flows, i.e., imports and exports, have directions), and the directed network diagram is generated by calling the ForceNetwork function in the R language package. The undirected network diagram is of the international trade index display module (the size of the trade index represents the size of competitiveness, and has no direction), and there is no relationship between the directed network diagram and the undirected network diagram.

[0113] The international trade data display module in this embodiment can refer to the existing international trade data display module, such as the international trade data and visualization website recommendation|sciping.com. The international trade data display module composed of the international trade commodity data retrieval module, the normalization processing module, the trade weight display module and the retrieval data display module can make the display system of the present invention more comprehensive, not just for the calculation and display of the index (trade index).

[0114] The following uses the calculation of the ESI index as an example to illustrate the trade index calculation and visualization system based on international trade commodity data of the present invention:

[0115] The international trade data of the international trade data display module comes from the United Nations Commodity Trade Statistics Database UNComtrade. For detailed information on the seven attributes, see Table 1.

[0116] Table 1 Attribute table of UN Comtrade international trade data

[0117]

[0118]

[0119] The process of building a directed network diagram is as follows: the user selects the file path where the international trade data is located and imports it into the system of the present invention, determines the attribute values ​​of the four controls of the system, namely, year, trade flow, initiating country, and commodity number in the attribute control, and the system searches for the trade data of the country, the commodity, and other cooperating countries in the international trade data for the year. The user selects the "trade data network" control, the system calculates the trade quota weight of the trade commodity between the initiating country and the cooperating country, and displays the trade weight between the initiating country and the cooperating country in the form of a directed network diagram; the user then selects the "trade data table" control, and the system displays the searched trade data in detail in the form of a table diagram according to the 7 attributes of Table 1.

[0120] The international trade index calculation module, taking the ESI index as an example, is based on the collected international trade commodity data according to the formula Calculate a ik and a jk , that is, the proportion of the k-th product in the total exports of countries i and j, and determine the common export commodities of countries i and j in market w. The user imports the calculation result data file into the system of the present invention. After the system automatically reads the required parameter data, selects the "ESI" attribute value in the "Trade Index" attribute control, and selects "ESI Index" in the index calculation module. The system will calculate the value according to the formula Calculate the ESI values ​​between countries for multiple years, and the results of each calculation will be output to the Console window. After the calculation is completed, the Console window displays that the user can save the calculation result data of the trade index in the set folder. The user can also filter and save the trade index data related to the year and country by determining the property values ​​of the system's year, country and other controls in the property control. See Table 2 for the property table of the ESI index.

[0121] Table 2 Attribute table of ESI international trade index data

[0122]

[0123] In the international trade index display module, taking the ESI index as an example, the user imports the ESI index calculation result data, and by determining the three attributes of trade index, year, and country in the attribute control, the system retrieves the trade index data of the initiating country and the competing country (or cooperating country) in that year from the trade index calculation result data. When the user selects the "index data network" control, the system calculates the ESI trade competitiveness index weight between the initiating country and the competing country, and displays the ESI index weight between the initiating country and the cooperating country in the form of an undirected network graph; at the same time, when the user selects the "index data table" control, the system displays the retrieved trade index data in detail in the form of a table graph according to the four attributes in Table 2.

[0124] The present invention is based on the trade index calculation and visualization system of international trade commodity data, which can realize the interactive calculation and visualization of massive international trade commodity data, and display the multi-dimensional international trade commodity data in the form of network diagrams and table diagrams, so that relevant users can see the visualization effect very intuitively, which is convenient for users to analyze the original international trade commodity data and trade index data more quickly and accurately, and can allow relevant researchers to conduct deeper mining and analysis of international trade data, and allow users of relevant government departments to conduct multi-level comparisons and decisions.

[0125] Compared with the existing systems, the present invention provides a trade indicator calculation and visualization system based on international trade commodity data, such as Figure 2 shown. Figure 2 This is a structural module block diagram of a trade indicator calculation and visualization system based on international trade commodity data of the present invention, see Figure 2, the trade index calculation and visualization system based on international trade commodity data is a system for calculating and visualizing international trade commodity data, specifically a system for calculating and visualizing trade indexes. The trade index calculation and visualization system based on international trade commodity data uses the Shiny App interactive Web framework technology to better interactively calculate and analyze international trade data. The role of the Shiny App interactive Web framework technology is to make an interactive interface, visualize data, calculate trade data and visualize trade data. The system developed by the present invention mainly includes three functional modules: an international trade data display module, an international trade index calculation module and an international trade index display module. The function of the international trade data display module includes reading the import and export amounts of multiple types of trade commodities in multiple countries, and displaying the trade amounts and trade weights between countries in the form of network diagrams and table diagrams. The function of the international trade index calculation module includes the calculation of 6 trade competitiveness and complementarity indexes and the preservation of calculation result data. The function of the international trade index display module includes displaying the trade index intensity between countries or the trade index intensity between countries and commodities in the form of network diagrams and table diagrams. The present invention can provide analysis and decision support for relevant researchers and government departments.

[0126] Compared with the prior art, the present invention has the following beneficial effects:

[0127] 1. The trade indicator calculation and visualization system based on international trade commodity data of the present invention is based on international trade data and uses the Shiny App interactive Web framework technology to better interactively calculate and analyze international trade data, and can provide technical and decision-making support for relevant researchers and government departments.

[0128] 2. The trade indicator calculation and visualization system based on international trade commodity data of the present invention realizes the network diagram and table diagram display of the original international trade commodity data, allowing users to clearly see the visualization effect, and facilitating users to analyze the original international trade data more quickly and accurately.

[0129] 3. The trade index calculation and visualization system based on international trade commodity data of the present invention provides calculation and storage of six trade competitiveness and complementarity indexes, and realizes the network diagram and table diagram display of international trade index data. Relevant researchers and government department users can conduct deeper mining and analysis of international trade data, and conduct multi-level comparison and decision-making on trade index data.

[0130] Figure 3 Flow chart of an embodiment of the method for visualizing trade indicators based on international trade commodity data of the present invention. Figure 3, the trade indicator visualization method based on international trade commodity data includes:

[0131] Step 301: Acquire multiple international trade commodity data; each international trade commodity data includes year, trade flow, initiating country, cooperating country, commodity number, commodity name and trade amount; trade flow is import or export.

[0132] Step 302: Calculate trade indicators based on international trade commodity data; trade indicators include export similarity index, trade integration index, trade competitiveness index, trade structure matching index, intra-industry trade index and revealed comparative advantage index.

[0133] The step 302 specifically includes:

[0134] The first trade index corresponding to any year is calculated based on the international trade commodity data; the first trade index includes the export similarity index, trade integration index, trade competitiveness index, trade structure matching index and intra-industry trade index between any initiating country and each cooperating country.

[0135] The second trade index corresponding to any year is calculated based on the international trade commodity data; the second trade index includes the explicit comparative advantage index of any initiating country in exporting various commodities.

[0136] Step 303: Visualize and display the trade indicators.

[0137] The step 303 specifically includes:

[0138] Retrieve the first trade indicator with the same year and originating country.

[0139] Retrieve the second trade indicator with the same year and originating country.

[0140] The first trade indicators with the same year and initiating country are normalized to obtain the trade competitiveness or complementarity weights between the initiating country and each cooperating country.

[0141] The second trade index with the same year and initiating country is normalized to obtain the weights of the comparative trade advantage level of various commodities exported by the initiating country.

[0142] An undirected network graph is used to show the trade competitiveness or complementarity weights between the initiating country and each partner country.

[0143] An undirected network graph is used to show the weights of the level of comparative trade advantage of the initiating country in exporting various commodities.

[0144] The table shows the first trade indicators with the same year and originating country.

[0145] Use a table chart to display the second trade indicator with the same year and originating country.

[0146] Specifically, the trade indicator visualization method based on international trade commodity data also includes:

[0147] Retrieve data on multiple international trade commodities with the same year, trade flow, originating country and commodity number.

[0148] The trade amounts in the international trade commodity data with the same year, trade flow, initiating country and commodity number are normalized to obtain the trade weights between the initiating country and each partner country.

[0149] A directed network diagram is used to show the trade weights between the initiating country and each partner country.

[0150] Use a table chart to display data on multiple international trade commodities with the same year, trade flow, originating country and commodity number.

[0151] In this specification, each embodiment is described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the embodiments can be referred to each other. For the system disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant parts can be referred to the method part.

[0152] The principles and implementation methods of the present invention are described in this article using specific examples. The description of the above embodiments is only used to help understand the method and core idea of ​​the present invention. At the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as limiting the present invention.

Claims

1. A trade indicator visualization system based on international trade commodity data, characterized in that: The system comprises: An international trade commodity data acquisition module is used to acquire multiple international trade commodity data; each of the international trade commodity data includes year, trade flow, initiating country, cooperating country, commodity number, commodity name and trade amount; the trade flow is import or export; A trade index calculation module, used to calculate trade indicators based on the international trade commodity data; the trade indicators include export similarity index, trade integration index, trade competitiveness index, trade structure matching index, intra-industry trade index and explicit comparative advantage index; A trade indicator visualization display module, used for visually displaying the trade indicators; The trade index calculation module specifically includes: A first trade index calculation unit, used to calculate the first trade index corresponding to any of the years according to the international trade commodity data; the first trade index includes an export similarity index, a trade integration index, a trade competitiveness index, a trade structure matching index and an intra-industry trade index between any of the initiating countries and each of the cooperating countries; A second trade index calculation unit, used to calculate a second trade index corresponding to any of the years according to the international trade commodity data; the second trade index includes an explicit comparative advantage index of various commodities exported by any of the initiating countries; The trade indicator visualization display module specifically includes: A first trade indicator retrieval unit, used for retrieving the first trade indicator having the same year and the same initiating country; A second trade indicator retrieval unit, used for retrieving the second trade indicator having the same year and the same initiating country; A first normalization processing unit is used to perform normalization processing on the first trade indicators that are the same in the year and the initiating country, so as to obtain the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries; A second normalization processing unit is used to perform normalization processing on the second trade indicators that are the same in the year and the initiating country, so as to obtain the weights of the comparative trade advantages of various commodities exported by the initiating country; A trade competitiveness or complementarity weight display unit, used to display the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries using an undirected network graph; A trade comparative advantage level weight display unit, used to display the trade comparative advantage level weights of various commodities exported by the initiating country using an undirected network graph; A first search index display unit, used for displaying the first trade index having the same year and the same initiating country by using a table chart; The second search indicator display unit is used to display the second trade indicator with the same year and the same initiating country by using a table chart.

2. The trade indicator visualization system based on international trade commodity data according to claim 1 is characterized in that: The system further comprises: An international trade commodity data retrieval module, used to retrieve a plurality of international trade commodity data having the same year, trade flow, initiating country and commodity number; A normalization processing module, used for normalizing the trade amount in each of the international trade commodity data with the same year, trade flow, initiating country and commodity number, to obtain the trade weight between the initiating country and each of the cooperating countries; A trade weight display module, used for displaying the trade weight between the initiating country and each of the cooperating countries using a directed network diagram; The retrieval data display module is used to display the international trade commodity data with the same year, trade flow, initiating country and commodity number by using a table chart.

3. A trade indicator visualization method based on international trade commodity data, characterized in that: The method comprises: Acquire multiple international trade commodity data; each of the international trade commodity data includes year, trade flow, initiating country, cooperating country, commodity number, commodity name and trade amount; the trade flow is import or export; Calculating trade indicators based on the international trade commodity data; the trade indicators include export similarity index, trade integration index, trade competitiveness index, trade structure matching index, intra-industry trade index and explicit comparative advantage index; Visualizing the trade indicators; The calculation of trade indicators based on the international trade commodity data specifically includes: Calculate the first trade index corresponding to any of the years according to the international trade commodity data; the first trade index includes the export similarity index, trade integration index, trade competitiveness index, trade structure matching index and intra-industry trade index between any of the initiating countries and each of the cooperating countries; Calculating a second trade index corresponding to any of the years according to the international trade commodity data; the second trade index includes an explicit comparative advantage index of various commodities exported by any of the initiating countries; The visual display of the trade indicators specifically includes: Retrieving the first trade indicator having the same year and the same initiating country; Retrieving the second trade indicator having the same year and the same initiating country; Normalizing the first trade indicators that are the same in both the year and the initiating country to obtain the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries; Normalizing the second trade index that is the same in the year and the initiating country to obtain the weights of the comparative trade advantages of various commodities exported by the initiating country; Using an undirected network graph to display the trade competitiveness or complementarity weights between the initiating country and each of the cooperating countries; Use an undirected network graph to show the weights of the comparative trade advantages of the initiating country in exporting various commodities; Displaying the first trade indicator for the same year and the same initiating country using a table chart; The second trade indicator for the same year and the same initiating country is displayed using a tabular chart.

4. The method for visualizing trade indicators based on international trade commodity data according to claim 3 is characterized in that: The method further comprises: Retrieving a plurality of international trade commodity data having the same year, trade flow, originating country and commodity number; Normalizing the trade amounts in the international trade commodity data with the same year, trade flow, initiating country and commodity number to obtain trade weights between the initiating country and each of the cooperating countries; Using a directed network graph to display the trade weight between the initiating country and each of the cooperating countries; A plurality of international trade commodity data having the same year, trade flow, originating country and commodity number are displayed in a table chart.

Images