CN112507134A

CN112507134A - Method, system, device and storage medium for generating map based on accounting data

Info

Publication number: CN112507134A
Application number: CN202011487673.6A
Authority: CN
Inventors: 卓民; 杨楠
Original assignee: Shenzhen Kaniu Technology Co ltd
Current assignee: Shenzhen Kaniu Technology Co ltd
Priority date: 2020-12-16
Filing date: 2020-12-16
Publication date: 2021-03-16

Abstract

The embodiment of the invention discloses a method, a system, equipment and a storage medium for generating a map based on accounting data. The method comprises the following steps: acquiring billing data, wherein the billing data comprises user information, bill types and remark information; acquiring consumption content corresponding to the remark information according to the remark information; and respectively taking the user information, the bill types and the consumption content as graph nodes to construct a graph based on the billing data. The embodiment of the invention realizes the construction of the map which is convenient for analysis, management and marketing based on the accounting data.

Description

Method, system, device and storage medium for generating map based on accounting data

Technical Field

The embodiment of the invention relates to the Internet technology, in particular to a map generation method, a map generation system, map generation equipment and a storage medium based on accounting data.

Background

With the rapid development of internet technology and electronic technology, more and more humanized functions are provided for current consumers, for example, the accounting function is widely used by the consumers who want to keep balance, and the consumers can review their own consumption, so as to make their own consumption strategies.

Knowledge map (Knowledge Graph) is a series of different graphs displaying Knowledge development process and structure relationship in the book intelligence field, describing Knowledge resources and carriers thereof by using visualization technology, mining, analyzing, constructing, drawing and displaying Knowledge and mutual relation between Knowledge resources and Knowledge carriers.

The booked data disclose the consumption preference and habit of the user, but the booked data are not effectively used, and the current operators can also construct the knowledge graph of the enterprise user for analysis, management, marketing and the like, but the data source of the knowledge graph is few and disorderly, which undoubtedly increases a lot of burden for the operators.

Disclosure of Invention

The embodiment of the invention provides a method, a system, equipment and a storage medium for generating a map based on accounting data, so as to construct the map convenient for analysis, management and marketing based on the accounting data.

To achieve the purpose, the embodiment of the invention provides a map generation method based on billing data, which comprises the following steps:

acquiring billing data, wherein the billing data comprises user information, bill types and remark information;

acquiring consumption content corresponding to the remark information according to the remark information;

and respectively taking the user information, the bill types and the consumption content as graph nodes to construct a graph based on the billing data.

Further, the acquiring the billing data comprises:

acquiring original accounting data;

removing the repeated data in the original accounting data to obtain accounting data.

Further, the acquiring, according to the remark information, the consumption content corresponding to the remark information includes:

dividing words of the remark information, and removing stop words to obtain remark words;

counting the word frequency of the remarked words in all the remarked words;

and taking the remark words with the highest word frequency as the consumption content corresponding to the remark information.

Further, the taking the remark words with the highest word frequency as the consumption content corresponding to the remark information includes:

acquiring the remarked words with the highest word frequency;

and correcting the remarked words with the highest word frequency to obtain the consumption content corresponding to the remarked information.

Further, the step of using the user information, the bill type and the consumption content as graph nodes to construct a graph based on the billing data comprises:

and constructing a graph based on the billing data by taking the user information as a first graph node, the bill type as a second graph node and the consumption content as a third graph node respectively, wherein the first graph node is connected with the third graph node, and the second graph node is connected with the third graph node.

Further, the billing data further comprises a billing amount, and the building of the graph based on the billing data by using the user information, the billing type and the consumption content as graph nodes comprises:

and correspondingly marking the bill amount between a first map node and a third map node in the map.

Further, the building of the graph based on the billing data according to the user information, the bill type and the consumption content comprises:

and generating a user portrait based on the user information according to the atlas.

In one aspect, an embodiment of the present invention further provides a system for generating a graph based on billing data, where the system includes:

the data acquisition module is used for acquiring billing data, and the billing data comprises user information, bill types and remark information;

the content acquisition module is used for acquiring the consumption content corresponding to the remark information according to the remark information;

and the map building module is used for respectively taking the user information, the bill types and the consumption content as map nodes so as to build a map based on the billing data.

