CN115481938A - Regional electronic commerce development level evaluation method and system - Google Patents

Abstract

The invention discloses a method and a system for evaluating regional e-commerce development level, belongs to the technical field of data processing, and aims to solve the technical problem of how to process and analyze related data of an e-commerce platform. The method comprises the following steps: the commodity data is summarized to store data, and data standardization processing is carried out to obtain e-commerce data; carrying out data cleaning on the e-commerce data; establishing a regional sales and operation summary table, and summarizing e-commerce data corresponding to shops in a region to the regional sales and operation summary table; establishing a plurality of analysis subject banks, and labeling stores in each region according to evaluation indexes of the analysis subject banks based on E-commerce data; for each region, carrying out multi-dimensional calculation on the electricity merchant development level of the region based on macroscopic economic data and electricity merchant data, and storing the obtained analysis result into a data table; for each region, an e-commerce level development index report is generated by an automated report generation tool based on the corresponding data table.

Description

Translated fromChinese

地区电商发展水平的评价方法及系统Evaluation method and system of regional e-commerce development level

技术领域technical field

本发明涉及数据处理技术领域，具体地说是地区电商发展水平的评价方法及系统。The invention relates to the technical field of data processing, in particular to a method and system for evaluating the development level of regional e-commerce.

背景技术Background technique

如今，电子商务和网络零售领域的进入了高速发展的阶段，随着越来越多的电商平台及销售方式的诞生，各地区电商发展的水平很难进行统计和计算。政府有关部门及电商监测机构亟待了解地方电商运营数据及销售数据，以便了解当地电商发展现状；企业想了解地区电商发展水平和方向，以便进行经营和投资。Nowadays, the field of e-commerce and online retail has entered a stage of rapid development. With the birth of more and more e-commerce platforms and sales methods, it is difficult to make statistics and calculations on the development level of e-commerce in various regions. Relevant government departments and e-commerce monitoring agencies urgently need to know local e-commerce operation data and sales data in order to understand the development status of local e-commerce; enterprises want to understand the development level and direction of regional e-commerce for operation and investment.

如何对电商平台的相关数据进行处理分析，是需要解决的技术问题。How to process and analyze the relevant data of the e-commerce platform is a technical problem that needs to be solved.

发明内容Contents of the invention

本发明的技术任务是针对以上不足，提供地区电商发展水平的评价方法及系统，来解决如何对电商平台的相关数据进行处理分析的技术问题。The technical task of the present invention is to solve the technical problem of how to process and analyze the relevant data of the e-commerce platform by providing an evaluation method and system for the development level of regional e-commerce in view of the above deficiencies.

第一方面，本发明一种地区电商发展水平的评价方法，包括如下步骤：In the first aspect, the present invention provides a method for evaluating the development level of regional e-commerce, comprising the following steps:

通过公开渠道采集电商平台相关的商品数据和店铺数据；Collect product data and store data related to e-commerce platforms through open channels;

将商品数据汇总到店铺数据，并进行数据标准化处理，得到电商数据；Summarize commodity data into store data, and perform data standardization processing to obtain e-commerce data;

对所述电商数据进行数据清洗，去除异常店铺对应的电商数据，得到清洗后电商数据；Carry out data cleaning on the e-commerce data, remove the e-commerce data corresponding to abnormal stores, and obtain the cleaned e-commerce data;

建立地区销售及运营汇总表，将地区内的店铺对应的电商数据汇总至地区销售及运营汇总表；Establish a regional sales and operation summary table, and summarize the e-commerce data corresponding to the stores in the region to the regional sales and operation summary table;

建立多个分析专题库，每个分析专题库中设置有评价指标并配置有标签，对于每个地区的店铺，基于电商数据、按照各分析专题库的评价指标进行标签化处理；Establish multiple analysis thematic libraries, each of which is equipped with evaluation indicators and labels, and for stores in each region, based on e-commerce data, carry out labeling according to the evaluation indicators of each analysis thematic library;

通过公开渠道采集各个地区的宏观经济数据，对于每个地区，基于宏观经济数据以及电商数据、对所述地区的电商发展水平进行多维度计算，将得到的分析结果存储至数据表；The macroeconomic data of each region is collected through open channels. For each region, based on the macroeconomic data and e-commerce data, multi-dimensional calculations are performed on the e-commerce development level of the region, and the obtained analysis results are stored in the data table;

