CN114143480A

CN114143480A - Chart video generation method, device, equipment, storage medium and program

Info

Publication number: CN114143480A
Application number: CN202111506923.0A
Authority: CN
Inventors: 熊顺; 林海涛; 陈帆
Original assignee: Beijing Baidu Netcom Science and Technology Co Ltd
Current assignee: Beijing Baidu Netcom Science and Technology Co Ltd
Priority date: 2021-12-10
Filing date: 2021-12-10
Publication date: 2022-03-04

Abstract

The disclosure provides a chart video generation method, a chart video generation device, equipment, a storage medium and a program, and relates to the field of data processing, in particular to the technical field of video processing and chart processing. The specific implementation scheme is as follows: obtaining a chart type and table data, wherein the table data comprises: a plurality of fields and a plurality of field data corresponding to the plurality of fields; generating a chart background chart according to the chart type and the table data; and drawing the chart elements corresponding to the plurality of field data in the chart background chart in sequence according to the chart type to generate the chart video. Through the process, the table data are converted into the chart video, the drawing process of the chart is displayed in the chart video, the data are displayed in the chart video in an animation mode, and the data display effect is improved.

Description

Chart video generation method, device, equipment, storage medium and program

Technical Field

The present disclosure relates to video processing and graph processing technologies in the field of data processing, and in particular, to a graph video generation method, apparatus, device, storage medium, and program.

Background

In the field of information dissemination, videos can be visually displayed, so that the videos are used as information dissemination carriers in more and more scenes. In some scenarios, it is desirable to present the data in the form of a graph in a video. Charts include, but are not limited to: bar charts, pie charts, line graphs, and the like.

Generally, the data to be displayed needs to be drawn into a chart in advance by using a chart drawing tool. The chart is then embedded in the video in the form of a still picture by the video editing tool for presentation.

However, the above method has a poor data display effect.

Disclosure of Invention

The present disclosure provides a chart video generation method, apparatus, device, storage medium, and program.

According to a first aspect of the present disclosure, there is provided a chart video generation method, including:

obtaining a chart type and table data, wherein the table data comprises: a plurality of fields and a plurality of field data corresponding to the plurality of fields;

generating a chart background chart according to the chart type and the table data;

and drawing the chart elements corresponding to the plurality of field data in the chart background chart in sequence according to the chart type to generate the chart video.

According to a second aspect of the present disclosure, there is provided a chart video generating apparatus including:

an obtaining module, configured to obtain a chart type and table data, where the table data includes: a plurality of fields and a plurality of field data corresponding to the plurality of fields;

the first generation module is used for generating a chart background chart according to the chart type and the table data;

and the second generation module is used for sequentially drawing the chart elements corresponding to the plurality of field data in the chart background chart according to the chart type so as to generate the chart video.

According to a third aspect of the present disclosure, there is provided an electronic device comprising:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of the first aspect.

According to a fourth aspect of the present disclosure, there is provided a non-transitory computer readable storage medium having stored thereon computer instructions for causing the computer to perform the method of the first aspect.

According to a fifth aspect of the present disclosure, there is provided a computer program product comprising: a computer program, stored in a readable storage medium, from which at least one processor of an electronic device can read the computer program, execution of the computer program by the at least one processor causing the electronic device to perform the method of the first aspect.

It should be understood that the statements in this section do not necessarily identify key or critical features of the embodiments of the present disclosure, nor do they limit the scope of the present disclosure. Other features of the present disclosure will become apparent from the following description.

Drawings

The drawings are included to provide a better understanding of the present solution and are not to be construed as limiting the present disclosure. Wherein:

fig. 1 is a schematic diagram of an application scenario provided in an embodiment of the present disclosure;

fig. 2 is a schematic flowchart of a chart video generation method according to an embodiment of the present disclosure;

fig. 3 is a schematic flow chart diagram of another method for generating a chart video according to an embodiment of the present disclosure;

fig. 4 is a schematic flowchart of a method for generating a chart background diagram according to an embodiment of the present disclosure;

FIG. 5 is a schematic view of a visualization interface provided by an embodiment of the present disclosure;

FIG. 6 is a schematic view of another visualization interface provided by embodiments of the present disclosure;

FIG. 7 is a schematic view of yet another visualization interface provided by an embodiment of the present disclosure;

fig. 8 is a schematic structural diagram of a chart video generating apparatus according to an embodiment of the present disclosure;

fig. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.

Detailed Description

Exemplary embodiments of the present disclosure are described below with reference to the accompanying drawings, in which various details of the embodiments of the disclosure are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the present disclosure. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