On the other hand, an embodiment of the present invention further provides a computer device, where the computer device includes: one or more processors; a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method as provided by any embodiment of the invention.

In yet another aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the method provided in any embodiment of the present invention.

The embodiment of the invention obtains the accounting data, wherein the accounting data comprises user information, bill types and remark information; acquiring consumption content corresponding to the remark information according to the remark information; the user information, the bill types and the consumption content are respectively used as map nodes to construct a map based on the bookkeeping data, so that the problems of few data sources and disorder of knowledge maps are solved, and the effect of constructing the map convenient to analyze, manage and market based on the bookkeeping data is realized.

Drawings

FIG. 1 is a schematic flow chart diagram of a method for generating a profile based on billing data according to an embodiment of the present invention;

FIG. 2 is a schematic flow chart diagram of a method for generating a profile based on billing data according to a second embodiment of the present invention;

FIG. 3 is a schematic diagram of a map provided in the second embodiment of the present invention;

FIG. 4 is a schematic structural diagram of a profiling system based on billing data according to a third embodiment of the present invention;

fig. 5 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are for purposes of illustration and not limitation. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.

Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the steps as a sequential process, many of the steps can be performed in parallel, concurrently or simultaneously. In addition, the order of the steps may be rearranged. A process may be terminated when its operations are completed, but may have additional steps not included in the figure. A process may correspond to a method, a function, a procedure, a subroutine, a subprogram, etc.

Furthermore, the terms "first," "second," and the like may be used herein to describe various orientations, actions, steps, elements, or the like, but the orientations, actions, steps, or elements are not limited by these terms. These terms are only used to distinguish one direction, action, step or element from another direction, action, step or element. For example, a first module may be termed a second module, and, similarly, a second module may be termed a first module, without departing from the scope of the present application. The first module and the second module are both modules, but they are not the same module. The terms "first", "second", etc. are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, features defined as "first", "second", may explicitly or implicitly include one or more of the described features. In the description of the embodiments of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.

Example one

As shown in fig. 1, an embodiment of the present invention provides a method, a system, a device and a storage medium for generating a graph based on billing data, where the method includes:

and S110, acquiring billing data, wherein the billing data comprises user information, bill types and remark information.

In this embodiment, the user may perform billing in the billing platform, and the generated billing data may be stored in the billing platform, so that the billing data generated by one or more users may be obtained from the billing platform, and preferably, the billing data of multiple users may be obtained at one time for analysis, and the multiple users may be key users with high consumption capability. The billing data is shown in table 1 and includes user information, bill types and remark information, and the user needs to select a bill type and fill in corresponding remark information when performing billing so as to record the reasons generated specifically by changing bills.

Watch 1

User information	Bill type	Remark information
			User A	Sport body-building	Playing basketball AA
User A	Sport body-building	Downstairs swimming
			User A	Exercise of sportsBody-building	Personal education reported in gymnasium
User A	Leisure entertainment	Tungjian KTV singing
			User B	Sport body-building	Go to yoga class
User B	Sport body-building	Badminton in gymnasium
			User B	Infant care	Milk powder for children
User C	Sport body-building	Playing basketball
			User C	Sport body-building	Swimming class
User C	Leisure entertainment	Massage device
			User C	Leisure entertainment	Watch movies
User C	Infant care	Teaching for childbirth
			User C	Infant care	Early education book video

And S120, acquiring the consumption content corresponding to the remark information according to the remark information.

S130, the user information, the bill types and the consumption content are respectively used as graph nodes to construct a graph based on the billing data.

In this embodiment, since the remark information is relatively random and has no rule when the user fills in the remark information, the consumption content corresponding to the remark information needs to be acquired according to the remark information. Illustratively, if the remark information filled by the user a is "basketball playing AA", the "basketball playing" is extracted as the consumption content of the bill data corresponding to the remark information, so that the user information, the bill type and the consumption content can be respectively used as map nodes to construct a map of the billing data, and preferably, the map is a knowledge map. The operator can conveniently analyze the map to obtain the consumption preference and other information of the user.

Example two