对于每个地区，基于对应的数据表、通过自动化报告生成工具生成所述地区的电商水平发展指数报告。For each region, based on the corresponding data table, an automated report generation tool is used to generate an e-commerce level development index report for the region.

作为优选，所述商品数据包括商品ID、商品名称、店铺ID、品牌名称、销售量、价格、商品一级类目、商品参数、商品发货地以及评论详情；Preferably, the product data includes product ID, product name, store ID, brand name, sales volume, price, first-level product category, product parameters, product delivery place and review details;

所述店铺数据包括店铺名称、店铺ID、店铺类型、所属企业名称以及统一社会信用代码；The store data includes store name, store ID, store type, affiliated enterprise name and unified social credit code;

通过店铺ID将采集的商品数据汇总到店铺数据并标准化处理。Summarize the collected product data into store data through the store ID and standardize it.

作为优选，基于企业工商所在地、店铺主营发货地以及店铺经营所在地，建立地区销售及运营汇总表，将地区内的店铺汇总至所述地区销售及运营汇总表；As a preference, based on the industrial and commercial location of the enterprise, the main delivery place of the store, and the location of the store, a regional sales and operation summary table is established, and the stores in the region are summarized into the regional sales and operation summary table;

其中企业工商所在地优先级高于店铺主营发货地，店铺主营发货地优先级高于店铺经营所在地。Among them, the priority of the industrial and commercial location of the enterprise is higher than the main delivery location of the store, and the priority of the main delivery location of the store is higher than that of the store operation location.

作为优选，所述分析专题库包括分交易类型、分交易模式、分行业、分平台、分规模的分析专题库。Preferably, the analysis subject database includes analysis subject databases divided into transaction types, transaction modes, industries, platforms and scales.

作为优选，所述宏观经济数据包括GDP、人口增长以及就业率；Preferably, said macroeconomic data include GDP, population growth and employment rate;

对于每个地区，基于宏观经济数据以及电商数据、通过多因子算法模型对所述地区的电商发展水平进行多维度计算，得出综合得分、电商发展指数、电商从业人数作为计算结果，将所述计算结果存储至数据表。For each region, based on macroeconomic data and e-commerce data, the multi-dimensional calculation of the e-commerce development level of the region is carried out through a multi-factor algorithm model, and the comprehensive score, e-commerce development index, and number of e-commerce employees are obtained as calculation results , and store the calculation result in the data table.

第二方面，本发明一种地区电商发展水平的评价系统，用于通过如第一方面任一项所述的一种地区电商发展水平的评价对每个地区进行电商发展水平分析计算，所述系统包括：In the second aspect, the present invention provides an evaluation system for the development level of regional e-commerce, which is used to analyze and calculate the development level of e-commerce in each region through the evaluation of the development level of e-commerce in a region as described in any one of the first aspects. , the system includes:

电商数据采集模块，所述电商数据采集模块用于通过公开渠道采集电商平台相关的商品数据和店铺数据；An e-commerce data collection module, the e-commerce data collection module is used to collect commodity data and store data related to the e-commerce platform through open channels;

电商数据构建模块，所述电商数据构建模块用于将商品数据汇总到店铺数据，并进行数据标准化处理，得到电商数据；An e-commerce data building module, the e-commerce data building module is used to summarize commodity data into store data, and perform data standardization processing to obtain e-commerce data;

数据清洗模块，所述数据清洗模块用于对所述电商数据进行数据清洗，去除异常店铺对应的电商数据，得到清洗后电商数据；A data cleaning module, the data cleaning module is used to perform data cleaning on the e-commerce data, remove the e-commerce data corresponding to abnormal stores, and obtain the cleaned e-commerce data;

汇总表构建模块，所述汇总表构建模块用于建立地区销售及运营汇总表，将地区内的店铺对应的电商数据汇总至地区销售及运营汇总表；A summary table construction module, the summary table construction module is used to establish a regional sales and operation summary table, and summarize the e-commerce data corresponding to the stores in the region to the regional sales and operation summary table;

