CN115423506A - Statistical calculation method and system for price index of on-line living necessities - Google Patents
Statistical calculation method and system for price index of on-line living necessities Download PDFInfo
- Publication number
- CN115423506A CN115423506A CN202211011756.7A CN202211011756A CN115423506A CN 115423506 A CN115423506 A CN 115423506A CN 202211011756 A CN202211011756 A CN 202211011756A CN 115423506 A CN115423506 A CN 115423506A
- Authority
- CN
- China
- Prior art keywords
- price
- commodity
- representative
- sales
- index
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 68
- 238000012544 monitoring process Methods 0.000 claims abstract description 41
- 238000012216 screening Methods 0.000 claims abstract description 27
- 238000000034 method Methods 0.000 claims abstract description 15
- 230000002159 abnormal effect Effects 0.000 claims description 22
- 230000000875 corresponding effect Effects 0.000 claims description 14
- 230000005484 gravity Effects 0.000 claims description 8
- 235000013311 vegetables Nutrition 0.000 claims description 7
- 230000002596 correlated effect Effects 0.000 claims description 4
- 238000005406 washing Methods 0.000 claims description 4
- 230000000737 periodic effect Effects 0.000 claims description 2
- 238000007405 data analysis Methods 0.000 abstract description 2
- 239000000047 product Substances 0.000 description 84
- 230000002354 daily effect Effects 0.000 description 9
- 239000008157 edible vegetable oil Substances 0.000 description 4
- 235000013601 eggs Nutrition 0.000 description 3
- 238000007619 statistical method Methods 0.000 description 3
- 235000019483 Peanut oil Nutrition 0.000 description 2
- 235000012206 bottled water Nutrition 0.000 description 2
- 239000007795 chemical reaction product Substances 0.000 description 2
- 235000013365 dairy product Nutrition 0.000 description 2
- 235000013399 edible fruits Nutrition 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 235000013305 food Nutrition 0.000 description 2
- 235000008446 instant noodles Nutrition 0.000 description 2
- 235000013372 meat Nutrition 0.000 description 2
- 239000000312 peanut oil Substances 0.000 description 2
- 244000144977 poultry Species 0.000 description 2
- 235000013594 poultry meat Nutrition 0.000 description 2
- 150000003839 salts Chemical class 0.000 description 2
- 235000002639 sodium chloride Nutrition 0.000 description 2
- 235000000346 sugar Nutrition 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 235000008645 Chenopodium bonus henricus Nutrition 0.000 description 1
- 244000138502 Chenopodium bonus henricus Species 0.000 description 1
- 235000013339 cereals Nutrition 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 235000013336 milk Nutrition 0.000 description 1
- 239000008267 milk Substances 0.000 description 1
- 210000004080 milk Anatomy 0.000 description 1
- 239000003921 oil Substances 0.000 description 1
- 235000019198 oils Nutrition 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
- G06Q30/0206—Price or cost determination based on market factors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0283—Price estimation or determination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0611—Request for offers or quotes
Landscapes
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Game Theory and Decision Science (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a statistical calculation method and a statistical calculation system for price indexes of on-line necessities, belongs to the technical field of big data analysis, and aims to solve the technical problem of how to perform statistical calculation on the price indexes of the on-line necessities. The method comprises the following steps: determining at least one online commodity sales platform as a monitoring target based on the online commodity sales platforms; collecting all commodities in a monitoring target, and screening a class and a representative product, wherein the representative product is a commodity representing the average price of the class; periodically monitoring and collecting commodity information of a representative product, wherein the commodity information at least comprises a commodity ID, a commodity name, a commodity price, a commodity sales volume, a class, and province and city counties to which commodities or shops belong; a price index is calculated based on the commodity information of each representative.
Description
Technical Field
The invention relates to the technical field of big data analysis, in particular to a statistical calculation method and a statistical calculation system for price indexes of on-line necessities.
Background
In order to ensure good supply of necessary living goods, the phenomenon of robbery of the necessary living goods often occurs, and all departments in each region need to accurately master the conditions of price, sales volume, inventory and the like of the local necessary living goods, and key civil commodity market price trends of grain, oil, eggs, milk, vegetables, aquatic products and the like are monitored and analyzed through a direct reporting system of on-site price collection and necessary living goods market monitoring platforms. However, with the popularization of online shopping, the proportion of online shopping commodities to the consumption of residents is greater and greater, and the fact that only data of offline commodities are counted only is more and more incapable of representing the actual consumption condition of residents, so that the statistics of sales data of online commodities needs to be integrated. However, the online commodities and the offline commodities are different from each other in terms of selling mode, price distribution, pricing standard and the like, and the statistics of price change of the online commodities is completely different from that of the online commodities, so a set of scientific and reasonable statistics and calculation method of price indexes of the online necessities needs to be designed, and the online commodity and the offline commodity sales fluctuation conditions are integrated to judge the supply guarantee conditions of the actual necessities.
How to carry out statistical calculation on the price indexes of the on-line necessities and count the sales fluctuation situation of the on-line commodity to accurately know the price change situation of all the on-line necessities is a technical problem to be solved.
Disclosure of Invention
The technical task of the invention is to provide a statistical calculation method and a statistical calculation system for price indexes of on-line necessities to solve the problem of how to perform statistical calculation on the price indexes of the on-line necessities.
In a first aspect, the invention provides a statistical calculation method for price index of on-line necessities, comprising the following steps:
determining at least one online commodity sales platform as a monitoring target based on the online commodity sales platforms;
collecting all commodities in a monitoring target, and screening a class and a representative product, wherein the representative product is a commodity representing the average price of the class;
periodically monitoring and collecting commodity information of a representative product, wherein the commodity information at least comprises a commodity ID, a commodity name, a commodity price, a commodity sales volume, a class, and province, city and county to which a commodity or a shop belongs;
a price index is calculated based on the commodity information of each representative.
Preferably, the online goods sales platform includes:
the comprehensive e-commerce platform comprises a Tianmao mall, a Taobao net and a Jingdong mall;
the retail platform comprises Jingdong home, darun fresh and good taste and vegetable washing;
based on the online commodity sales platform, the number of the daily necessities, the coverage categories and the regional breadth are sold as indexes, and a representative online commodity sales platform is selected as a monitoring target.
Preferably, the representative is selected based on the following selection rules:
the sales quantity or amount of the goods is greater than a threshold value;
the price variation trend and the variation degree of the commodities are representative, namely the price variation of the selected commodity is highly correlated with the price variation of the unselected commodity;
the correlation of the properties among the commodities as representative articles is lower than a threshold value, and the correlation of the price variation characteristics is lower than the threshold value;
or selecting the representative product based on the following selection rules:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
or selecting a representative product by the following method:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
and screening the representative products based on commodity prices, and removing the representative products with abnormal prices, wherein the abnormal prices are larger and smaller.
Preferably, when calculating the price index, calculating the comprehensive average price of the whole society in each representative product base period and report period, calculating the corresponding price index, and calculating the price indexes of different cross dimensions of province, city, county and class and the total index of the whole country level by level.
Preferably, the price index is calculated by:
setting a base period, and calculating the average price of each category commodity in each district and county in the base period;
calculating the price index of a certain class and a certain day in a certain county in a certain period by a mode of calculating the ring ratio index of each period by successive multiplication and a regular index, wherein the calculation formula is as follows:
It＝K1×K2×……×Kt
wherein, K1, K2, … … and Kt respectively represent the ring ratio index of each period in the report period;
and calculating the total index by adopting a weighted average method, wherein the calculation formula is as follows:
wherein i represents the individual index of the standard product or the class index of each layer, and W represents the corresponding specific gravity of the consumption expenditure;
calculating the average price of each category of commodities in each district and county in the base period by the following steps:
setting price indexes of all counties in the base period;
calculating the sales of each commodity, wherein the sales is the product of sales and price;
grouping the sales of all the commodities according to the county categories, and calculating the total sales of all the commodities in each group;
the average price of all the items in each group is calculated by dividing the total sales in the group by the total sales. Obtaining the respective average price of all the categories of all the counties, wherein the average price calculation formula is as follows:
in a second aspect, the present invention provides a statistical calculation system for price indices of on-line necessities for statistically calculating the price indices of the on-line necessities by the statistical calculation method for price indices of on-line necessities according to any one of the first aspect, the system comprising:
the system comprises a monitoring target determining module, a monitoring target determining module and a monitoring target determining module, wherein the monitoring target determining module is used for determining at least one online commodity sales platform as a monitoring target based on the online commodity sales platforms;
the representative screening module is used for collecting all commodities in the monitoring target and screening a class and a representative, and the representative is a commodity representing the average price of the class;
the data acquisition module is used for periodically monitoring and acquiring commodity information of a representative product, wherein the commodity information at least comprises a commodity ID, a commodity name, a commodity price, a commodity sales volume, a class, a commodity or a province, a city and a county to which a shop belongs;
and the price index calculation module is used for calculating the price index based on the commodity information of each representative product.
Preferably, the online goods sales platform includes:
the comprehensive e-commerce platform comprises a Tianmao mall, a Taobao net and a Jingdong mall;
the retail platform comprises Jingdong home, darun fresh and good taste and vegetable washing;
the monitoring target determining module is used for selecting a representative online commodity sales platform as a monitoring target based on the online commodity sales platform by taking the quantity of the daily necessities, the coverage categories and the regional extent of sales as indexes.
Preferably, the representative screening module is used for selecting the representative based on the following selection rules:
the sales quantity or amount of the goods is greater than a threshold value;
the price variation trend and the variation degree of the commodities are representative, namely the price variation of the selected commodity is highly correlated with the price variation of the unselected commodity;
the correlation of the properties among the commodities as representative articles is lower than a threshold value, and the correlation of the price variation characteristics is lower than the threshold value;
or selecting the representative product based on the following selection rules:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
or selecting a representative product by the following method:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
and screening the representative products based on the commodity price, and removing the representative products with abnormal price, wherein the abnormal price is larger and smaller.
Preferably, the price index calculation module is used for calculating the comprehensive average price of the whole society in each representative product base period and the report period, calculating corresponding price indexes, and calculating the price indexes of different cross dimensions of province, city, county and class and the total national index layer by layer.
Preferably, the price index calculation module is configured to calculate the price index by:
setting a base period, and calculating the average price of each category commodity in each district and county in the base period;
calculating the price index of a certain class and a certain day in a certain county in a certain period by a mode of calculating the ring ratio index of each period by successive multiplication and a regular index, wherein the calculation formula is as follows:
It＝K1×K2×……×Kt
wherein, K1, K2, … … and Kt respectively represent the ring ratio index of each period in the report period;
and calculating the total index by adopting a weighted average method, wherein the calculation formula is as follows:
wherein i represents the individual index of the standard product or the class index of each layer, and W represents the corresponding specific gravity of the consumption expenditure;
calculating the average price of each category of commodities in each district and county in the base period by the following steps:
setting price indexes of all counties of the base period;
calculating the sales of each commodity, wherein the sales is the product of the sales volume and the price;
grouping the sales of all the commodities according to the county categories, and calculating the total sales of all the commodities in each group;
dividing the total sales in the group by the total sales volume, and calculating the average price of all the commodities in each group to obtain the respective average price of all the categories in all the counties, wherein the average price calculation formula is as follows:
the statistical calculation method and the statistical calculation system for the price index of the on-line necessities for life have the following advantages: through the selection of monitoring targets and representatives and a scientific and reasonable statistical and calculation method, the price index of the on-line essential products can reflect the change of the prices of regional products more truly and accurately, help each region accurately master the real change situation of the on-line prices of various local essential products for different lives, and serve as the supplement of off-line price data, thereby providing data support for the relevant policy establishment and specific work of the price of the local essential products for lives.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed for the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on the drawings without creative efforts.
The invention is further described below with reference to the accompanying drawings.
Fig. 1 is a block diagram illustrating a flow chart of a statistical calculation method of an online daily necessity price index in embodiment 1.
Detailed Description
The present invention is further described below with reference to the accompanying drawings and specific embodiments so that those skilled in the art can better understand the present invention and can implement the present invention, but the embodiments are not intended to limit the present invention, and the embodiments and technical features of the embodiments can be combined with each other without conflict.
The embodiment of the invention provides a statistical calculation method and a statistical calculation system for price indexes of on-line necessities, which are used for solving the technical problem of how to perform statistical calculation on the price indexes of the on-line necessities.
Example 1:
the invention relates to a statistical calculation method of price indexes of on-line necessities, which comprises the following steps:
s100, determining at least one online commodity sales platform as a monitoring target based on the online commodity sales platforms;
s200, collecting all commodities in a monitoring target, and screening a class and a representative product, wherein the representative product is a commodity representing the average price of the class;
s300, periodically monitoring and collecting commodity information of a representative product, wherein the commodity information at least comprises a commodity ID, a commodity name, a commodity price, a commodity sales volume, a class, a commodity or a province, a city and a county to which a shop belongs;
and S400, calculating the price index based on the commodity information of each representative product.
Step S100 determines a monitoring target. The online commodity sales platform mainly focuses on the following platforms, one is a comprehensive e-commerce platform, such as a Tianmao shopping mall, a Taobao net, a Jingdong shopping mall and the like, and the other is a new retail platform, such as a Jingdong home, darunfa delicious food, taocai and the like. And selecting a representative platform with more necessary products for sale and life, wide coverage categories, wide regions and the like for collection. More platforms are incorporated as far as possible, and the commodities with wider coverage in the aspects of regions, commodity categories and the like are ensured to be collected.
The classification of the necessities of life includes 14 first-class major categories of grains, edible oil, meat, poultry, eggs, dairy products, salt, sugar, aquatic products, vegetables, fruits, bottled drinking water, instant noodles, toilet paper and the like.
Step 200 collects all goods in the monitored target and screens the categories and representatives. The purpose of selecting representative products is to select products which can better represent the average price of the products, exclude special products which influence the average price, such as high-end products and the like, for example, in edible oil, representative products such as 5kg peanut oil and the like can be selected, thus high-end or non-product-class integral average price can be excluded, the selection of the representative standard products in the price index of the products necessary for life is based on the classification of the products, and the selection principle is as follows:
(1) The sales amount (amount) is large;
(2) The price variation trend and the variation degree are representative, namely the price variation of the selected standard product is highly related to the price variation of the unselected product;
(3) The selected representative specifications are far apart in nature and have low correlation with price variation characteristics.
The representative specification can be replaced properly every year, but the proportion of the replacement number is limited to ensure the stability of the representative specification.
The other selection mode is that the commodities with higher sales volume in the product category are screened, the commodity with higher sales volume has stronger representativeness and is more commodities purchased by residents, and the price change of the daily necessities can be reflected better. If the sales of the commodities are reversed, the commodity with the highest sales is selected from top to bottom, the sales of the selected commodities account for 60 percent of the total sales,
alternatively, the two representatives are used in combination. After the representative products are screened, the abnormal price is removed, the abnormal price mainly comprises data of larger abnormal price and smaller abnormal price, most hot commodities are flat, the lower-price commodities have more expensive abnormal commodities, the lower-price abnormal commodities mainly have special price sales promotion, the lower-price commodities have fewer abnormal prices, and 10% of the commodities with the largest price and 3% of the commodities with the smallest price can be selected for removal.
Step S300 is data collection, where the product is collected every day according to the selected representative product, and the collected information includes at least a product ID, a product name, a product price, a product sales amount, a product type, a province, a city, a prefecture, and the like to which the product or the shop belongs.
When calculating the price index in step S400, the comprehensive average price of the whole society in each representative product base period and the report period is calculated, the corresponding price index is calculated, and the price indexes of different cross dimensions of province, city, county and class and the total index of the whole country are calculated layer by layer. Specifically, the price index is calculated by the steps of:
s410, setting a base period, and calculating the average price of each commodity in each district and county in the base period;
s420, calculating the price index of a certain class of a certain county in a certain day through the periodic index in a mode of calculating the ring ratio index of each period by multiplying, wherein the calculation formula is as follows:
It＝K1×K2×……×Kt
wherein, K1, K2, … … and Kt respectively represent the ring ratio index of each period in the report period;
s430, calculating the total index by adopting a weighted average method, wherein the calculation formula is as follows:
wherein i represents the individual index of the standard product or the class index of each layer, and W represents the corresponding specific gravity of the expenditure.
Step S410 calculates the average price of each item in each district and county in the base term by:
s411, setting price indexes of all counties in the base period;
s412, calculating the sales of each commodity, wherein the sales is the product of the sales volume and the price;
s413, grouping the sales of all the commodities according to the county categories, and calculating the total sales of all the commodities in each group;
s414, dividing the total sales in the group by the total sales volume, and calculating the average price of all the commodities in each group to obtain the respective average price of all the categories in all the counties, wherein the average price calculation formula is as follows:
taking the price index calculation of each category in county as an example, selecting a base period, setting the price indexes of all counties in the base period as 100, and calculatingThe average price of each commodity in each district and county in the basic period is calculated, the sales volume is used as the weight, the higher the sales volume is, the higher the weight of the commodity is, the calculation method is that the sales volume of each commodity is calculated, the sales volume is the sales volume multiplied by the price, all data are grouped according to the district and county categories, then the total sales volume of all commodities in each group is calculated, the average price of all commodities in the group is the total sales volume in the group divided by the total sales volume, and the calculation formula is as follows:
thus, the average price of all the categories in all the counties is obtained, the daily price index of a certain category in a certain county is calculated by using the fixed base index, and the ring ratio index of each period is multiplied by the fixed base index, and the formula is as follows: it = K1 × K2 × … … × Kt. Wherein: k1, K2, … …, kt represent loop ratio indexes at each stage of the report period, respectively. The total index is calculated by adopting a weighted average method, and the calculation formula is as follows:
in the formula, i represents the individual index of the specification or the class index of each layer; w is the corresponding specific gravity of the expenditure.
The method of the embodiment acquires massive and full data which cannot be acquired by offline collected data by means of a big data acquisition technology and a statistical analysis technology, and calculates the price index of the online resident life necessities based on the full data. Through the selection of monitoring targets and representative products and a scientific and reasonable statistical and calculation method, the price index of the on-line living essential products can reflect the change of the prices of the local area product types more truly and accurately, help each area to accurately master the true change condition of the on-line prices of the local different on-line living essential products, and serve as the supplement of the off-line price data, thereby providing data support for the local policy making and specific work related to the price of the living essential products.
Example 2:
the invention relates to a statistical calculation system for price indexes of on-line necessities for life, which comprises a monitoring target determination module, a representative article screening module, a data acquisition module and a price index calculation module, and the system can statistically calculate the price indexes of the on-line necessities for life by the method disclosed by the embodiment 1.
The monitoring target determining module is used for determining at least one online commodity selling platform as a monitoring target based on the online commodity selling platform.
The online commodity sales platform mainly focuses on the following platforms, one is a comprehensive e-commerce platform, such as a Tianmao shopping mall, a Taobao net, a Jingdong shopping mall and the like, and the other is a new retail platform, such as a Jingdong home, darunfa delicious food, taocai and the like. Based on the online commodity sales platform, the monitoring target determining module selects a representative online commodity sales platform as a monitoring target by taking the quantity of the daily necessities, the coverage categories and the regional extent of sales as indexes.
In specific implementation, a representative platform with more necessary products for sale and life, wide coverage categories and wide areas is selected for collection. More platforms are incorporated as far as possible, and commodities with wider coverage in the aspects of regions, commodity categories and the like are guaranteed to be collected.
And the representative product screening module is used for collecting all commodities in the monitoring target and screening the categories and representative products, wherein the representative products represent the commodities with average prices of the categories.
The classification of the necessities of life includes 14 first-class major categories of grains, edible oil, meat, poultry, eggs, dairy products, salt, sugar, aquatic products, vegetables, fruits, bottled drinking water, instant noodles, toilet paper and the like.
And the representative product screening module is used for collecting all commodities in the monitoring target and screening the categories and representative products. The purpose of selecting the representative products is to select the products which can represent the average price of the product category more, exclude some special products which influence the average price, such as high-end products and the like, from a statistical system, for example, in edible oil, representative products such as peanut oil with 5kg of flowers in Shanghai can be selected, so that the high-end or non-product category overall average price can be excluded, the selection of the representative standard products in the price index of the daily necessary products is based on the product category, and the selection principle is as follows:
(1) The sales amount (amount) is large;
(2) The price change trend and the change degree are representative, namely the price change of the selected standard product is highly related to the price change of the unselected product;
(3) The selected representative specifications are far apart in nature and have low correlation with price variation characteristics.
The representative specification can be replaced properly every year, but the proportion of the replacement number is limited to ensure the stability of the representative specification.
The other selection mode is that the commodities with higher sales volume in the product category are screened, the commodity with higher sales volume has stronger representativeness and is more commodities purchased by residents, and the price change of the daily necessities can be reflected better. If the sales of the commodities are reversed, the commodity with the highest sales is selected from top to bottom, the sales of the selected commodities account for 60 percent of the total sales,
alternatively, the two representatives are used in combination. After the representative products are screened, the abnormal price is removed, the abnormal price mainly comprises data of larger abnormal price and smaller abnormal price, most hot commodities are flat, the lower-price commodities have more expensive abnormal commodities, the lower-price abnormal commodities mainly have special price sales promotion, the lower-price commodities have fewer abnormal prices, and 10% of the commodities with the largest price and 3% of the commodities with the smallest price can be selected for removal.
The data acquisition module is used for periodically monitoring and acquiring commodity information of the representative products, wherein the commodity information at least comprises commodity IDs, commodity names, commodity prices, commodity sales volumes, commodity types, and provinces, cities and counties to which commodities or shops belong.
The data acquisition module of the embodiment is used for acquiring commodities every day according to the selected representative products, and the acquired information at least comprises commodity ID, commodity name, commodity price, commodity sales volume, class, province, city and county to which the commodities or shops belong, and the like.
The price index calculation module is used for calculating the price index based on the commodity information of each representative. When the price index is calculated, the comprehensive average price of the whole society in each representative product base period and the report period is calculated, the corresponding price index is calculated, and the price indexes of different cross dimensions of province, city, county and class and the total national index are calculated layer by layer. In particular, for performing the following operations:
(1) Setting a base period, and calculating the average price of each category commodity in each district and county in the base period;
(2) Calculating the price index of a certain class and a certain day in a certain county in a certain period by a mode of calculating the ring ratio index of each period by successive multiplication and a regular index, wherein the calculation formula is as follows:
It＝K1×K2×……×Kt
wherein, K1, K2, … … and Kt respectively represent the ring ratio index of each period in the report period;
(3) And calculating the total index by adopting a weighted average method, wherein the calculation formula is as follows:
wherein i represents the individual index of the standard product or the class index of each layer, and W represents the corresponding specific gravity of the expenditure.
Wherein, the average price of each commodity of each district and county in the basic period is calculated by the following steps:
(1) Setting price indexes of all counties in the base period;
(2) Calculating the sales of each commodity, wherein the sales is the product of sales and price;
(3) Grouping the sales of all the commodities according to the county categories, and calculating the total sales of all the commodities in each group;
(4) Dividing the total sales in the group by the total sales volume, and calculating the average price of all the commodities in each group to obtain the respective average price of all the categories in all the counties, wherein the average price calculation formula is as follows:
price of each product in countyThe grid index calculation is taken as an example, a base period is selected, all counties and price indexes of the base period are set as 100, the average price of commodities of all categories in all counties of the base period is calculated, the average price is calculated, the sales volume is taken as a weight, the higher the sales volume is, the higher the weight of the commodities is, the sales volume of each commodity is calculated firstly, the sales volume is multiplied by the price, all data are grouped according to the categories of the counties, then the total sales volume of all the commodities in each group is calculated, the average price of all the commodities in the group is the total sales volume in the group divided by the total sales volume, and the calculation formula is as follows:
thus, the average price of all the categories in all the counties is obtained, the daily price index of a certain category in a certain county is calculated by using the fixed base index, and the ring ratio index of each period is multiplied by the fixed base index, and the formula is as follows: it = K1 × K2 × … … × Kt. Wherein: k1, K2, … …, kt represent loop ratio indexes at each stage of the report period, respectively. The total index is calculated by adopting a weighted average method, and the calculation formula is as follows:
in the formula, i represents the individual index of the specification or the class index of each layer; w is the corresponding specific gravity of the expenditure.
While the invention has been shown and described in detail in the drawings and in the preferred embodiments, it is not intended to limit the invention to the embodiments disclosed, and it will be apparent to those skilled in the art that various combinations of the code auditing means in the various embodiments described above may be used to obtain further embodiments of the invention, which are also within the scope of the invention.
Claims (10)
1. A statistical calculation method for price indexes of on-line necessities is characterized by comprising the following steps:
determining at least one online commodity sales platform as a monitoring target based on the online commodity sales platforms;
collecting all commodities in a monitoring target, and screening a class and a representative product, wherein the representative product is a commodity representing the average price of the class;
periodically monitoring and collecting commodity information of a representative product, wherein the commodity information at least comprises a commodity ID, a commodity name, a commodity price, a commodity sales volume, a class, and province, city and county to which a commodity or a shop belongs;
a price index is calculated based on the commodity information of each representative.
2. The statistical calculation method of on-line daily necessity price index according to claim 1, wherein the on-line goods selling platform comprises:
the comprehensive e-commerce platform comprises a Tianmao mall, a Taobao net and a Jingdong mall;
the retail platform comprises Jingdong home, darun fresh and good taste and vegetable washing;
based on the online commodity sales platform, the number of the daily necessities, the coverage categories and the regional breadth are sold as indexes, and a representative online commodity sales platform is selected as a monitoring target.
3. The statistical calculation method of on-line necessities price index according to claim 1, wherein the representative is selected based on the following selection rules:
the sales quantity or amount of the goods is greater than a threshold value;
the price variation trend and the variation degree of the commodities are representative, namely the price variation of the selected commodity is highly correlated with the price variation of the unselected commodity;
the correlation of the properties among the commodities as representative articles is lower than a threshold value, and the correlation of the price variation characteristics is lower than the threshold value;
or selecting the representative product based on the following selection rules:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
or selecting a representative product by the following method:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
and screening the representative products based on the commodity price, and removing the representative products with abnormal price, wherein the abnormal price is larger and smaller.
4. The statistical calculation method of price indexes of on-line necessities for life according to any one of claims 1 to 3, wherein when calculating the price indexes, the comprehensive average price of the whole society for each representative base period and reporting period is calculated, and corresponding price indexes are calculated, and the price indexes of different cross dimensions of province, city, county and category and the total index of the country are calculated layer by layer.
5. The statistical calculation method of on-line necessities-for-life price index according to claim 4, wherein the price index is calculated by:
setting a base period, and calculating the average price of each category commodity in each district and county in the base period;
calculating the price index of a certain class and a certain day in a certain county in a certain period by a mode of calculating the ring ratio index of each period by successive multiplication and a regular index, wherein the calculation formula is as follows:
It＝K1×K2×……×Kt
wherein, K1, K2, … … and Kt respectively represent the ring ratio index of each period in the report period;
and calculating the total index by adopting a weighted average method, wherein the calculation formula is as follows:
wherein i represents the individual index of the standard product or the class index of each layer, and W represents the corresponding specific gravity of the consumption expenditure;
calculating the average price of each category of commodities in each district and county in the base period by the following steps:
setting price indexes of all counties in the base period;
calculating the sales of each commodity, wherein the sales is the product of the sales volume and the price;
grouping the sales of all the commodities according to the county categories, and calculating the total sales of all the commodities in each group;
the average price of all the items in each group is calculated by dividing the total sales in the group by the total sales. Obtaining the respective average price of all the categories of all the counties, wherein the average price calculation formula is as follows:
6. a statistical calculation system of price indices of on-line necessities for statistically calculating the price indices of on-line necessities by the statistical calculation method of price indices of on-line necessities according to any one of claims 1 to 5, the system comprising:
the monitoring target determining module is used for determining at least one online commodity sales platform as a monitoring target based on the online commodity sales platforms;
the representative product screening module is used for collecting all commodities in a monitoring target and screening a class and a representative product, and the representative product is a commodity representing the average price of the class;
the data acquisition module is used for periodically monitoring and acquiring commodity information of a representative product, wherein the commodity information at least comprises a commodity ID, a commodity name, a commodity price, a commodity sales volume, a class, a commodity or a province, a city and a county to which a shop belongs;
and the price index calculation module is used for calculating the price index based on the commodity information of each representative product.
7. The statistical calculation system of on-line daily necessity price index according to claim 6, wherein the on-line goods selling platform comprises:
the comprehensive e-commerce platform comprises a Tianmao mall, a Taobao network and a Jingdong mall;
the retail platform comprises Jingdong home, darun fresh and good taste and vegetable washing;
the monitoring target determining module is used for selecting a representative online commodity sales platform as a monitoring target based on the online commodity sales platform by taking the quantity of the daily necessities, the coverage categories and the regional extent of sales as indexes.
8. The system of claim 6, wherein the representative screening module is configured to select the representative based on the following selection rules:
the sales quantity or amount of the goods is greater than a threshold value;
the price variation trend and the variation degree of the commodities are representative, namely the price variation of the selected commodity is highly correlated with the price variation of the unselected commodity;
the correlation of the properties among the commodities as representative articles is lower than a threshold value, and the correlation of the price variation characteristics is lower than the threshold value;
or selecting the representative product based on the following selection rules:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
or selecting a representative product by the following method:
screening commodities with the sales volume higher than a threshold value in the categories as representative commodities;
and screening the representative products based on the commodity price, and removing the representative products with abnormal price, wherein the abnormal price is larger and smaller.
9. The statistical calculation system for price indexes of on-line necessities for daily life according to claim 6, wherein the price index calculation module is used for calculating the comprehensive average price of the whole society in each representative product base period and report period, calculating corresponding price indexes, and calculating the price indexes of different cross dimensions of province, city, county and class and the total index of the whole country level by level.
10. The statistical calculation system of on-line necessities-price-index according to claim 9, wherein the price-index calculation module is configured to calculate the price index by:
setting a base period, and calculating the average price of each category commodity in each district and county in the base period;
calculating the price index of a certain grade in a certain county and a certain day through a periodic index in a mode of calculating the successive multiplication of the ring ratio indexes in each period, wherein the calculation formula is as follows:
It＝K1×K2×……×Kt
wherein, K1, K2, … … and Kt respectively represent the ring ratio index of each period in the report period;
and calculating the total index by adopting a weighted average method, wherein the calculation formula is as follows:
wherein i represents the individual index of the specification or the class index of each layer, and W represents the corresponding specific gravity of the expenditure;
calculating the average price of each category of commodities in each district and county in the base period by the following steps:
setting price indexes of all counties in the base period;
calculating the sales of each commodity, wherein the sales is the product of the sales volume and the price;
grouping the sales of all the commodities according to the county categories, and calculating the total sales of all the commodities in each group;
the average price of all the items in each group is calculated by dividing the total sales in the group by the total sales. Obtaining the respective average price of all the categories of all the counties, wherein the average price calculation formula is as follows:
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211011756.7A CN115423506A (en) | 2022-08-23 | 2022-08-23 | Statistical calculation method and system for price index of on-line living necessities |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211011756.7A CN115423506A (en) | 2022-08-23 | 2022-08-23 | Statistical calculation method and system for price index of on-line living necessities |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115423506A true CN115423506A (en) | 2022-12-02 |
Family
ID=84197547
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211011756.7A Pending CN115423506A (en) | 2022-08-23 | 2022-08-23 | Statistical calculation method and system for price index of on-line living necessities |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115423506A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103226779A (en) * | 2013-03-26 | 2013-07-31 | 广东林安物流发展有限公司 | Road logistics price index |
| CN105809289A (en) * | 2016-03-11 | 2016-07-27 | 郑州师范学院 | Electronic commerce industry prosperity extent index system and method based on big data |
| CN108681912A (en) * | 2018-03-21 | 2018-10-19 | 南京邮电大学 | The generation method and system of the big exponential model of net purchase user |
| CN108985822A (en) * | 2018-06-25 | 2018-12-11 | 上海为秀互联网科技有限公司 | A kind of used equipment marketing price index generation method |
| CN111275498A (en) * | 2020-02-28 | 2020-06-12 | 山东爱城市网信息技术有限公司 | Method and system for constructing network retail price index of agricultural products |
| CN114662909A (en) * | 2022-03-23 | 2022-06-24 | 江苏省农业农村厅 | Rural land operation right circulation transaction price index calculation system |
-
2022
- 2022-08-23 CN CN202211011756.7A patent/CN115423506A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103226779A (en) * | 2013-03-26 | 2013-07-31 | 广东林安物流发展有限公司 | Road logistics price index |
| CN105809289A (en) * | 2016-03-11 | 2016-07-27 | 郑州师范学院 | Electronic commerce industry prosperity extent index system and method based on big data |
| CN108681912A (en) * | 2018-03-21 | 2018-10-19 | 南京邮电大学 | The generation method and system of the big exponential model of net purchase user |
| CN108985822A (en) * | 2018-06-25 | 2018-12-11 | 上海为秀互联网科技有限公司 | A kind of used equipment marketing price index generation method |
| CN111275498A (en) * | 2020-02-28 | 2020-06-12 | 山东爱城市网信息技术有限公司 | Method and system for constructing network retail price index of agricultural products |
| CN114662909A (en) * | 2022-03-23 | 2022-06-24 | 江苏省农业农村厅 | Rural land operation right circulation transaction price index calculation system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Brussaard et al. | A European food consumption survey method–conclusions and recommendations | |
| Lebersorger et al. | Discussion on the methodology for determining food waste in household waste composition studies | |
| Cummins et al. | Variations in fresh fruit and vegetable quality by store type, urban–rural setting and neighbourhood deprivation in Scotland | |
| Capistrán et al. | Multi-horizon inflation forecasts using disaggregated data | |
| Dreyer et al. | A ranking method for prioritising retail store food waste based on monetary and environmental impacts | |
| Larsson et al. | Location and co-location in retail: a probabilistic approach using geo-coded data for metropolitan retail markets | |
| CN116205338A (en) | Method, device, equipment and medium for predicting dish sales | |
| CN116645141B (en) | Multi-dimensional feature-fused chain store site selection recommendation method | |
| CN115496566A (en) | Regional specialty recommendation method and system based on big data | |
| CN115423506A (en) | Statistical calculation method and system for price index of on-line living necessities | |
| Iijima et al. | Hybrid just-in-time logistics systems and information networks for effective management in perishable food industries | |
| CN113869938A (en) | Intelligent ordering method for Nisshink fresh stores | |
| Pramana et al. | Big data implementation for price statistics in Indonesia: Past, current, and future developments | |
| CN111275498A (en) | Method and system for constructing network retail price index of agricultural products | |
| Leclair et al. | Scanner data: advances in methodology and new challenges for computing consumer price indices | |
| Hou | Automated Pricing and Replenishment Decisions for Vegetable Items | |
| Ali | Distributional impacts of inflation in Ethiopia | |
| JP2002334379A (en) | System and method for evaluating merchandise | |
| CN106355445A (en) | Data pushing method and device | |
| Pohan et al. | Structure-Conduct-Performance Analysis of Skipjack Fish Industry in Banda Aceh City | |
| O’Rourke | Consumer trends in apple sales | |
| CN114897572A (en) | Accurate push system based on give birth to bright product flavor and customer's demand | |
| JP2019016057A (en) | Sales estimation system | |
| Andriani et al. | Sales Display Re-layout Based on Analysis of Item Sets Pattern Using Combination of Complete Linkage Hierarchical Clustering Method and Association-Rule Method with Apriori Algorithm | |
| Susanawati et al. | Supply chain management of red chili based on the food supply chain network in Yogyakarta Indonesia |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20221202 |
|
| RJ01 | Rejection of invention patent application after publication |