The present disclosure provides a method, an apparatus, a device, a storage medium, and a program for generating a chart video, which are applied to the technical field of video processing and chart processing in the field of data processing, and can generate a chart video according to table data, and display a drawing process of a chart in the chart video, thereby displaying data in an animation manner, and improving a data display effect.

In order to facilitate understanding of the technical solution of the present disclosure, an application scenario of the embodiment of the present disclosure is first described with reference to fig. 1.

Fig. 1 is a schematic diagram of an application scenario provided in the embodiment of the present disclosure. As shown in fig. 1, the tabular data may be presented in the form of a chart video. The table data refers to data organized in a table form, and the table data is data to be displayed. The graph video is a video segment including a plurality of image frames. Each image frame in the chart video shows the drawing process of the chart. For example, image frame 100, image frame 101, image frame 102, image frame 103, and image frame 104 in the chart video are illustrated in fig. 1. The above 5 image frames show the drawing process of the broken line in the diagram in the form of animation.

It should be understood that the 5 image frames illustrated in fig. 1 are 5 image frames arbitrarily extracted in the graph video, and not all the image frames included in the graph video. Other image frames can exist between two adjacent image frames in the 5 image frames, so that the whole image video shows a continuous drawing process of the chart.

In fig. 1, a broken line diagram is illustrated as an example. The graph type in the generated graph video is not limited in the embodiment of the disclosure, and the graph type may be a line graph, a bar graph, a pie graph, a bar graph, an area graph, a scatter graph, a surface graph, a radar chart, a combination graph, and the like.

In the embodiment of the disclosure, the chart video is generated according to the table data, so that a user can intuitively feel the change and trend of the data along with the chart drawing process in the process of watching the chart video, and the understanding and feeling of the data are enhanced. Therefore, in the embodiment of the disclosure, the data is displayed in the form of the chart video, so that the data display effect can be improved.

The chart video generation method provided by the embodiment can be executed by an electronic device. The electronic device may be a terminal device or a server. In some examples, the user uploads the table data to the terminal device, and the terminal device may generate a chart video according to the table data and display the chart video. In other examples, when the processing capability of the terminal device is low, the form data may also be uploaded to the terminal device by the user and forwarded to the server by the terminal device in an interactive manner with the server; the server generates a chart video according to the table data and returns the chart video to the terminal equipment; and the terminal equipment displays the chart video.

In the embodiment of the disclosure, the form data can be automatically converted into the chart video through the electronic device, and a professional does not need to perform a complicated video editing step, so that the generation efficiency of the chart video is improved. Furthermore, the professional requirements on the user are also reduced.

The technical scheme of the disclosure is explained in detail by combining specific examples. The following embodiments may be combined with each other, and some of the same or similar concepts or processes may not be described in detail in some embodiments.

Fig. 2 is a schematic flowchart of a chart video generation method according to an embodiment of the present disclosure. As shown in fig. 2, the method of the present embodiment includes:

s201: obtaining a chart type and table data, wherein the table data comprises: a plurality of fields and a plurality of field data corresponding to the plurality of fields.

The chart type indicates which chart is adopted to display the data in the chart data, and the chart type can be any one of the following types: line graphs, bar graphs, pie charts, bar graphs, area graphs, scatter graphs, surface graphs, radar maps, combination graphs, and the like.

The table data is data organized in rows and columns. The table data includes a plurality of fields and field data corresponding to the fields. The field data may also be referred to as a field value. Taking the table data in fig. 1 as an example for illustration, the table data includes 4 fields, which are: first quarter, second quarter, third quarter, and fourth quarter. The field data corresponding to the first quarter is 20, the field data corresponding to the second quarter is 25, the field data corresponding to the third quarter is 30, and the field data corresponding to the fourth quarter is 40.

It should be understood that the table illustrated in FIG. 1 is an example of a simpler table. In practical applications, each field in the table data may correspond to a plurality of field data, which respectively indicate field data of different dimensions/series. When a plurality of dimensions/series exist, each dimension/series in the generated diagram corresponds to a broken line.

S202: and generating a chart background chart according to the chart type and the table data.

In this embodiment, the chart is split into two parts, which are: a chart background map, and chart elements drawn on the chart background map. Chart elements are visual representations of field data in the form data. For example, in conjunction with the line graph table shown in fig. 1, an image frame 100 is illustrated as a graph background map, and image frames 101, 102, 103, and 104 are based on the image frame 100, and newly drawn contents (e.g., points and broken lines) are graph elements.