As shown in fig. 2, a second embodiment of the present invention provides a method for generating an atlas based on accounting data, and the second embodiment of the present invention further explains and explains the first embodiment of the present invention, and the method includes:

and S210, acquiring original accounting data.

S220, removing repeated data in the original accounting data to obtain accounting data, wherein the accounting data comprises user information, bill types and remark information.

In this embodiment, the original billing data is obtained from the billing platform, repeated data may occur in the original billing data due to repeated filling by a user or other errors, and after all the original billing data of the billing platform is obtained, the repeated data in the original billing data needs to be removed to obtain the billing data, so as to construct a more accurate graph.

And S230, segmenting the remark information, and removing stop words to obtain remark words.

S240, counting the word frequency of the remarked words in all the remarked words.

And S250, obtaining the remarked words with the highest word frequency.

And S260, correcting the remark words with the highest word frequency to obtain the consumption content corresponding to the remark information.

In this embodiment, when the consumption content is obtained, the remark information may be subjected to word segmentation, stop words are removed to obtain remark words, then word frequencies of the remark words in all the remark words are counted, and then the remark word with the highest word frequency is used as the consumption content corresponding to the remark information. Illustratively, the remark information filled by the user B is "buy a jar of milk powder for son", perform word segmentation to obtain "give", "son", "buy", "a jar", and "milk powder", remove stop words to obtain "son" and "milk powder", then count the word frequency of "son" and "milk powder" in all remark words, find that "son" only appears for 1 time, and "milk powder" appears for 8 times, so "milk powder" is taken as the consumption content.

Further, because the remark words may also have unclear expressions or express different words with the same meaning, the remark words with the highest word frequency may also be modified, for example, the remark words with the highest word frequency include "basketball playing" and "badminton playing", then both "basketball playing" and "badminton playing" may be modified to "playing", and these modified remark words are used as consumption contents to unify and clearly use the words to improve the observability of the finally constructed atlas, where the modification may be performed by manual modification or training of a neural network model.

S270, the user information is used as a first graph node, the bill type is used as a second graph node, and the consumption content is respectively used as a third graph node to construct a graph based on the billing data, wherein the first graph node is connected with the third graph node, and the second graph node is connected with the third graph node.

S280, correspondingly marking the bill amount between a first map node and a third map node in the map.

In this embodiment, after the user information, the bill type, and the consumption content are obtained, the user information may be finally used as a first graph node, the bill type may be used as a second graph node, and the consumption content may be respectively used as a third graph node to construct a graph based on the billing data, where the first graph node is connected to the third graph node, the second graph node is connected to the third graph node, and the connection of the graph nodes represents an affiliation. Preferably, the billing data further includes a billing amount, and the billing data is shown in table 2, and the billing amount can be correspondingly marked between the first graph node and the third graph node in the graph, so that the operator can perform analysis more conveniently, and finally obtain the graph shown in fig. 3.

Watch two

User information	Bill type	Amount of bill	Remark information
				User A	Sport body-building	100.00	Playing basketball AA
User A	Sport body-building	50.00	Downstairs swimming
				User A	Sport body-building	1250.00	Personal education reported in gymnasium
User A	Leisure entertainment	100.00	Tungjian KTV singing
				User B	Sport body-building	250.00	Go to yoga class
User B	Sport body-building	100.00	Badminton in gymnasium
				User B	Infant care	500.00	Milk powder for children
User C	Sport body-building	50.00	Playing basketball
				User C	Sport body-building	100.00	Swimming class
User C	Leisure entertainment	100.00	Massage device
				User C	Leisure entertainment	200.00	Watch movies
User C	Infant care	1500.00	Teaching for childbirth
				User C	Infant care	2000.00	Early education book video

It should be noted that the first graph node, the second graph node, and the third graph node may be distinguished by different colors in the graph. Further, if the bill type also includes income information, the corresponding bill amount can be represented by a negative number in the map.

And S290, generating a user portrait based on the user information according to the atlas.

In this embodiment, after the atlas is obtained, a user portrait based on user information may be generated according to the atlas. For example, as the bill type of the user A is mostly sports fitness, the user portrait of the user A can be marked as preferring sports fitness, so that advertisements of sports fitness class can be pushed to the user A; because user C carries out antenatal training and early education, can judge that user C will give birth to children recently, the consumption input can increase, consequently can give user C the advertisement of propelling movement class and finance class.