专题分析模块，所述专题分析模块用于建立多个分析专题库，每个分析专题库中设置有评价指标并配置有标签，对于每个地区的店铺，用于基于电商数据、按照各分析专题库的评价指标进行标签化处理；Thematic analysis module, the thematic analysis module is used to establish a plurality of analysis thematic databases, each analysis thematic database is provided with evaluation indicators and configured with labels, for stores in each region, it is used to The evaluation indicators of the thematic database are tagged;

宏观经济数据采集模块，所述宏观经济数据采集模块用于通过公开渠道采集各个地区的宏观经济数据，A macroeconomic data collection module, the macroeconomic data collection module is used to collect macroeconomic data in various regions through open channels,

多维分析模块，所述多维分析模块用于基于宏观经济数据以及电商数据、对所述地区的电商发展水平进行多维度计算，将得到的分析结果存储至数据表；A multi-dimensional analysis module, the multi-dimensional analysis module is used to perform multi-dimensional calculations on the development level of e-commerce in the region based on macroeconomic data and e-commerce data, and store the obtained analysis results in a data table;

报告生成模块，对于每个地区，所述报告生成模块用于基于对应的数据表、通过自动化报告生成工具生成所述地区的电商水平发展指数报告。A report generation module, for each region, the report generation module is used to generate the e-commerce level development index report of the region based on the corresponding data table and through the automatic report generation tool.

作为优选，所述商品数据包括商品ID、商品名称、店铺ID、品牌名称、销售量、价格、商品一级类目、商品参数、商品发货地以及评论详情；Preferably, the product data includes product ID, product name, store ID, brand name, sales volume, price, first-level product category, product parameters, product delivery place and review details;

所述店铺数据包括店铺名称、店铺ID、店铺类型、所属企业名称以及统一社会信用代码；The store data includes store name, store ID, store type, affiliated enterprise name and unified social credit code;

所述电商数据构建模块用于通过店铺ID将采集的商品数据汇总到店铺数据并标准化处理。The e-commerce data building module is used for summarizing the collected product data into store data through the store ID and standardizing the process.

作为优选，所述汇总表构建模块用于基于企业工商所在地、店铺主营发货地以及店铺经营所在地，建立地区销售及运营汇总表，将地区内的店铺汇总至所述地区销售及运营汇总表；Preferably, the summary table construction module is used to establish a regional sales and operation summary table based on the industrial and commercial location of the enterprise, the main delivery place of the store, and the store operation location, and summarize the stores in the region into the regional sales and operation summary table ;

其中企业工商所在地优先级高于店铺主营发货地，店铺主营发货地优先级高于店铺经营所在地。Among them, the priority of the industrial and commercial location of the enterprise is higher than the main delivery location of the store, and the priority of the main delivery location of the store is higher than that of the store operation location.

作为优选，所述分析专题库包括分交易类型、分交易模式、分行业、分平台、分规模的分析专题库。Preferably, the analysis subject database includes analysis subject databases divided into transaction types, transaction modes, industries, platforms and scales.

作为优选，所述宏观经济数据包括GDP、人口增长以及就业率；Preferably, said macroeconomic data include GDP, population growth and employment rate;

对于每个地区，所述多维分析模块用于基于宏观经济数据以及电商数据、通过多因子算法模型对所述地区的电商发展水平进行多维度计算，得出综合得分、电商发展指数、电商从业人数作为计算结果，将所述计算结果存储至数据表。For each region, the multi-dimensional analysis module is used to perform multi-dimensional calculations on the e-commerce development level of the region based on macroeconomic data and e-commerce data through a multi-factor algorithm model to obtain a comprehensive score, e-commerce development index, The number of e-commerce practitioners is used as the calculation result, and the calculation result is stored in the data table.

本发明的地区电商发展水平的评价方法及系统具有以下优点：The evaluation method and system of the regional electric business development level of the present invention have the following advantages:

1、对地方政府及商务主管部门来说，可以更好地掌握地区电商发展水平，洞察地区电商发展的优势和劣势，及时引导电子商务高质量发展；1. For local governments and commercial authorities, they can better grasp the development level of regional e-commerce, gain insight into the advantages and disadvantages of regional e-commerce development, and guide the high-quality development of e-commerce in a timely manner;

