CN113010582A

CN113010582A - Data processing method and device, computer readable medium and electronic equipment

Info

Publication number: CN113010582A
Application number: CN201911330852.6A
Authority: CN
Inventors: 赵恢强
Original assignee: Jingdong Allianz Property Insurance Co ltd
Current assignee: Jingdong Allianz Property Insurance Co ltd
Priority date: 2019-12-20
Filing date: 2019-12-20
Publication date: 2021-06-22

Abstract

The present disclosure provides a data processing method, a data processing apparatus, a computer readable medium, and an electronic device; relates to the technical field of data visualization. The data processing method comprises the following steps: acquiring a data table corresponding to source data; determining mapping information of the data table according to interactive operation of a user so as to obtain visual data corresponding to the data table according to the mapping information; and generating a visual chart of the data table according to the visual data corresponding to the data table. The data processing method in the disclosure can overcome the problem of complex data visualization process to a certain extent, and further improve the data visualization efficiency.

Description

Data processing method and device, computer readable medium and electronic equipment

Technical Field

The present disclosure relates to the field of data visualization technologies, and in particular, to a data processing method, a data processing apparatus, a computer readable medium, and an electronic device.

Background

Data visualization refers to the visual interpretation of data by means of graphics, image processing, computer vision, and user interfaces, and aims to clearly and effectively convey and communicate information by means of graphical means.

At present, the data visualization technology is mainly based on the traditional chart and a data instrument panel, utilizes graphs, image processing, computer vision and a user interface, visually explains data through expression, modeling and display of stereo, surface, attribute and animation, and aims to provide a more vivid and friendly form for instantly presenting business insights hidden behind vastly changed and numerous data. However, this does not mean that data visualization is necessarily tedious to achieve for its functional purpose or extremely complex in order to look gorgeous. However, the data visualization process often requires multiple people to participate, such as icon designers, icon makers, data processors, and the like, and the process is complex and easily loses the balance between form and function, thereby creating a luxurious and unrealistic data visualization form.

It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present disclosure, and thus may include information that does not constitute prior art known to those of ordinary skill in the art.

Disclosure of Invention

The purpose of the present disclosure is to provide a data processing method, a data processing apparatus, a computer readable medium, and an electronic device, so as to overcome the problem of high human cost consumed in the data visualization process to a certain extent, and improve the data visualization efficiency.

Additional features and advantages of the disclosure will be set forth in the detailed description which follows, or in part will be obvious from the description, or may be learned by practice of the disclosure.

According to a first aspect of the present disclosure, there is provided a data visualization method comprising:

acquiring a data table corresponding to source data; determining mapping information of the data table according to interactive operation of a user so as to obtain visual data corresponding to the data table according to the mapping information; and generating a visual chart of the data table according to the visual data corresponding to the data table.

In an exemplary embodiment of the present disclosure, the determining mapping information of the data table according to the interactive operation of the user includes:

and acquiring a target field in the data table and configuration information of the target field through a user interaction page, so as to generate the mapping information through the target field and the configuration information.

In an exemplary embodiment of the present disclosure, the obtaining, through a user interaction page, a target field in the data table and configuration information of the target field to generate the mapping information through the target field and the configuration information includes:

displaying data fields in the data table in the user interaction page; acquiring a target field selected by a user from the data field, and acquiring configuration information of the target field; associating the target field with the configuration information to generate the mapping information.

In an exemplary embodiment of the present disclosure, the associating the target field with the configuration information to generate the mapping information includes:

determining a visual graph corresponding to the target field according to the configuration information; associating the target field with the visualization to generate the mapping information.

In an exemplary embodiment of the present disclosure, the acquiring the visualization data corresponding to the data table according to the mapping information includes:

and acquiring each target field in the data table and a visual graph corresponding to each target field according to the mapping information to obtain the visual data.

In an exemplary embodiment of the present disclosure, the mapping information includes field value scaling and field position information of the data table.

In an exemplary embodiment of the present disclosure, the generating a visualization chart of the data table according to the visualization data corresponding to the data table includes:

and displaying the visual data according to the field value scaling and the field position information to obtain a visual chart corresponding to the data table.