In the present embodiment, elements included in the chart background diagram are referred to as static elements. For example, referring to the image frame 100 in fig. 1, the title (i.e., "production total value"), horizontal axis, vertical axis, legend, etc. in the image frame may all be referred to as a static element. The information presented in the chart background diagram for each static element is referred to as the element information corresponding to that static element. For example, referring to the chart background diagram in fig. 1, the element information corresponding to the horizontal axis includes: first quarter, second quarter, third quarter, and fourth quarter. The element information corresponding to the vertical axis comprises: 0. 10, 20, 30, 40, 50, etc.

In some examples, the chart element corresponding to each field data drawn in the chart background chart may also be referred to as a dynamic element or a foreground element.

It can be understood that the chart type determines the style of the chart background graph, and the style of the chart background graph is different for different chart types. For example, static elements such as title, horizontal axis, vertical axis, legend, etc. are typically included in the chart background map to which the line graph and bar graph correspond. Static elements such as titles, horizontal axes and legends are usually included in the chart background chart corresponding to the pie chart and radar chart, and vertical axis elements are not included. Further, the element information corresponding to each static element in the chart background map typically depends on the table data. Therefore, in the embodiment of the present disclosure, the chart background chart may be generated according to the chart type and the table data. It should be noted that, the generation process of the graph background diagram is not limited in this embodiment, and a possible implementation manner may refer to the detailed description of the embodiment shown in fig. 4.

S203: and drawing the chart elements corresponding to the plurality of field data in the chart background chart in sequence according to the chart type to generate the chart video.

As illustrated in fig. 1, a chart element corresponding to field data "20" is drawn in a chart background diagram (see an image frame 101); then, drawing a chart element corresponding to the field data "25" in the chart background chart (see the image frame 102); then, drawing a chart element corresponding to the field data "30" in the chart background chart (see the image frame 103); finally, a chart element corresponding to the field data "40" is drawn in the chart background chart (see the image frame 104).

It should be understood that the form of the chart element corresponding to each field data drawn in the chart background chart differs according to the chart type, for example, in fig. 1, the chart element corresponding to each field data is a point/broken line for a broken line chart. Aiming at the pie chart, the chart element corresponding to each field of data is in a sector shape; for the histogram, the chart element corresponding to each field data is a rectangle or a column.

The chart video generation method provided by the embodiment comprises the following steps: obtaining a chart type and table data, wherein the table data comprises: a plurality of fields and a plurality of field data corresponding to the plurality of fields; generating a chart background chart according to the chart type and the table data; and drawing the chart elements corresponding to the plurality of field data in the chart background chart in sequence according to the chart type to generate the chart video. Through the process, the table data are converted into the chart video, the drawing process of the chart is displayed in the chart video, the data are displayed in the chart video in an animation mode, and the data display effect is improved.

Fig. 3 is a schematic flowchart of another chart video generation method according to an embodiment of the present disclosure. As shown in fig. 3, the method of the present embodiment includes:

s301: obtaining a chart type and table data, wherein the table data comprises: a plurality of fields and a plurality of field data corresponding to the plurality of fields.

S302: and generating a chart background chart according to the chart type and the table data.

It should be understood that the specific implementation manner of S301 and S302 in this embodiment is similar to that of S201 and S202 in fig. 2, and is not described herein again.

S303: and determining the drawing sequence of the plurality of field data according to the plurality of fields.

In this embodiment, because the chart elements corresponding to each field data are drawn in the form of animation, there is a precedence order in the drawing of the chart elements corresponding to each field data. Therefore, the drawing sequence of the data of each field can be determined according to each field in the table, and then the chart elements corresponding to a plurality of fields are drawn in the chart background chart in sequence according to the chart type and the drawing sequence.

In one possible implementation, it may be determined whether the types of the fields in the form data are sequential types. For example, the type of the fields "first quarter, second quarter, third quarter, fourth quarter" is a timing type. For another example, the types of the fields "month 1, month 2, month 3, month …, and month 12" are also time series types. Also for example, the type of these fields "Monday, Tuesday, Wednesday, … Sunday" is also a chronological type. For another example, the type of the fields "2000, 2005, 2010, 2015, 2020" is also a chronological type. As another example, the fields "Beijing, Shanghai, Tianjin, Xian" are of a non-sequential type. The types of the fields such as "first department, second department, third department" are non-chronological types.

And if the types of the fields are the time sequence types, sequencing the fields according to the time sequence, and determining the drawing sequence of the field data according to the sequence of the sequenced fields. If the types of the fields are non-sequential types, the drawing order of the field data can be determined according to the order of the fields in the table data.

In this embodiment, when the types of the fields are time sequence types, the drawing order of the field data is determined according to the order of the sorted fields, so that the chart elements corresponding to the field data are animation-displayed according to the time sequence, and a user can understand the trend of the data changing with time.