Further, the whole billing data can be analyzed according to the map, for example, when the bill type is sport and fitness, the basketball playing consumption content can be observed to be the most through the map, and therefore the consumption preference of the popular users can be analyzed.

EXAMPLE III

As shown in fig. 4, a third embodiment of the present invention provides a spectrum generation system 100 based on billing data, and the spectrum generation system 100 based on billing data provided in the third embodiment of the present invention can execute the spectrum generation method based on billing data provided in any embodiment of the present invention, and has corresponding functional modules and beneficial effects of the execution method. The billing data based atlas generation system 100 includes a data acquisition module 200, a content acquisition module 300, and an atlas construction module 400.

Specifically, the data obtaining module 200 is configured to obtain billing data, where the billing data includes user information, bill types, and remark information; the content obtaining module 300 is configured to obtain, according to the remark information, consumption content corresponding to the remark information; the graph building module 400 is configured to use the user information, the bill type and the consumption content as graph nodes to build a graph based on the billing data.

In this embodiment, the data obtaining module 200 is specifically configured to obtain original accounting data; removing the repeated data in the original accounting data to obtain accounting data. The content obtaining module 300 is specifically configured to perform word segmentation on the remark information and remove stop words to obtain remark words; counting the word frequency of the remarked words in all the remarked words; and taking the remark words with the highest word frequency as the consumption content corresponding to the remark information. The content obtaining module 300 is further configured to obtain the remarked word with the highest word frequency; and correcting the remarked words with the highest word frequency to obtain the consumption content corresponding to the remarked information. The graph building module 400 is specifically configured to build a graph based on the billing data by using the user information as a first graph node, the bill type as a second graph node, and the consumption content as a third graph node, where the first graph node is connected to the third graph node, and the second graph node is connected to the third graph node. Further, the billing data further includes a bill amount, and the graph building module 400 is further specifically configured to mark the bill amount between the first graph node and the third graph node in the graph correspondingly.

Further, the system 100 for generating a graph based on billing data further comprises a representation generation module 500, wherein the representation generation module 500 is configured to generate a user representation based on the user information according to the graph.

Example four

Fig. 5 is a schematic structural diagram of a computer device 12 according to a fourth embodiment of the present invention. FIG. 5 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 5 is only an example and should not bring any limitations to the functionality or scope of use of embodiments of the present invention.

As shown in FIG. 5, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.

Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, Industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.

Computer device 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by computer device 12 and includes both volatile and nonvolatile media, removable and non-removable media.

The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)30 and/or cache memory 32. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 5, and commonly referred to as a "hard drive"). Although not shown in FIG. 5, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.

A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.

Computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with computer device 12, and/or with any devices (e.g., network card, modem, etc.) that enable computer device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, computer device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via network adapter 20. As shown, network adapter 20 communicates with the other modules of computer device 12 via bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.

The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, implementing the methods provided by the embodiments of the present invention:

EXAMPLE five

The fifth embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the methods provided in all the embodiments of the present invention of the present application:

Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A method for generating a graph based on billing data, comprising:

2. The method of claim 1, wherein obtaining billing data comprises:

acquiring original accounting data;

3. The method according to claim 1, wherein the obtaining of the consumption content corresponding to the remark information according to the remark information comprises:

counting the word frequency of the remarked words in all the remarked words;

4. The method of claim 3, wherein the using the remark words with the highest word frequency as the consumption content corresponding to the remark information comprises:

acquiring the remarked words with the highest word frequency;

5. The method of claim 1, wherein the using the user information, billing type, and consumption content as graph nodes to construct a graph based on the billing data comprises:

6. The method of claim 5, wherein the billing data further comprises a billing amount, and wherein the building of the graph based on the billing data using the user information, the billing type, and the consumption content as graph nodes comprises:

7. The method of claim 1, wherein the building a graph based on the billing data from the user information, billing type, and consumption content comprises:

8. A system for generating a graph based on billing data, comprising:

9. A computer device, comprising:

one or more processors;

a storage device for storing one or more programs,

when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-7.

10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-7.