According to a second aspect of the present disclosure, there is provided a data processing apparatus comprising a data acquisition module, a data mapping module, and a data visualization module, wherein:

the data acquisition module is used for acquiring a data table corresponding to the source data;

the data mapping module is used for determining mapping information of the data table according to the interactive operation of a user so as to obtain visual data corresponding to the data table according to the mapping information;

and the data visualization module is used for generating a visualization chart of the data table according to the visualization data corresponding to the data table.

In an exemplary embodiment of the present disclosure, the data mapping module may include a configuration information obtaining unit, configured to obtain a target field in the data table and configuration information of the target field through a user interaction page, so as to generate the mapping information through the target field and the configuration information.

In an exemplary embodiment of the present disclosure, the configuration information acquiring unit may include a page displaying unit, a field information acquiring unit, and an associating unit, wherein:

and the page display unit is used for displaying the data fields in the data table in the user interaction page.

And the field information acquisition unit is used for acquiring a target field selected by a user from the data field and acquiring configuration information of the target field.

And the association unit is used for associating the target field with the configuration information so as to generate the mapping information.

In an exemplary embodiment of the present disclosure, the association unit may include a graphic determination unit and a graphic association unit, wherein:

and the graph determining unit is used for determining the visual graph corresponding to the target field according to the configuration information.

And the graphic association unit is used for associating the target field with the visual graphic so as to generate the mapping information.

In an exemplary embodiment of the disclosure, the data mapping module may be specifically configured to: and acquiring each target field in the data table and a visual graph corresponding to each target field according to the mapping information to obtain the visual data.

In an exemplary embodiment of the present disclosure, the data visualization module may be configured to: and displaying the visual data according to the field value scaling and the field position information to obtain a visual chart corresponding to the data table.

According to a third aspect of the present disclosure, there is provided an electronic device comprising: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the method of any one of the above via execution of the executable instructions.

According to a fourth aspect of the present disclosure, there is provided a computer readable medium having stored thereon a computer program which, when executed by a processor, implements the method of any one of the above.

Exemplary embodiments of the present disclosure may have some or all of the following benefits:

in the data processing method provided by an example embodiment of the present disclosure, on one hand, mapping information from the data table to the visualized data can be determined through interactive operation with a user, so that a problem that a plurality of people need to cooperate in the data visualization process is avoided, and the labor cost can be reduced; meanwhile, the data table can be automatically converted into visual data according to the interaction operation of the user, the intelligence of data visualization can be improved, and the efficiency of data visualization can also be improved. On the other hand, the visual chart can be generated according to the requirements of the user, the personalized requirements of the user can be met, and therefore the user experience is improved.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is to be understood that the drawings in the following description are merely exemplary of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without the exercise of inventive faculty.

FIG. 1 schematically shows a system architecture diagram for implementing a data processing method according to one embodiment of the present disclosure;

FIG. 2 schematically shows a flow diagram of a data processing method according to an embodiment of the present disclosure;

FIG. 3 schematically shows a flow diagram of a data processing method according to another embodiment of the present disclosure;

FIG. 4 schematically shows a flow diagram of a data processing method according to another embodiment of the present disclosure;

FIG. 5 schematically shows a block diagram of a data processing apparatus according to an embodiment of the present disclosure;

FIG. 6 illustrates a schematic structural diagram of a computer system suitable for use in implementing an electronic device of an embodiment of the present disclosure.

Detailed Description

Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a thorough understanding of embodiments of the disclosure. One skilled in the relevant art will recognize, however, that the subject matter of the present disclosure can be practiced without one or more of the specific details, or with other methods, components, devices, steps, and the like. In other instances, well-known technical solutions have not been shown or described in detail to avoid obscuring aspects of the present disclosure.

Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.

The technical solution of the embodiment of the present disclosure is explained in detail below:

first, a system architecture for implementing the data processing method is provided in an exemplary embodiment of the present disclosure. Referring to fig. 1, the system architecture 100 may include

terminal devices

101, 102, 103, a network 104, and a server 105. The network 104 serves as a medium for providing communication links between the

terminal devices

101, 102, 103 and the server 105. Network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.

The user may use the

terminal devices

101, 102, 103 to interact with the server 105 via the network 104 to receive or send request instructions or the like. The