S304: and calling a video recording service, wherein the video recording service is used for recording the drawing process in the chart background picture.

Illustratively, after the electronic device generates the chart background image, the chart background image is displayed in the display screen. The video recording service may be a service interface provided by the electronic device. And starting to record the drawing process in the chart background picture in the display screen by calling the video recording service.

S305: generating an ith chart element according to the chart type and ith field data in the drawing sequence, and drawing the ith chart element in the chart background graph; and i sequentially takes 1, 2, … … and N, wherein N is the number of the plurality of field data.

Illustratively, according to the drawing order of each field data, firstly, a 1 st chart element is generated according to the chart type and the 1 st field data, and the 1 st chart element is drawn in the chart background chart. Then, according to the chart type and the 2 nd field data, a 2 nd chart element is generated, and the 2 nd chart element is drawn in the chart background chart. And repeating the steps until the Nth chart element is generated according to the chart type and the Nth field data, and drawing the Nth chart element in the chart background graph.

In a possible implementation manner, for the ith field data, the chart element corresponding to the field data may be generated as follows:

(1) according to the chart type, the element shape is determined.

(2) Determining attributes of the element shape according to the ith field data, wherein the attributes comprise at least one of the following: size, orientation, position in the chart background.

For example, if the chart type is a broken line chart, the element shape is determined to be a broken line. If the ith field data is 25, determining the starting point of the polyline as the point corresponding to the ith-1 field data, and the end point as the intersection point of the ith field of the horizontal axis and the vertical axis data 25.

If the chart type is a pie chart, the element shape is determined to be a fan shape. The size of the sector and the position of the sector in the background image of the chart can be determined according to the proportion of the ith field data to the sum of the plurality of field data.

If the chart type is a histogram, the element shape is determined to be a rectangle or a column. The height of the rectangle or column may be determined from the ith field data and the lateral axis position of the rectangle or column may be determined from the ith field.

(3) And generating the ith chart element according to the element shape and the attribute of the element shape.

It can be understood that after the shape of the element and the attribute of the shape of the element are determined, the ith chart element can be generated and drawn in the chart background diagram.

S306: and after the Nth chart element is drawn in the chart background chart, determining the video recorded by the video recording service as the chart video.

In this embodiment, since the video recording service is always performing video recording on the drawing process of each chart element, when the drawing of the nth chart element is completed, the video recorded by the video recording service is the chart video.

Further, the recorded chart video can be stored. Alternatively, the chart video may be edited and processed by a video editing tool, or inserted into another video file.

On the basis of any of the above embodiments, the generation process of the chart background chart is described in detail below with reference to a specific embodiment. This embodiment may be implemented as a possible implementation manner of S202 or S302.

Fig. 4 is a schematic flow chart diagram of a method for generating a chart background diagram according to an embodiment of the present disclosure. As shown in fig. 4, the method of this embodiment includes:

s401: at least one static element is determined based on the chart type.

In this embodiment, the static elements refer to elements presented in the chart background diagram, including but not limited to: background, title, horizontal axis, vertical axis, legend, etc. Static elements are different for different chart types. For example, the static elements to which the line graphs and bar graphs correspond typically include a title, a horizontal axis, a vertical axis, a legend, and the like. Static elements corresponding to pie charts, radar charts, and the like typically include headings, horizontal axes, legends, and the like, but not vertical axes.

In one possible implementation, at least one static element of the chart may be determined as follows: obtaining chart configuration information, wherein the chart configuration information comprises at least one of the following information: chart titles, coordinate axis data units, chart background colors, and the like. Illustratively, chart configuration information entered by a user in a visualization interface may be obtained. Further, at least one static element is determined based on the chart type and the chart configuration information. In the implementation mode, the configuration of the chart title, the coordinate axis data unit, the chart background color and the like by the user is supported, so that the chart video meeting the personalized requirements of the user can be generated according to the chart configuration information.

S402: and determining element information corresponding to the at least one static element according to the table data.

The element information corresponding to each static element refers to information presented by the static element in the chart background picture.

In this embodiment, the static elements in the chart background map may include one or more of the following:

(1) a field element. The field elements may also be referred to as horizontal axis elements, and are used to identify elements of multiple fields in a diagram, typically located on the horizontal axis of the diagram.

In a possible implementation manner, for a field element, the element information corresponding to the field element may be determined as follows: obtaining the plurality of fields in the form data; and determining element information corresponding to the field elements according to the fields. In one example, a plurality of fields may be determined as element information corresponding to field elements. For example, taking the broken line chart in fig. 1 as an example, the horizontal axis shows "first quarter, second quarter, third quarter, and fourth quarter" which are the element information corresponding to the field element. In another example, when the number of fields is large, part of the fields determined as the element information corresponding to the field element may be extracted from the fields.