2、对电商监测机构而言，综合了解地区电商发展水平和能力，多维度分析地区电商的发展潜力；2. For e-commerce monitoring agencies, comprehensively understand the development level and capabilities of regional e-commerce, and analyze the development potential of regional e-commerce in multiple dimensions;

3、对电商企业来说，根据地区电商的产业带及发展水平的差异化，选择适合的地区进行相应的经营和投资。3. For e-commerce companies, according to the differences in the regional e-commerce industry belts and development levels, select suitable regions for corresponding operations and investments.

附图说明Description of drawings

为了更清楚地说明本发明实施例中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域的普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的附图。In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the accompanying drawings that need to be used in the descriptions of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only of the present invention. For some embodiments, those skilled in the art can also obtain other drawings based on these drawings without creative effort.

下面结合附图对本发明进一步说明。The present invention will be further described below in conjunction with the accompanying drawings.

图1为实施例1一种地区电商发展水平的评价方法的流程框图。FIG. 1 is a flow chart of a method for evaluating the development level of regional e-commerce in Embodiment 1.

具体实施方式detailed description

下面结合附图和具体实施例对本发明作进一步说明，以使本领域的技术人员可以更好地理解本发明并能予以实施，但所举实施例不作为对本发明的限定，在不冲突的情况下，本发明实施例以及实施例中的技术特征可以相互结合。The present invention will be further described below in conjunction with accompanying drawing and specific embodiment, so that those skilled in the art can better understand the present invention and can be implemented, but the embodiment given is not as the limitation of the present invention, in the case of no conflict Next, the embodiments of the present invention and the technical features in the embodiments can be combined with each other.

本发明实施例提供地区电商发展水平的评价方法及系统，用于解决如何对电商平台的相关数据进行处理分析的技术问题。Embodiments of the present invention provide a method and system for evaluating the development level of regional e-commerce, which are used to solve the technical problem of how to process and analyze the relevant data of the e-commerce platform.

实施例1：Example 1:

本发明一种地区电商发展水平的评价方法，包括如下步骤：A method for evaluating the development level of regional electricity suppliers in the present invention comprises the following steps:

S100、通过公开渠道采集电商平台相关的商品数据和店铺数据；S100. Collect commodity data and store data related to the e-commerce platform through public channels;

S200、将商品数据汇总到店铺数据，并进行数据标准化处理，得到电商数据；S200. Summarize commodity data into store data, and perform data standardization processing to obtain e-commerce data;

S300、对所述电商数据进行数据清洗，去除异常店铺对应的电商数据，得到清洗后电商数据；S300. Perform data cleaning on the e-commerce data, remove e-commerce data corresponding to abnormal stores, and obtain cleaned e-commerce data;

S400、建立地区销售及运营汇总表，将地区内的店铺对应的电商数据汇总至地区销售及运营汇总表；S400. Establish a regional sales and operation summary table, and summarize the e-commerce data corresponding to the stores in the region into the regional sales and operation summary table;

S500、建立多个分析专题库，每个分析专题库中设置有评价指标并配置有标签，对于每个地区的店铺，基于电商数据、按照各分析专题库的评价指标进行标签化处理，得到所述店铺在各个分析专题库下的标签；S500. Establish multiple analysis thematic databases. Each analysis thematic database is provided with evaluation indicators and labels. For the stores in each region, based on the e-commerce data, the labeling process is performed according to the evaluation indicators of each analysis thematic database, and the obtained The label of the store under each analysis theme library;

S600、通过公开渠道采集各个地区的宏观经济数据，对于每个地区，基于宏观经济数据以及每个店铺在各个分析专题库下的标签、对所述地区的电商发展水平进行多维度计算，将得到的分析结果存储至数据表；S600. Collect the macroeconomic data of each region through open channels. For each region, based on the macroeconomic data and the labels of each store in each analysis database, perform multi-dimensional calculations on the e-commerce development level in the region, and The obtained analysis results are stored in the data table;

S700、对于每个地区，基于对应的数据表、通过自动化报告生成工具生成所述地区的电商水平发展指数报告。S700. For each region, generate an e-commerce level development index report for the region based on the corresponding data table and using an automated report generation tool.