terminal devices

101, 102, 103 may have various communication client applications installed thereon, such as a shopping application, a web browser application, a search application, an instant messaging tool, a mailbox client, social platform software, and the like.

The

terminal devices

101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (for example only) providing support for shopping-like websites browsed by users using the

terminal devices

101, 102, 103. The backend management server may analyze and perform other processing on the received data such as the product information query request, and feed back a processing result (for example, target push information, product information — just an example) to the terminal device.

It should be noted that the data processing method provided by the embodiment of the present disclosure is generally executed by the server 105, and accordingly, the data processing apparatus is generally disposed in the server 105. However, it can be understood by those skilled in the art that the data processing method of the present disclosure may also be executed by the terminal device 101, and accordingly, the data processing apparatus may be provided in the terminal device 101, which is not particularly limited in this embodiment.

Based on the above system architecture, the present exemplary embodiment provides a data processing method. Referring to fig. 2, the data processing method may include steps S210, S220, and S230, in which:

step S210: and acquiring a data table corresponding to the source data.

Step S220: and determining mapping information of the data table according to the interactive operation of the user so as to obtain visual data corresponding to the data table according to the mapping information.

Step S230: and generating a visual chart of the data table according to the visual data corresponding to the data table.

The above steps of the present exemplary embodiment will be described in more detail below.

In step S210, a data table corresponding to the source data is acquired.

In the exemplary embodiment, a data table corresponding to source data can be obtained by connecting to a data port, so that the source data is accessed through the data port; or, the data table corresponding to the source data may be read from a memory or a storage medium. For example, a data table corresponding to the source data may be obtained through a user interface, specifically, each application system installed on the terminal device may be read first, then the read identification information, such as an icon, a name, and the like, of each application system is displayed through the user interface for the user to select, data of the target application system selected by the user may be used as the source data, and then the data table of the target application system stored on the terminal device is obtained, or a server corresponding to the target application system is requested, and the data table stored in the database of the target application system is obtained. In addition, the data table corresponding to the source data may also be obtained in other manners, for example, a file path is predetermined, so that the user downloads the data table corresponding to the source data into the file path, and then obtains the data table corresponding to the source data by reading the file in the file path, which is not limited in this embodiment.

In step S220, mapping information of the data table is determined according to the interaction operation of the user, so as to obtain the visual data corresponding to the data table according to the mapping information.

The interactive operation refers to an operation performed by a user on a graphical user interface, for example, inputting information, clicking operation, and the like, and therefore, this embodiment may further include one or more graphical user interfaces, and the mapping information of the data table is determined by receiving the interactive operation of the user through the graphical user interface. The mapping information may represent a mapping relationship between data and visualization data in a data table, or association information, such as an association between a field or field value in a data table and a size of a graph. Since the data displayed by the graph can be two-dimensional, the rows and columns in the data table can be mapped into the graph, and the relationship between the rows and columns and the abscissa and ordinate in the graph is determined, so as to obtain the mapping information of the data table. Specifically, the mapping information may include information of fields in the data table and a type of the visualized data, for example, the field 1 in the data table a corresponds to information of a bar graph a; identification information or attribute information of the visualization data may also be included, such as an identification code of a circle graph, a storage path, and further, such as a size, a position, etc. of a chart. Optionally, the mapping information may include field value scaling for each field in the data table and field location information. Where the field value scaling refers to a ratio between a size of a graphic and a field value when the field value is displayed as a graphic, for example, when the field value scaling is 5, the graphic display as 5 units may indicate a field value 25. The field value scaling can be determined according to actual requirements, for example, the field value is reduced by 5 times or 10 times, and is increased by 2 times or 10 times. The field position information may include coordinates corresponding to each field, such as an abscissa and an ordinate, or may include a position relationship between fields when displayed, such as when the field a and the field b are displayed adjacent to each other, or other information, such as position identification information, and the like, which is not particularly limited in this embodiment. The visualization data is data for display, and may include a graph, image information, various charts such as a bar chart, a pie chart, and the like, or other data such as a graphical user interface, a three-dimensional graph, and the like, which is not limited in this embodiment.