(2) A field interval element. The field interval element, which may also be referred to as a vertical axis element, is used to identify a field interval in the diagram, typically located on the vertical axis of the diagram. It should be understood that some charts may not have field interval elements, e.g., pie charts, radar charts, etc.

In a possible implementation manner, for a field interval element, the following manner may be adopted to determine element information corresponding to the field interval element: acquiring the plurality of field data in the table data; determining the number of field intervals according to the plurality of field data; and determining element information corresponding to the field interval elements according to the plurality of field data and the number of the field intervals. For example, taking fig. 1 as an example, the field data in the table data are: 20. 25, 30, and 40, assuming that the number of the determined field intervals is 5, it can be determined that the element information corresponding to the field interval element includes: "0, 10, 20, 30, 40, 50". That is, "0, 10, 20, 30, 40, 50" shown on the vertical axis in the graph shown in fig. 1 is the element information corresponding to the field section element.

(3) Annotating the element. The annotation element refers to an element in the chart for identification and interpretation. For example, chart titles, coordinate axis data units, legends, and the like. In a possible implementation manner, for an annotation element, element information corresponding to the annotation element may be determined according to the chart configuration information. For example, if the title arranged in the chart arrangement information is "total production value", the "total production value" is displayed as the element information corresponding to the title comment element, that is, at the position of the chart title. If the vertical axis unit arranged in the chart arrangement information is "yen", the "yen" is displayed as element information corresponding to the vertical axis unit annotation element, that is, "yen" in the vertical axis unit position of the chart.

(4) A background element. The background element refers to the background of the chart, or the background called a chart background picture. In a possible implementation manner, for a background element, element information corresponding to the background element may be determined according to the chart configuration information. For example, if the color of the chart background arranged in the chart arrangement information is red, the red is displayed as the element information corresponding to the background element, that is, the background of the chart is red. If the color of the background of the chart configured in the chart configuration information is blue, the blue is used as the element information corresponding to the background element, namely the background of the chart is displayed as the blue. And if the background color of the chart configured in the chart configuration information is the transparent color, the transparent color is used as the element information corresponding to the background element, namely the background color of the chart is displayed as the transparent color.

S403: and generating a chart background chart according to the chart type and the element information corresponding to the at least one static element.

In a possible implementation manner, according to a chart type, a chart template corresponding to the chart type is obtained, where the chart template is used to indicate an arrangement format of element information corresponding to the at least one static element; and drawing element information corresponding to the at least one static element according to the chart template to obtain a chart background picture.

On the basis of any of the above embodiments, the following describes, with reference to a specific example, a chart video generation process provided by the present disclosure.

The chart video generation process provided by the embodiment comprises the following steps:

(1) and acquiring the chart type input by the user in the visual interface.

Fig. 5 is a schematic view of a visualization interface provided in an embodiment of the present disclosure. As shown in FIG. 5, a plurality of chart types are displayed in the visualization interface for selection by the user, wherein the user can select one chart type.

And (2-1) displaying an editable form corresponding to the form type in the visual interface, and determining form data according to the data input by the user in the editable form.

Illustratively, fig. 6 is a schematic view of another visualization interface provided by the embodiment of the present disclosure. As shown in fig. 6, an editable form corresponding to the chart type selected by the user is displayed in the visualization interface, and the user can input fields and field data corresponding to the fields in the editable form. Thus, form data can be obtained according to data input by a user.

And (2-2) acquiring a form file uploaded by a user, and analyzing data in the form file to obtain form data.

In this embodiment, the step 2-2 and the step 2-1 are two ways of obtaining table data, and in practical application, one or two of the ways may be adopted.

Illustratively, with continued reference to FIG. 6, an upload control (i.e., upload form file in FIG. 6) may also be included in the visualization interface shown in FIG. 6. And the user clicks the uploading control to upload the locally stored table file to the system. And analyzing the table file to obtain table data.

Alternatively, after the table data is obtained, the table data may be displayed in the editable table described above. Therefore, a user can view the table data through the visual interface, and if the table data has errors, the table data can be directly modified in the editable table. The operation of the user is convenient.

(3) Obtaining the chart configuration information input by a user in a visual interface. The chart configuration information includes at least one of: chart titles, coordinate axis data units, chart background colors, and the like.

Fig. 7 is a schematic view of another visualization interface provided by the embodiment of the present disclosure. As shown in FIG. 7, a user-selected configurable item corresponding to the chart type may be included in the visualization interface. The user can configure the chart related information according to the needs of the user, for example, configure the chart title, configure the coordinate axis title of the chart, configure the coordinate axis unit of the chart, configure the background color of the chart, and the like.