本实施例步骤S100通过公开渠道采集相关电商平台的商品ID、商品名称、店铺ID、品牌名称、销售量、价格、商品一级类目、商品参数、商品发货地、评论详情等商品数据。采集相关电商平台的店铺名称、店铺ID、店铺类型、所属企业名称、统一社会信用代码等店铺数据。Step S100 of this embodiment collects commodity data such as product ID, product name, store ID, brand name, sales volume, price, first-level product category, product parameters, product delivery place, and review details of the relevant e-commerce platform through public channels. . Collect store data such as store names, store IDs, store types, affiliated company names, and unified social credit codes on relevant e-commerce platforms.

本实施例步骤S200通过数据库等数据管理系统，根据店铺ID对步骤S100的商品数据汇总到店铺数据并标准化处理。In step S200 of this embodiment, through a data management system such as a database, the product data in step S100 is summarized into store data according to the store ID and standardized.

步骤S300利用现有常规的大数据算法模型，识别刷单、大额优惠券等异常店铺，进行数据清洗。Step S300 uses the existing conventional big data algorithm model to identify abnormal stores such as order swiping and large coupons, and perform data cleaning.

步骤S400建立地区纳统规则，具体的，根据企业工商所在地>店铺主营发货地>店铺经营所在地的规则，建立地区销售及运营汇总表，将地区内的店铺对应的电商数据纳统进对应地区的地区销售及运营汇总表。Step S400 establishes the rules of regional collection and statistics. Specifically, according to the rules of the business location of the enterprise > the main delivery place of the store > the business location of the store, a regional sales and operation summary table is established, and the e-commerce data corresponding to the stores in the region are collected into a unified table. Regional sales and operation summary table for the corresponding region.

步骤S500同时建立分交易类型、分交易模式、分行业、分平台、分规模的分析专题库，对于每个店铺，按照各专题库中指定的评价指标进行标签化处理，得到店铺在各个分析专题库下的标签。Step S500 simultaneously establishes analysis thematic databases by transaction type, transaction mode, industry, platform, and scale. For each store, carry out labeling processing according to the evaluation indicators specified in each thematic library, and obtain the store's analysis topics in each analysis topic. tab under Libraries.

步骤S600通过公开渠道采集各地区GDP、人口增长、就业率等宏观经济数据，并建立数据库表作为地区电商发展水平数据表，根据多因子算法模型，结合每个店铺在各个分析专题库下的标签及宏观经济数据，对地区电商发展进行多维度计算，得出综合得分、电商发展指数、电商从业人数等指标的结果并存入数据表。Step S600 collects macroeconomic data such as GDP, population growth, and employment rate in each region through open channels, and establishes a database table as a data table for the development level of regional e-commerce. Tags and macroeconomic data, multi-dimensional calculation of regional e-commerce development, the results of comprehensive scores, e-commerce development index, number of e-commerce employees and other indicators are obtained and stored in the data table.

该步骤中，为每一个分析专题库计算出一个系数，再结合地区的经济发展规模、电商整体的发展趋势以及其他同级别地区的电商水平对比，最后按照多因子算法模型对地区的电商发展水平进行计算。In this step, a coefficient is calculated for each analysis topic database, combined with the regional economic development scale, the overall development trend of e-commerce, and the comparison of e-commerce levels in other regions of the same level, and finally the e-commerce in the region is calculated according to the multi-factor algorithm model. The level of business development is calculated.

步骤S700通过自动化报告报表工具，梳理数据库中各数据表的映射表关系，自动生成地区电商水平发展指数报告。Step S700 uses the automatic reporting tool to sort out the mapping table relationship of each data table in the database, and automatically generates a regional e-commerce level development index report.

实施例2：Example 2:

本发明一种地区电商发展水平的评价系统，包括电商数据采集模块、电商数据构建模块、数据清洗模块、汇总表构建模块、专题分析模块、宏观经济数据采集模块、多维分析模块以及报告生成模块，该系统执行实施例1公开的方法对每个地区进行电商发展水平分析计算。The present invention is an evaluation system for the development level of regional e-commerce, including an e-commerce data collection module, an e-commerce data construction module, a data cleaning module, a summary table construction module, a thematic analysis module, a macroeconomic data collection module, a multidimensional analysis module and a report A generation module, the system executes the method disclosed in Embodiment 1 to analyze and calculate the development level of e-commerce in each region.