In this exemplary embodiment, the mapping information of the data table may be determined in various ways, for example, information input by a user may be obtained through an interaction operation of the user, and then the data table and the input information are stored in an associated manner, so as to obtain the mapping information of the data table, and then the visual data corresponding to the data table may be obtained according to the mapping information, for example, for the data table a, a field value scaling ratio of the data table a may be determined through the interaction operation, and then the field values corresponding to the fields in the data table a are scaled according to the scaling ratio, so as to be converted into a graph, where the graph is the visual data. The corresponding input information is b, and a bar graph corresponding to b can be obtained through b, namely, the bar graph corresponding to the data table A is obtained.

In an exemplary embodiment, the target field and the configuration information of the target field in the data table may be obtained through the user interaction page, so that the mapping information is generated through the target field and the configuration information. The target field may refer to a field that needs to be displayed in all fields of the data table, and the field that needs to be displayed may be determined according to a requirement of a user for data visualization, or all fields in the data table may be used as the target field, which is not particularly limited in this embodiment. The configuration information may be used to configure a target field in the data table to convert the target field into visual data. For example, the configuration information may include a plurality of configuration parameters, where the configuration parameters may indicate information of the visualization graph corresponding to the target field, such as a type and a name of the visualization graph, may also indicate a functional relationship between the target fields, coordinate information of the target fields when the visualization is displayed, and the like, or the configuration information may also include other configuration parameters, such as a parameter configuring a graph size of the target fields.

Illustratively, a user interaction page may include a plurality of controls, each control may correspond to a data field, the control clicked by the user may be obtained by detecting each control, and then the data field corresponding to the clicked control is determined as a target field in the data table, then information input by the user is obtained through other controls of the user interaction page, and the information is used as configuration information of the target field to be associated with the target field, so as to obtain mapping information of the data table. As shown in fig. 3, the method may include step S301, step S302, and step S303, specifically:

in step S301, data fields in the data table are displayed in the user interaction page. For example, a plurality of data fields may be included in a data table, and the data fields in different data tables are different, so that all data tables may be displayed in a user interaction page, one of the data tables may be determined through a user operation, and then all data fields in the data table may be displayed. In this embodiment, the data fields may be displayed in other manners, for example, the data fields in all the data tables may be displayed, or the data fields in a specific data table may be displayed.

In step S302, a target field selected by the user from the data fields is acquired, and configuration information for the target field is acquired. Specifically, the user interaction page may display identification information such as names and identification numbers of a plurality of data fields, detect identification information corresponding to user operation, and determine a data field corresponding to the identification information as a target field. For example, a plurality of selection boxes may be displayed in a display area in the user interaction page, each selection box corresponds to a data field, and the user may select a required data field by clicking the selection box in the display area, or select a corresponding data field by inputting a name of the selection box, and then detect the selection box with a selection status of "selected", and obtain all data fields selected by the user as target fields. After the target fields are obtained, all the target fields can be displayed through another display area in the user interaction page, after a user selects one of the target fields, the user can jump to another page, the page can be a pre-written configuration page used for configuring the target fields, and then the configuration information for the target fields input by the user is received through the page.

In an exemplary embodiment, a configuration template may be generated in advance according to a plurality of configuration parameters, and then when a user selects a target field from the data field, a configuration template corresponding to the target field may also be selected, so as to obtain configuration information of the target field through the configuration template.

In step S303, the target field is associated with configuration information to generate mapping information. Illustratively, the target field may be associated with the configuration information by a (key, value) key value pair; alternatively, the identification information of the target field may be associated with the configuration information, so as to obtain the configuration information corresponding to the target field. The mapping information may be obtained by storing each target field and the configuration information as one record, that is, the mapping information includes a plurality of data records, each data record may include configuration information associated with a target field, for example, the mapping information may include (field a, configuration information a), (field b, configuration information b), and so on. In addition, the mapping information may also be generated in other manners, for example, an identification information is generated for each association relationship, so that the mapping information is generated by a triplet of the identification information, the target field, and the configuration information.

In an exemplary embodiment, the method for generating mapping information by associating the target field with the configuration information may further include steps S401 and S402 as shown in fig. 4, where:

in step S401, the visualization graph corresponding to the target field is determined according to the configuration information. The configuration information may include identification information of the visual graphics, and the corresponding visual graphics may be obtained by using the identification information, for example, the configuration information may be a file path, and then the file path may be accessed to obtain the visual graphics stored under the file path. Alternatively, the configuration information may be attribute information of the visual graph, so that a visual graph may be generated according to the configuration information, for example, the type and size of the graph included in the configuration information are obtained, so as to generate a visual graph.

In step S402, the target field is associated with the visualization to generate mapping information. For example, a binary set may be formed by the target field and the identification information of the visual graph, and the binary set is used as mapping information, for example, (field a, 001), where 001 may be an identification code of a graph. Or storing the storage address and the target field of the visual graph as a key value pair to obtain mapping information. After the mapping information is obtained, the mapping information may be stored in a plurality of formats, for example, the mapping information corresponding to different data tables may be stored in different files, for example, the mapping information of the data table E is stored in the file R, the mapping information of the data table F is stored in the file T, or the mapping information corresponding to each data table is stored in the same file, and the mapping information is identified by the identification information of the data table, so as to distinguish the mapping information.

After the mapping information of the data table is obtained, the visual data may be obtained through the mapping information, specifically, each data record included in the mapping information is obtained by reading the mapping information, and each data record may represent a mapping relationship of a field in the data table, so that the visual data corresponding to each field in the data table is obtained according to the mapping relationship, for example, the mapping information may be (field a, 001), and then the visual data 001 corresponding to the field a may be obtained through the data record.

In the embodiment, the configuration information of the fields in the data table can be acquired through the user interaction page, and the graph corresponding to the data table is determined according to the configuration information, so that data visualization is realized, the requirements of different users on data visualization can be met, the user experience can be improved, the skill requirement on the users is low, and the labor cost can be reduced.

In step S230, a visualization chart of the data table is generated according to the visualization data corresponding to the data table.

In this embodiment, the visual data may be a graph, and a plurality of visual data corresponding to the data table may be obtained through the mapping information of the data table, so as to combine the visual data to generate the visual chart. In addition, the graphic type corresponding to the data table, such as a bar graph, a pie graph, etc., may also be determined by the mapping information, and a visualized chart corresponding to the data table may be obtained by combining rectangular bars corresponding to each data record in the data table, taking the bar graph as an example. Or, the visualized data may be a chart template, taking a bar chart as an example, the mapping information may determine a field or a field value corresponding to the abscissa and the ordinate of each rectangular bar in the template, and then generate the chart corresponding to the data table from the bar chart template.

For example, the mapping information may include a plurality of data records, and a corresponding graph may be obtained through each data record, for example, the data records may include a graph a corresponding to the field 1, and a graph B corresponding to the field 2, and then a and B are displayed according to the respective corresponding position information, so as to obtain a complete visual chart. Optionally, the mapping information may include field value scaling ratios and field position information of the data table, a plurality of field values corresponding to each field in the data table may be scaled according to the field value scaling ratios to obtain bar graphs corresponding to each field value, if the field values are different in size, the corresponding bar graphs are also different in size, and then each bar graph is displayed according to the field position information of each field, so as to generate a complete visual chart.

In the embodiment, the mapping information of the data table can be determined more visually and conveniently through the user interaction page, a visual operation process is provided for the requirement of a user for data visualization, and compared with the process of realizing data visualization, the method has the advantages that a designer carries out chart design according to the visual requirement first, and then a data processor carries out graphical interface writing according to icon design, and the flow can be simplified, so that the efficiency of data visualization processing is improved.

Further, in the present exemplary embodiment, a data processing apparatus is also provided, which is configured to execute the data processing method of the present disclosure. The device can be applied to a server or terminal equipment.

Referring to fig. 5, the data processing apparatus 500 may include: a data acquisition module 510, a data mapping module 520, and a data visualization module 530, wherein:

and a data obtaining module 510, configured to obtain a data table corresponding to the source data.

The data mapping module 520 is configured to determine mapping information of the data table according to an interaction operation of a user, so as to obtain visual data corresponding to the data table according to the mapping information.

The data visualization module 530 is configured to generate a visualization chart of the data table according to the visualization data corresponding to the data table.