(4) And generating a chart background chart according to the chart type, the table data and the chart configuration information.

In this embodiment, after the user performs the above configuration, the electronic device may generate the chart background diagram according to the chart type, the table data, and the chart configuration information selected by the user. For a specific process of generating the chart background diagram, reference may be made to the detailed description of the embodiment shown in fig. 4, which is not described herein again.

For example, the visual interfaces shown in fig. 6 and fig. 7 of the present embodiment may be web pages. A preview area for the chart video is also included in the page. For example, the preview area of the chart video may be a canvas (canvas/canvas) control in a webpage. The Canvas control is a label provided by the webpage for showing the drawing effect, and can show the drawing effect in the page. In this way, a chart background map may be generated in the canvas control of the web page.

(5) And calling a video recording service, wherein the video recording service is used for recording a drawing process in the chart background picture.

(6) And drawing the chart elements corresponding to the plurality of field data in the chart background chart in sequence according to the chart type.

It should be understood that, in this embodiment, reference may be made to the detailed description of the foregoing embodiment for a process of drawing a diagram element corresponding to each field data in the diagram background diagram, which is not described herein again.

For example, in the process of drawing each chart element, the drawing process may be displayed in a chart video preview area of the interface shown in fig. 6/7, so that the user may view a chart video in real time, and the user experience is improved.

(7) And when the chart element corresponding to the last field data is drawn, taking the video obtained by the video recording service screen recording as the first chart video.

As one example, a web page provides a video recording interface that can be invoked to record a chart drawing process and save the recorded animation as a webm formatted video file.

(8) And converting the first chart video into a second chart video in a preset format.

In this embodiment, it is considered that the video file in the webm format is generally a video file supported in a web page, and most video editing tools do not support the video format. Therefore, the first chart video can be converted into a video format supported by most video editing tools by performing format conversion. E.g., mov format, MP4 format, etc. For example, the interface shown in fig. 7 includes an export control, and when a user clicks the export control, the first chart video (webm format) may be saved as the second chart video in the preset format.

In this embodiment, referring to the interface shown in fig. 7, the user may set the background color of the chart to be transparent. That is, the present embodiment can generate a chart video with a transparent background, and thus, the generated chart video can be conveniently clipped into other video files.

Since the present embodiment supports generation of a chart video with a transparent background, a video encoding format supporting a transparent channel (i.e., an alpha channel) needs to be adopted when converting the format of the chart video in step 8. Illustratively, the mov format based on the qtrle coding scheme supports a transparent channel, so that the graph video in the webm format can be converted into the graph video in the mov format.

In the embodiment, the user can automatically generate the chart video corresponding to the chart data only by editing or uploading the table data and simply configuring the chart configuration information, so that the data display effect is improved, the generation cost of the chart video is reduced, and the generation efficiency of the chart video is improved. And the chart video with the transparent background is generated, so that the chart video can be conveniently applied to a video editing tool for subsequent processing.

Fig. 8 is a schematic structural diagram of a chart video generating apparatus according to an embodiment of the present disclosure. The means may be in the form of software and/or hardware. As shown in fig. 8, the chart video generating apparatus 800 according to the present embodiment includes: an acquisition module 801, a first generation module 802 and a second generation module 803. Wherein the content of the first and second substances,

an obtaining module 801, configured to obtain a chart type and table data, where the table data includes: a plurality of fields and a plurality of field data corresponding to the plurality of fields;

a first generating module 802, configured to generate a chart background chart according to the chart type and the table data;

a second generating module 803, configured to draw, in sequence, the chart elements corresponding to the plurality of field data in the chart background chart according to the chart type, so as to generate the chart video.

In a possible implementation manner, the second generating module 803 includes:

a first determining unit configured to determine a rendering order of the plurality of field data according to the plurality of fields;

and the first generating unit is used for sequentially drawing the chart elements corresponding to the plurality of field data in the chart background chart according to the chart type and the drawing sequence so as to generate the chart video.

In one possible implementation manner, the first generating unit includes:

the calling subunit is used for calling a video recording service, and the video recording service is used for recording the drawing process in the chart background image;

the drawing subunit is used for generating an ith chart element according to the chart type and the ith field data in the drawing sequence, and drawing the ith chart element in the chart background graph; wherein, the i sequentially takes 1, 2, … … and N, and N is the number of the plurality of field data;

and the generating subunit is used for determining a video obtained by recording the video recording service as the chart video after the Nth chart element is drawn in the chart background chart.

In a possible implementation manner, the rendering subunit is specifically configured to:

determining element shapes according to the chart types;

determining attributes of the element shape from the ith field data, the attributes including at least one of: size, orientation, position in the chart background map;

and generating the ith chart element according to the element shape and the attribute of the element shape.

In one possible implementation, the first generating module 802 includes:

the second determining unit is used for determining at least one static element according to the chart type;

a third determining unit, configured to determine, according to the table data, element information corresponding to the at least one static element;

and the second generating unit is used for generating the chart background chart according to the chart type and the element information corresponding to the at least one static element.

In a possible implementation manner, the second determining unit includes:

the first obtaining subunit is configured to obtain chart configuration information, where the chart configuration information includes at least one of: a chart title, a coordinate axis data unit and a chart background color;

a first determining subunit, configured to determine the at least one static element according to the chart type and the chart configuration information.

In one possible implementation, the at least one static element includes a field element; the third determination unit includes:

a second obtaining subunit, configured to obtain the plurality of fields in the table data;

and the second determining subunit is used for determining the element information corresponding to the field element according to the fields.

In one possible implementation, the at least one static element includes a field interval element; the third determination unit includes:

a third acquiring subunit configured to acquire the plurality of field data in the table data;

a third determining subunit, configured to determine, according to the plurality of field data, the number of field intervals;

and the fourth determining subunit is configured to determine, according to the plurality of field data and the number of field intervals, element information corresponding to the field interval element.

In a possible implementation manner, the second generating unit includes:

a fourth obtaining subunit, configured to obtain, according to the chart type, a chart template corresponding to the chart type, where the chart template is used to indicate an arrangement format of element information corresponding to the at least one static element;

and the drawing subunit is used for drawing the element information corresponding to the at least one static element according to the chart template to obtain the chart background picture.

In a possible implementation manner, the obtaining module 801 includes:

the first acquisition unit is used for acquiring the chart type input by a user in the visual interface;

the display unit is used for displaying an editable table corresponding to the chart type in the visual interface;

a fourth determining unit, configured to determine the form data according to data input by a user in the editable form.

The chart video generation apparatus provided in this embodiment may be configured to execute the chart video generation method provided in any of the above method embodiments, and the implementation principle and the technical effect of the method are similar, which are not described herein again.

In the technical scheme of the disclosure, the collection, storage, use, processing, transmission, provision, disclosure and other processing of the personal information of the related user are all in accordance with the regulations of related laws and regulations and do not violate the good customs of the public order.

The present disclosure also provides an electronic device, a readable storage medium, and a computer program product according to embodiments of the present disclosure.

According to an embodiment of the present disclosure, the present disclosure also provides a computer program product comprising: a computer program, stored in a readable storage medium, from which at least one processor of the electronic device can read the computer program, the at least one processor executing the computer program causing the electronic device to perform the solution provided by any of the embodiments described above.

FIG. 9 illustrates a schematic block diagram of an example electronic device 900 that can be used to implement embodiments of the present disclosure. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the disclosure described and/or claimed herein.

As shown in fig. 9, the apparatus 900 includes a computing unit 901, which can perform various appropriate actions and processes in accordance with a computer program stored in a Read Only Memory (ROM)902 or a computer program loaded from a storage unit 908 into a Random Access Memory (RAM) 903. In the RAM 903, various programs and data required for the operation of the device 900 can also be stored. The calculation unit 901, ROM 902, and RAM 903 are connected to each other via a bus 904. An input/output (I/O) interface 905 is also connected to bus 904.

A number of components in the device 900 are connected to the I/O interface 905, including: an input unit 906 such as a keyboard, a mouse, and the like; an output unit 907 such as various types of displays, speakers, and the like; a storage unit 908 such as a magnetic disk, optical disk, or the like; and a communication unit 909 such as a network card, a modem, a wireless communication transceiver, and the like. The communication unit 909 allows the device 900 to exchange information/data with other devices through a computer network such as the internet and/or various telecommunication networks.

The computing unit 901 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of the computing unit 901 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various dedicated Artificial Intelligence (AI) computing chips, various computing units running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, and so forth. The calculation unit 901 performs the respective methods and processes described above, such as the chart video generation method. For example, in some embodiments, the chart video generation method may be implemented as a computer software program tangibly embodied on a machine-readable medium, such as storage unit 908. In some embodiments, part or all of the computer program may be loaded and/or installed onto device 900 via ROM 902 and/or communications unit 909. When the computer program is loaded into the RAM 903 and executed by the computing unit 901, one or more steps of the chart video generation method described above may be performed. Alternatively, in other embodiments, the computing unit 901 may be configured to perform the graph video generation method by any other suitable means (e.g., by means of firmware).

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, Field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.