电商数据采集模块用于通过公开渠道采集电商平台相关的商品数据和店铺数据。The e-commerce data collection module is used to collect commodity data and store data related to the e-commerce platform through open channels.

本实施例电商数据采集模块通过公开渠道采集相关电商平台的商品ID、商品名称、店铺ID、品牌名称、销售量、价格、商品一级类目、商品参数、商品发货地、评论详情等商品数据。采集相关电商平台的店铺名称、店铺ID、店铺类型、所属企业名称、统一社会信用代码等店铺数据。The e-commerce data collection module of this embodiment collects the product ID, product name, store ID, brand name, sales volume, price, first-level product category, product parameters, product delivery place, and review details of the relevant e-commerce platform through public channels and other commodity data. Collect store data such as store names, store IDs, store types, affiliated company names, and unified social credit codes on relevant e-commerce platforms.

电商数据构建模块用于将商品数据汇总到店铺数据，并进行数据标准化处理，得到电商数据。The e-commerce data building module is used to aggregate product data into store data, and perform data standardization processing to obtain e-commerce data.

本实施例电商数据构建模块通过数据库等数据管理系统，根据店铺ID对步骤S100的商品数据汇总到店铺数据并标准化处理。The e-commerce data building module of this embodiment summarizes the product data in step S100 into store data and standardizes them according to the store ID through a data management system such as a database.

数据清洗模块用于对所述电商数据进行数据清洗，去除异常店铺对应的电商数据，得到清洗后电商数据。The data cleaning module is used to clean the e-commerce data, remove the e-commerce data corresponding to abnormal stores, and obtain the cleaned e-commerce data.

本实施例数据清洗模块利用现有常规的大数据算法模型，识别刷单、大额优惠券等异常店铺，进行数据清洗。The data cleaning module of this embodiment uses the existing conventional big data algorithm model to identify abnormal stores such as order swiping and large coupons, and perform data cleaning.

汇总表构建模块用于建立地区销售及运营汇总表，将地区内的店铺对应的电商数据汇总至地区销售及运营汇总表。The summary table construction module is used to create a regional sales and operation summary table, and summarize the e-commerce data corresponding to the stores in the region into the regional sales and operation summary table.

本实施例汇总表构建模块用于建立地区纳统规则，具体的，根据企业工商所在地>店铺主营发货地>店铺经营所在地的规则，建立地区销售及运营汇总表，将地区内的店铺对应的电商数据纳统进对应地区的地区销售及运营汇总表。The summary table construction module of this embodiment is used to establish the rules for regional inclusion. Specifically, according to the rules of the business location of the enterprise > the main delivery place of the store > the location of the store operation, a regional sales and operation summary table is established, and the stores in the area correspond to The e-commerce data is included in the regional sales and operation summary table of the corresponding region.

专题分析模块用于建立多个分析专题库，每个分析专题库中设置有评价指标并配置有标签，对于每个地区的店铺，用于基于电商数据、按照各分析专题库的评价指标进行标签化处理，得到所述店铺在各个分析专题库下的标签。The thematic analysis module is used to establish multiple analysis thematic libraries. Each analysis thematic library is set with evaluation indicators and configured with labels. For the stores in each region, it is used to conduct evaluation based on e-commerce data and according to the evaluation indicators of each analysis thematic library. Tag processing, to obtain the tags of the store under each analysis topic library.

本实施例专题分析模块用于同时建立分交易类型、分交易模式、分行业、分平台、分规模的分析专题库，对于每个店铺，按照各专题库中指定的评价指标进行标签化处理，得到店铺在各个分析专题库下的标签。The thematic analysis module of this embodiment is used to simultaneously establish analysis thematic databases by transaction type, transaction mode, industry, platform, and scale. For each store, label processing is performed according to the evaluation indicators specified in each thematic database. Get the labels of the store under each analysis theme library.

宏观经济数据采集模块用于通过公开渠道采集各个地区的宏观经济数据。本实施例宏观经济数据采集模块用于通过公开渠道采集各地区GDP、人口增长、就业率等宏观经济数据。The macroeconomic data collection module is used to collect macroeconomic data of various regions through open channels. The macroeconomic data collection module of this embodiment is used to collect macroeconomic data such as GDP, population growth, and employment rate in various regions through open channels.