In an exemplary embodiment of the present disclosure, the data mapping module 520 may include a configuration information obtaining unit, configured to obtain a target field in the data table and configuration information of the target field through a user interaction page, so as to generate the mapping information through the target field and the configuration information.

In an exemplary embodiment of the disclosure, the data mapping module 520 may be specifically configured to: and acquiring each target field in the data table and a visual graph corresponding to each target field according to the mapping information to obtain the visual data.

In an exemplary embodiment of the present disclosure, the data visualization module 530 may be configured to: and displaying the visual data according to the field value scaling and the field position information to obtain a visual chart corresponding to the data table.

For details which are not disclosed in the embodiments of the apparatus of the present disclosure, please refer to the embodiments of the data processing method described above in the present disclosure for the details which are not disclosed in the embodiments of the apparatus of the present disclosure.

It should be noted that the computer system 600 of the electronic device shown in fig. 6 is only an example, and should not bring any limitation to the functions and the scope of the application of the embodiments of the present disclosure.

As shown in fig. 6, the computer system 600 includes a Central Processing Unit (CPU)601 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)602 or a program loaded from a storage section 608 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data necessary for system operation are also stored. The CPU 601, ROM 602, and RAM 603 are connected to each other via a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.

The following components are connected to the I/O interface 605: an input portion 606 including a keyboard, a mouse, and the like; an output portion 607 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 608 including a hard disk and the like; and a communication section 609 including a network interface card such as a LAN card, a modem, or the like. The communication section 609 performs communication processing via a network such as the internet. The driver 610 is also connected to the I/O interface 605 as needed. A removable medium 611 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 610 as necessary, so that a computer program read out therefrom is mounted in the storage section 608 as necessary.

In particular, the processes described below with reference to the flowcharts may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 609, and/or installed from the removable medium 611. The computer program, when executed by a Central Processing Unit (CPU)601, performs various functions defined in the methods and apparatus of the present application.

It should be noted that the computer readable media shown in the present disclosure may be computer readable signal media or computer readable storage media or any combination of the two. 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 of the computer readable storage medium may include, but are not limited to: 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 present disclosure, 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. In contrast, in the present disclosure, 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, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The units described in the embodiments of the present disclosure may be implemented by software, or may be implemented by hardware, and the described units may also be disposed in a processor. Wherein the names of the elements do not in some way constitute a limitation on the elements themselves.

As another aspect, the present application also provides a computer-readable medium, which may be contained in the electronic device described in the above embodiments; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs which, when executed by an electronic device, cause the electronic device to implement the method as described in the embodiments below. For example, the electronic device may implement the steps shown in fig. 1 and 2, and so on.

It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It will be understood that the present disclosure is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A data processing method, comprising:

acquiring a data table corresponding to source data;

determining mapping information of the data table according to interactive operation of a user so as to obtain visual data corresponding to the data table according to the mapping information;

and generating a visual chart of the data table according to the visual data corresponding to the data table.

2. The method of claim 1, wherein determining mapping information for the data table based on user interaction comprises:

3. The method according to claim 2, wherein the obtaining, through a user interaction page, a target field in the data table and configuration information of the target field to generate the mapping information through the target field and the configuration information includes:

displaying data fields in the data table in the user interaction page;

acquiring a target field selected by a user from the data field, and acquiring configuration information of the target field;

associating the target field with the configuration information to generate the mapping information.

4. The method of claim 3, wherein associating the target field with the configuration information to generate the mapping information comprises:

determining a visual graph corresponding to the target field according to the configuration information;

associating the target field with the visualization to generate the mapping information.

5. The method according to claim 1, wherein the obtaining the visual data corresponding to the data table according to the mapping information includes:

6. The method of claim 1, wherein the mapping information comprises field value scaling and field position information of the data table.

7. The method of claim 6, wherein generating the visual chart of the spreadsheet according to the visual data corresponding to the spreadsheet comprises:

8. A data processing apparatus, comprising:

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

10. An electronic device, comprising:

a processor; and

a memory for storing executable instructions of the processor;

wherein the processor is configured to perform the method of any of claims 1-7 via execution of the executable instructions.