Program code for implementing the methods of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on 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.

To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), and the Internet.

The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The Server can be a cloud Server, also called a cloud computing Server or a cloud host, and is a host product in a cloud computing service system, so as to solve the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service ("Virtual Private Server", or simply "VPS"). The server may also be a server of a distributed system, or a server incorporating a blockchain.

It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present disclosure may be executed in parallel, sequentially, or in different orders, as long as the desired results of the technical solutions disclosed in the present disclosure can be achieved, and the present disclosure is not limited herein.

The above detailed description should not be construed as limiting the scope of the disclosure. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present disclosure should be included in the scope of protection of the present disclosure.

Claims

1. A chart video generation method, comprising:

2. The method of claim 1, wherein sequentially drawing chart elements corresponding to the plurality of field data in the chart background chart according to the chart type to generate the chart video comprises:

determining a drawing sequence of the plurality of field data according to the plurality of fields;

and sequentially drawing the chart elements corresponding to the plurality of field data in the chart background chart according to the chart type and the drawing sequence to generate the chart video.

3. The method of claim 2, wherein sequentially rendering the chart elements corresponding to the plurality of field data in the chart background chart according to the chart type and the rendering order to generate the chart video comprises:

calling a video recording service, wherein the video recording service is used for recording a drawing process in the chart background picture;

generating an ith chart element according to the chart type and ith field data in the drawing sequence, and drawing the ith chart element in the chart background graph; wherein, the i sequentially takes 1, 2, … … and N, and N is the number of the plurality of field data;

and after the Nth chart element is drawn in the chart background chart, determining the video recorded by the video recording service as the chart video.

4. The method of claim 3, wherein generating an ith chart element from the chart type and ith field data in the drawing order comprises:

determining element shapes according to the chart types;

5. The method of any of claims 1 to 4, wherein generating a chart context graph from the chart type and the table data comprises:

determining at least one static element according to the chart type;

determining element information corresponding to the at least one static element according to the table data;

and generating the chart background chart according to the chart type and the element information corresponding to the at least one static element.

6. The method of claim 5, wherein determining at least one static element from the chart type comprises:

obtaining chart configuration information, wherein the chart configuration information comprises at least one of the following information: a chart title, a coordinate axis data unit and a chart background color;

and determining the at least one static element according to the chart type and the chart configuration information.

7. The method of claim 5 or 6, wherein the at least one static element comprises a field element; according to the table data, determining element information corresponding to the field element, including:

obtaining the plurality of fields in the form data;

and determining element information corresponding to the field elements according to the fields.

8. The method of claim 5 or 6, wherein the at least one static element comprises a field interval element; according to the table data, determining element information corresponding to the field interval element, including:

acquiring the plurality of field data in the table data;

determining the number of field intervals according to the plurality of field data;

and determining element information corresponding to the field interval elements according to the plurality of field data and the number of the field intervals.

9. The method of any of claims 5 to 8, wherein generating the chart background map according to the chart type and element information corresponding to the at least one static element comprises:

acquiring a chart template corresponding to the chart type according to the chart type, wherein the chart template is used for indicating the arrangement format of element information corresponding to the at least one static element;

and drawing element information corresponding to the at least one static element according to the chart template to obtain the chart background picture.

10. The method of any of claims 1 to 9, wherein obtaining chart type and table data comprises:

acquiring a chart type input by a user in a visual interface;

displaying an editable table corresponding to the chart type in the visual interface;

determining the form data according to the data input by the user in the editable form.

11. A chart video generating apparatus comprising:

12. The apparatus of claim 11, wherein the second generating means comprises:

13. The apparatus of claim 12, wherein the first generating unit comprises:

14. The apparatus of claim 13, wherein the rendering subunit is specifically configured to:

determining element shapes according to the chart types;

15. The apparatus of any of claims 11 to 14, wherein the first generating means comprises:

16. The apparatus of claim 15, wherein the second determining unit comprises:

17. The apparatus of claim 15 or 16, wherein the at least one static element comprises a field element; the third determination unit includes:

18. The apparatus of claim 15 or 16, wherein the at least one static element comprises a field interval element; the third determination unit includes:

19. The apparatus of any of claims 15 to 18, wherein the second generating means comprises:

20. The apparatus of any of claims 11 to 19, wherein the obtaining means comprises:

21. An electronic device, comprising:

at least one processor; and

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1 to 10.

22. A non-transitory computer readable storage medium having stored thereon computer instructions for causing the computer to perform the method of any one of claims 1 to 10.

23. A computer program product comprising a computer program which, when executed by a processor, carries out the steps of the method of any one of claims 1 to 10.