多维分析模块用于基于宏观经济数据以及每个店铺在各个分析专题库下的标签、对所述地区的电商发展水平进行多维度计算，将得到的分析结果存储至数据表。The multi-dimensional analysis module is used to perform multi-dimensional calculations on the e-commerce development level in the region based on macroeconomic data and the tags of each store under each analysis thematic library, and store the obtained analysis results in the data table.

本实施例多维分析模块用于建立数据库表作为地区电商发展水平数据表，根据多因子算法模型，结合每个店铺在各个分析专题库下的标签及宏观经济数据，对地区电商发展进行多维度计算，得出综合得分、电商发展指数、电商从业人数等指标的结果并存入数据表。The multidimensional analysis module of this embodiment is used to establish a database table as a regional e-commerce development level data table. According to the multi-factor algorithm model, combined with the labels and macroeconomic data of each store under each analysis topic database, the development of regional e-commerce is multi-dimensional. Dimensional calculations, the results of indicators such as comprehensive score, e-commerce development index, and number of e-commerce employees are obtained and stored in the data table.

该模块每一个分析专题库计算出一个系数，再结合地区的经济发展规模、电商整体的发展趋势以及其他同级别地区的电商水平对比，最后按照多因子算法模型对地区的电商发展水平进行计算。This module calculates a coefficient for each analysis topic library, and then combines the economic development scale of the region, the overall development trend of e-commerce, and the comparison of e-commerce levels in other regions of the same level, and finally calculates the e-commerce development level of the region according to the multi-factor algorithm model Calculation.

对于每个地区，报告生成模块用于基于对应的数据表、通过自动化报告生成工具生成所述地区的电商水平发展指数报告。For each region, the report generation module is used to generate the e-commerce level development index report of the region based on the corresponding data table and through the automatic report generation tool.

本实施例报告生成模块通过自动化报告报表工具，梳理数据库中各数据表的映射表关系，自动生成地区电商水平发展指数报告。The report generating module of this embodiment sorts out the mapping table relationship of each data table in the database through an automated reporting tool, and automatically generates a regional e-commerce level development index report.

上文通过附图和优选实施例对本发明进行了详细展示和说明，然而本发明不限于这些已揭示的实施例，基与上述多个实施例本领域技术人员可以知晓，可以组合上述不同实施例中的代码审核手段得到本发明更多的实施例，这些实施例也在本发明的保护范围之内。The present invention has been shown and described in detail through the accompanying drawings and preferred embodiments above, but the present invention is not limited to these disclosed embodiments, and those skilled in the art based on the above-mentioned multiple embodiments can know that the above-mentioned different embodiments can be combined More embodiments of the present invention can be obtained by means of code review in the present invention, and these embodiments are also within the protection scope of the present invention.

Claims (10)

1. A regional electronic commerce development level evaluation method is characterized by comprising the following steps:

collecting commodity data and shop data related to the merchant platform through a public channel;

the commodity data is summarized to store data, and data standardization processing is carried out to obtain e-commerce data;

carrying out data cleaning on the e-commerce data, and removing the e-commerce data corresponding to the abnormal shop to obtain cleaned e-commerce data;

establishing a regional sales and operation summary table, and summarizing e-commerce data corresponding to shops in a region to the regional sales and operation summary table;

establishing a plurality of analysis subject banks, wherein each analysis subject bank is provided with an evaluation index and is configured with a label, and labeling the shops in each region according to the evaluation index of each analysis subject bank based on e-commerce data to obtain the labels of the shops under each analysis subject bank;

collecting macro economic data of each region through a public channel, carrying out multi-dimensional calculation on the e-commerce development level of each region based on the macro economic data and labels of each shop under each analysis subject bank for each region, and storing the obtained analysis result into a data table;

for each region, an e-commerce level development index report for the region is generated by an automated report generation tool based on the corresponding data table.

2. The regional e-commerce development level evaluation method according to claim 1, wherein the commodity data includes a commodity ID, a commodity name, a store ID, a brand name, a sales volume, a price, a commodity primary category, a commodity parameter, a commodity shipping place, and comment details;

the shop data comprises a shop name, a shop ID, a shop type, a belonging enterprise name and a unified social credit code;

