CN112052236A - Second-hand vehicle calculation method based on automobile circulation big data - Google Patents
Second-hand vehicle calculation method based on automobile circulation big data Download PDFInfo
- Publication number
- CN112052236A CN112052236A CN202010675921.3A CN202010675921A CN112052236A CN 112052236 A CN112052236 A CN 112052236A CN 202010675921 A CN202010675921 A CN 202010675921A CN 112052236 A CN112052236 A CN 112052236A
- Authority
- CN
- China
- Prior art keywords
- data
- vehicle
- current month
- automobile
- license plate
- 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 18
- 238000000034 method Methods 0.000 claims description 9
- 230000002159 abnormal effect Effects 0.000 claims description 3
- 230000006399 behavior Effects 0.000 abstract 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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
-
- 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/0623—Item investigation
- G06Q30/0625—Directed, with specific intent or strategy
Abstract
The invention provides a second-hand car calculation method based on automobile circulation big data, which comprises the following steps: s1, collecting newly added production data in the current month; s2, synchronizing the production data in the current month to a development library; s3, processing the production data to generate effective data; s4, importing the valid data in the current month into a second-hand car development library; s5, comparing the current month data with the historical data, judging whether the license plate registered in the current month by the same vehicle code is consistent with the history, and if so, determining that the vehicle is not a used vehicle; and S6, if the license plate in the current month changes, the license plate is a quasi-second-hand car, and further judgment is carried out. According to the second-hand car calculation method based on the automobile circulation big data, the automobile circulation big data are mined, the unique vehicle identification and the unique user identification are used for carrying out mutual matching calculation, the second-hand car is identified, and the second-hand car circulation behaviors are counted.
Description
Technical Field
The invention belongs to the technical field of vehicle transaction, and particularly relates to a second-hand vehicle calculation method based on automobile circulation big data.
Background
At present, the used car trading volume data is derived from the statistics of trading platform orders, the used car trading data cannot be completely counted, and repeated trading data exists among platform merchants, so that the method for acquiring the used car trading volume data in the mode has the problems of incompleteness, inaccuracy, repeated calculation and the like, the development condition of a used car market cannot be integrally reflected, and the healthy development of the used car market is not facilitated.
Disclosure of Invention
In view of the above, the present invention is directed to a second-hand car calculation method based on car circulation big data, so as to solve the problems that the existing method for obtaining second-hand car transaction data is incomplete, inaccurate, and repeatedly calculated, and cannot integrally reflect the development status of the second-hand car market, and is not beneficial to the healthy development of the second-hand car market.
In order to achieve the purpose, the technical scheme of the invention is realized as follows:
a second-hand vehicle calculation method based on automobile circulation big data comprises the following steps:
s1, collecting newly added production data in the current month;
s2, synchronizing the production data in the current month to a development library;
s3, processing the production data to generate effective data;
s4, importing the valid data in the current month into a second-hand car development library;
s5, comparing the current month data with the historical data, judging whether the license plate registered in the current month by the same vehicle code is consistent with the history, and if so, determining that the vehicle is not a used vehicle;
and S6, if the license plate in the current month changes, the license plate is a quasi-second-hand car, and further judgment is carried out.
Further, in step S3, the method for processing the production data is as follows:
and judging the data validity through the ETL, updating the abnormal value, removing data noise and generating valid data.
Further, in step S6, the method for further determining is as follows:
if the license plate in the current month is changed but the user does not change, the license plate is regarded as a non-used vehicle;
if the license plate changes in the current month but the user does not change, the license plate is regarded as a used vehicle, and the data is imported into a used vehicle database.
Further, the vehicle classification data is imported into a second-hand vehicle database and is associated with the second-hand vehicle data through vehicle identification;
and importing the related parameter data of the automobile into a second-hand automobile database, and associating the related parameter data with the second-hand automobile data through the automobile identification to form a second-hand automobile transaction database in the current month.
Compared with the prior art, the second-hand vehicle calculation method based on the automobile circulation big data has the following advantages:
the invention discloses a used car calculation method based on automobile circulation big data, which solves the defects of the existing used car calculation method, develops a method different from the traditional used car transaction amount data statistics.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate an embodiment of the invention and, together with the description, serve to explain the invention and not to limit the invention. In the drawings:
fig. 1 is a flowchart of a second-hand vehicle calculation method based on vehicle circulation big data according to an embodiment of the present invention;
Detailed Description
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict.
In the description of the present invention, it is to be understood that the terms "center", "longitudinal", "lateral", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", and the like, indicate orientations or positional relationships based on those shown in the drawings, and are used only for convenience in describing the present invention and for simplicity in description, and do not indicate or imply that the referenced devices or elements must have a particular orientation, be constructed and operated in a particular orientation, and thus, are not to be construed as limiting the present invention. Furthermore, the terms "first", "second", etc. are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first," "second," etc. may explicitly or implicitly include one or more of that feature. In the description of the present invention, "a plurality" means two or more unless otherwise specified.
In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meaning of the above terms in the present invention can be understood by those of ordinary skill in the art through specific situations.
The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings.
As shown in fig. 1, a second-hand vehicle calculation method based on vehicle circulation big data includes the following steps:
s1, collecting newly added production data in the current month;
s2, synchronizing the production data in the current month to a development library;
s3, processing the production data to generate effective data;
s4, importing the valid data in the current month into a second-hand car development library;
s5, comparing the current month data with the historical data, judging whether the license plate registered in the current month by the same vehicle code is consistent with the history, and if so, determining that the vehicle is not a used vehicle;
and S6, if the license plate in the current month changes, the license plate is a quasi-second-hand car, and further judgment is carried out.
In step S3, the method for processing the production data is as follows:
and judging the data validity through the ETL, updating the abnormal value, removing data noise and generating valid data.
In step S6, the method for further determination is as follows:
if the license plate in the current month is changed but the user does not change, the license plate is regarded as a non-used vehicle;
if the license plate changes in the current month but the user does not change, the license plate is regarded as a used vehicle, and the data is imported into a used vehicle database.
Importing the automobile classification data into a second-hand vehicle database, and associating the automobile classification data with second-hand vehicle data through vehicle identification;
and importing the related parameter data of the automobile into a second-hand automobile database, and associating the related parameter data with the second-hand automobile data through the automobile identification to form a second-hand automobile transaction database in the current month.
The invention will be further explained with reference to the following examples: in the data of month 4, the license plate use condition of the vehicle X in the historical data is counted, if the license plate of month 4 is consistent with the license plate of the historical data, the vehicle is judged to be a non-used vehicle, if the license plate of month 4 is inconsistent with the license plate of the historical data, the vehicle is judged to be a quasi-used vehicle, the next judgment is carried out, if the user of the vehicle X is not changed, the vehicle is judged to be the non-used vehicle, and if the user A of the vehicle X is changed into the user B, the vehicle X is confirmed to be the used vehicle in month 4. And finally, forming complete used vehicle transaction information by combining the unique identifier of the vehicle X with the vehicle classification database and the vehicle parameter database.
By using the technical scheme, the total amount of second-hand vehicles circulated in the market can be determined, and the flow direction of each vehicle is tracked.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (4)
1. A second-hand vehicle calculation method based on automobile circulation big data is characterized by comprising the following steps:
s1, collecting newly added production data in the current month;
s2, synchronizing the production data in the current month to a development library;
s3, processing the production data to generate effective data;
s4, importing the valid data in the current month into a second-hand car development library;
s5, comparing the current month data with the historical data, judging whether the license plate registered in the current month by the same vehicle code is consistent with the history, and if so, determining that the vehicle is not a used vehicle;
and S6, if the license plate in the current month changes, the license plate is a quasi-second-hand car, and further judgment is carried out.
2. The vehicle-circulation-big-data-based used vehicle calculation method according to claim 1, wherein in step S3, the method for processing the production data is as follows:
and judging the data validity through the ETL, updating the abnormal value, removing the data noise and further generating valid data.
3. The used vehicle calculation method based on the vehicle circulation big data according to claim 1, characterized in that: in step S6, the method for further determination is as follows:
if the license plate in the current month is changed but the user does not change, the license plate is regarded as a non-used vehicle;
if the license plate changes in the current month but the user does not change, the license plate is regarded as a used vehicle, and the data is imported into a used vehicle database.
4. The used vehicle calculation method based on the vehicle circulation big data according to claim 3, characterized in that: importing the automobile classification data into a second-hand vehicle database, and associating the automobile classification data with second-hand vehicle data through vehicle identification;
and importing the related parameter data of the automobile into a second-hand automobile database, and associating the related parameter data with the second-hand automobile data through the automobile identification to form a second-hand automobile transaction database in the current month.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010675921.3A CN112052236A (en) | 2020-07-14 | 2020-07-14 | Second-hand vehicle calculation method based on automobile circulation big data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010675921.3A CN112052236A (en) | 2020-07-14 | 2020-07-14 | Second-hand vehicle calculation method based on automobile circulation big data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112052236A true CN112052236A (en) | 2020-12-08 |
Family
ID=73601926
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010675921.3A Pending CN112052236A (en) | 2020-07-14 | 2020-07-14 | Second-hand vehicle calculation method based on automobile circulation big data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112052236A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102135995A (en) * | 2011-03-17 | 2011-07-27 | 新太科技股份有限公司 | Extract transform and load (ETL) data cleaning design method |
| CN106709757A (en) * | 2016-12-08 | 2017-05-24 | 北京五八信息技术有限公司 | Trading information processing method and trading platform |
| CN108475362A (en) * | 2018-03-21 | 2018-08-31 | 深圳市元征软件开发有限公司 | Vehicle appraisal procedure, device and equipment |
| CN108615180A (en) * | 2018-04-25 | 2018-10-02 | 众安信息技术服务有限公司 | Information processing method, device and readable storage medium storing program for executing for vehicle transaction |
| CN109325420A (en) * | 2018-08-27 | 2019-02-12 | 广州烽火众智数字技术有限公司 | A kind of vehicle characteristics search method and system based on big data |
-
2020
- 2020-07-14 CN CN202010675921.3A patent/CN112052236A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102135995A (en) * | 2011-03-17 | 2011-07-27 | 新太科技股份有限公司 | Extract transform and load (ETL) data cleaning design method |
| CN106709757A (en) * | 2016-12-08 | 2017-05-24 | 北京五八信息技术有限公司 | Trading information processing method and trading platform |
| CN108475362A (en) * | 2018-03-21 | 2018-08-31 | 深圳市元征软件开发有限公司 | Vehicle appraisal procedure, device and equipment |
| CN108615180A (en) * | 2018-04-25 | 2018-10-02 | 众安信息技术服务有限公司 | Information processing method, device and readable storage medium storing program for executing for vehicle transaction |
| CN109325420A (en) * | 2018-08-27 | 2019-02-12 | 广州烽火众智数字技术有限公司 | A kind of vehicle characteristics search method and system based on big data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11652609B2 (en) | Systems and methods for total loss handling via blockchain | |
| US20040236696A1 (en) | History information adding program, fraud determining program using history information, and fraud determining system using history information | |
| CN110634021A (en) | Big data based vehicle estimation method, system, device and readable storage medium | |
| US9116964B2 (en) | System, method and computer program product for decoding vehicle identification numbers | |
| US20040225473A1 (en) | Fraud score calculating program, method of calculating fraud score, and fraud score calculating system for credit cards | |
| US11282085B2 (en) | Method and device for vehicle-borne payment | |
| JP4755911B2 (en) | Scoring system and scoring method for calculating fraud score using credit card | |
| CN114997608A (en) | Production efficiency assessment method and system based on industrial chain data analysis | |
| CN108957397A (en) | The localization method and device of crusing robot | |
| CN102072735A (en) | Method and system for calculating mileage quickly | |
| CN110276013A (en) | A kind of recommended method of maintenance technician, device and storage medium | |
| CN112052236A (en) | Second-hand vehicle calculation method based on automobile circulation big data | |
| CN114399059A (en) | Information processing method and information processing apparatus | |
| CN114399127A (en) | Information processing method, information processing apparatus, and information processing system | |
| CN115984002B (en) | Data processing method and device for vehicle transaction management | |
| CN112199370A (en) | BOM (bill of material) accelerated settlement worker method capable of effectively improving settlement efficiency | |
| CN108764931A (en) | A kind of vehicle after-sale service system | |
| CN116703534B (en) | Intelligent management method for data of electronic commerce orders | |
| CN112598041B (en) | Power distribution network cloud platform data verification method based on K-MEANS algorithm | |
| CN117522536B (en) | Book checking method and system based on two-dimension code identification | |
| CN117217937A (en) | Insurance pricing method, device, equipment and medium based on battery use behavior | |
| CN109410062B (en) | Trade amount statistical system based on big data analysis | |
| CN117473376A (en) | Cross-platform and cross-organization driving risk identification method and system | |
| CN116109385A (en) | Financial product pushing method, device, equipment and storage medium | |
| CN117932971A (en) | Stamping process design method and device, electronic equipment and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201208 |