and summarizing the collected commodity data to the shop data through the shop ID and carrying out standardized processing.

3. The regional e-commerce development level evaluation method according to claim 1, wherein a regional sales and operation summary table is established based on an enterprise business location, a store owner and delivery location, and a store operation location, and stores in a region are summarized to the regional sales and operation summary table;

the enterprise business location has higher priority than the main shop and the shipping place, and the main shop and the shipping place have higher priority than the main shop and the operating location.

4. The method according to claim 1, wherein the analysis subject library comprises analysis subject libraries of different transaction types, different transaction patterns, different industries, different platforms and different scales.

5. The method of regional e-commerce development level assessment according to claim 1, wherein the macro-economic data includes GDP, population growth, and employment rate;

and for each region, carrying out multi-dimensional calculation on the e-commerce development level of the region through a multi-factor algorithm model based on macro-economic data and labels of each shop under each analysis subject library to obtain a comprehensive score, an e-commerce development index and the number of e-commerce workers as calculation results, and storing the calculation results into a data table.

6. A regional e-commerce development level evaluation system for performing e-commerce development level analysis calculation for each region through a regional e-commerce development level evaluation according to any one of claims 1 to 5, the system comprising:

the system comprises an e-commerce data acquisition module, a data processing module and a data processing module, wherein the e-commerce data acquisition module is used for acquiring commodity data and shop data related to an e-commerce platform through a public channel;

the e-commerce data construction module is used for summarizing the commodity data to shop data and carrying out data standardization processing to obtain the e-commerce data;

the data cleaning module is used for cleaning the e-commerce data, removing the e-commerce data corresponding to the abnormal shop and obtaining the cleaned e-commerce data;

the system comprises a summary table construction module, a regional sales and operation summary table construction module and a regional sales and operation summary table construction module, wherein the summary table construction module is used for establishing a regional sales and operation summary table and summarizing e-commerce data corresponding to shops in a region to the regional sales and operation summary table;

the system comprises a thematic analysis module, a database management module and a database management module, wherein the thematic analysis module is used for establishing a plurality of analysis thematic libraries, each analysis thematic library is provided with an evaluation index and is provided with a label, and the shop in each region is subjected to labeling treatment according to the evaluation index of each analysis thematic library based on E-commerce data to obtain the label of the shop in each analysis thematic library;

a macro-economic data acquisition module for acquiring macro-economic data of each region through an open channel,

the multidimensional analysis module is used for carrying out multidimensional calculation on the e-commerce development level of the region based on macroscopic economic data and labels of all shops under all analysis subject libraries, and storing the obtained analysis result into a data table;

a report generation module for generating, for each region, an e-commerce level development index report for the region via an automated report generation tool based on a corresponding data table.

7. The regional e-commerce development level evaluation system of claim 6, wherein the commodity data includes a commodity ID, a commodity name, a store ID, a brand name, a sales volume, a price, a commodity primary category, a commodity parameter, a commodity shipping place, and comment details;

the shop data comprises a shop name, a shop ID, a shop type, a name of a belonging enterprise and a unified social credit code;

the e-commerce data construction module is used for summarizing the collected commodity data to store data through store IDs and carrying out standardized processing.

8. The system according to claim 6, wherein the summary table construction module is configured to build a regional sales and operation summary table based on the business location, the business home-office delivery location, and the business management location, and summarize the shops in the region into the regional sales and operation summary table;

the enterprise business location is higher in priority than the shop owner's shipping place, and the shop owner's shipping place is higher in priority than the shop operation location.

9. The system for regional e-commerce development level assessment according to claim 6, wherein said analysis topic database comprises a sub-transaction type, a sub-transaction mode, a sub-industry, a sub-platform, and a sub-scale analysis topic database.

10. The system for regional e-commerce development level assessment according to claim 6, wherein the macro-economic data includes GDP, population growth, and employment rate;

for each region, the multidimensional analysis module is used for carrying out multidimensional calculation on the electricity merchant development level of the region through a multi-factor algorithm model based on macroscopic economic data and electricity merchant data to obtain a comprehensive score, an electricity merchant development index and electricity merchant working population serving as calculation results, and the calculation results are stored in a data table.

Images