CN110532427A - A kind of visualization video generation method and system based on Form data - Google Patents
A kind of visualization video generation method and system based on Form data Download PDFInfo
- Publication number
- CN110532427A CN110532427A CN201910795978.4A CN201910795978A CN110532427A CN 110532427 A CN110532427 A CN 110532427A CN 201910795978 A CN201910795978 A CN 201910795978A CN 110532427 A CN110532427 A CN 110532427A
- Authority
- CN
- China
- Prior art keywords
- data
- template
- video
- displayed
- visualization
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/70—Information retrieval; Database structures therefor; File system structures therefor of video data
- G06F16/71—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/70—Information retrieval; Database structures therefor; File system structures therefor of video data
- G06F16/74—Browsing; Visualisation therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Multimedia (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Software Systems (AREA)
- Processing Or Creating Images (AREA)
Abstract
The present invention discloses a kind of visualization video generation method based on Form data the following steps are included: obtaining data to be displayed, the data to be displayed includes the corresponding data target of several groups and data group, and the data type of corresponding data target is judged according to data group；The video template to match is extracted from preset template library according to judging result；According to data to be displayed and extracted video template synthesis visualization video and export.The present invention can automatically analyze data to be displayed, the video template to match with data to be displayed is extracted from preset template library, to which data to be displayed and selected video template be synthesized, export corresponding visualization video, in whole process, user is designed without analyzing data to be displayed without to visualization scheme, it is skillfully grasped also without to video editing tool, video production efficiency can also be improved while reducing and making visualization video threshold.
Description
Technical field
The present invention relates to data visualization field more particularly to a kind of visualization video generation sides based on Form data
Method and system.
Background technique
With the development of the times, the worker of all trades and professions, such as contents producer, news editor, company clerk, education
Worker etc. can have lively, effectively displaying and unscrambling data demand.Video is as a kind of easily transmitted media shape
Formula, may be conveniently used sharing with exchange, but existing data creating exists to production threshold is high, process is superfluous at visualization video
It is long, reusability is low etc., and disadvantages, concrete reason are as follows:
1, it needs according to data characteristics design/suitable visualization scheme of selection, producer needs to have certain set
Meter ability；
2, need according to visualization scheme make video, producer need skillfully using video editing tool (such as
The tools such as Adobe After Effets) or grasp code development technology (such as using canvas, the technologies such as svg)；
3, existing Video editing software cannot achieve the importing of data, the higher cost switched between multiple technologies stack；
4, do not have versatility, can not efficiently change visualization scheme, once facing new data, or think that change can
Depending on changing display form, need to reenter interminable production process.
Therefore in actual fabrication, designer is generally required, video editing personnel, data analyst cooperate, no
Meets the needs of data creating is shown by ordinary user at visualization video.
Patent CN107925786A " the data visualization video of animation " proposes a kind of editing and cutting by data
It collects according to the scheme for generating animation in specified sequence in pane, but it addresses only data in the prior art and can not be introduced directly into
The problem of, it is still necessary to it is manually designed, edits, and the video of generation can not be modified.
To sum up, it needs to be further improved the prior art.
Summary of the invention
The shortcomings that present invention is directed in the prior art, provide a kind of visualization video generation side based on Form data
Method and system.
In order to solve the above-mentioned technical problem, the present invention is addressed by following technical proposals:
A kind of visualization video generation method based on Form data, comprising the following steps:
Data to be displayed is obtained, the data to be displayed includes the corresponding data target of several groups and data group, according to
Data group judges the data type of corresponding data target；
The video template to match is extracted from preset template library according to judging result；
According to data to be displayed and extracted video template synthesis visualization video and export.
As an embodiment:
The video template includes at least template elements and template configuration item, and the template configuration item includes at least and template
The corresponding graphic configuration data of element, the template elements include at least index graphic element, the index graphic element pair
The graphic configuration data answered includes at least specified type.
As an embodiment, the video template to match is extracted from preset template library according to judging result
Specific steps are as follows:
All data targets are judged that the figure of indicatrix shape element in resulting data type and each video template configures
Data are matched, and as Mj≤Tj, determine corresponding video template as the video template to match, wherein Mj indicates video
Specified type is the index figure number of elements of jth class in template, and Tj indicates that data type is the number of jth class in data to be displayed
According to the quantity of index.
As an embodiment, according to data to be displayed and extracted video template synthesis visualization video and defeated
Specific steps out are as follows:
The template configuration item further includes visual coding rule and video length configuration data, is incited somebody to action according to visual coding rule
Data to be displayed synthesizes visualization video with extracted video template and exports；
The visual coding rule includes the rule that the matched index graphic element of data target is mapped, with
And the rule that data target and video length configuration data are mapped.
As an embodiment, according to data to be displayed and extracted video template synthesis visualization video and defeated
It further include effect set-up procedure after out, specific steps include:
Adjustment request is obtained, template configuration item is adjusted correspondingly according to adjustment request, generates self-defined template simultaneously
It saves；
According to data to be displayed and self-defined template synthesis visualization video and export.
As an embodiment:
The template elements also include at least auxiliary element, and the auxiliary element includes at least title, legend, head, piece
It tail and dubs in background music；
The data type includes numeric type and classification type, each in detection data group when the data type is numeric type
Data generate corresponding data characteristics.
In order to solve the above technical problems, the present invention also proposes that a kind of visualization video based on Form data generates system
System, comprising:
Data acquisition module, for obtaining data to be displayed, the data to be displayed includes the corresponding data of several groups
Index and data group are also used to judge according to data group the data type of corresponding data target；
Template extraction module, for extracting the video template to match from preset template library according to judging result；
Video generation module, for according to data to be displayed and extracted video template synthesis visualization video and defeated
Out.
As an embodiment:
The video template includes at least template elements and template configuration item, and the template configuration item includes at least and template
The corresponding graphic configuration data of element, the template elements include at least index graphic element, the index graphic element pair
The graphic configuration data answered includes at least specified type.
As an embodiment:
Template extraction module is configured as:
All data targets are judged that the figure of indicatrix shape element in resulting data type and each video template configures
Data are matched, and as Mj≤Tj, determine corresponding video template as the video template to match, wherein Mj indicates video
Specified type is the index figure number of elements of jth class in template, and Tj indicates that data type is the number of jth class in data to be displayed
According to the quantity of index.
Video generation module is configured as:
The template configuration item further includes visual coding rule and video length configuration data, is incited somebody to action according to visual coding rule
Data to be displayed synthesizes visualization video with extracted video template and exports；
The visual coding rule includes the rule that the matched index graphic element of data target is mapped, with
And the rule that data target and video length configuration data are mapped.
As an embodiment, further include template adjustment module, the template adjustment module is configured as:
Adjustment request is obtained, template configuration item is adjusted correspondingly according to adjustment request, generates self-defined template simultaneously
It saves；
According to data to be displayed and self-defined template synthesis visualization video and export.
The present invention is due to using above technical scheme, with significant technical effect:
1, the present invention can automatically analyze data to be displayed, extract from preset template library and match with data to be displayed
Video template export corresponding visualization video so that data to be displayed and selected video template be synthesized, it is whole
During a, user is designed, also without to video without analyzing data to be displayed without to visualization scheme
Edit tool is skillfully grasped.
2, design of the present invention to index graphic element and its graphic configuration data keeps video template and data to be displayed logical
It is associated to cross data type, consequently facilitating the screening of subsequent video template and the synthesis of video.
3, the present invention analyzes data without user, can voluntarily filter out suitable to the matched design of video template
For showing that the video template of data to be displayed recommends user, video production efficiency is improved, reducing design visualization scheme
Technical threshold.
4, the present invention can be quickly generated visualization animation effect, not needed numerous by the design to visual coding rule
Trivial analysis and realization process.
5, the present invention supports user to visualize by interactive operation modification, tuning by the design to effect set-up procedure
Scheme and the visual effect of video, animation effect etc., the cost for switching different schemes is low, and can live preview adjustment knot
Fruit.
6, design of the present invention to auxiliary element can enrich video page effect, reinforce expressive force, one-touch to generate vividly
Visualization video.
7, method proposed by the invention shows originally static data in the form of dynamic chart, not only more intuitive,
Clearly show the rule of data, moreover it is possible to show the situation that data change over time.Compared to existing static chart can
Depending on change form, the data of more various dimensions are showed, have stronger expressive force.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention without any creative labor, may be used also for those of ordinary skill in the art
To obtain other drawings based on these drawings.
Fig. 1 is a kind of flow diagram of the visualization video generation method based on Form data of the present invention；
Fig. 2 is data target and index graphic element mapping relations schematic diagram in embodiment 1；
Fig. 3 is the flow diagram that video generation method is visualized in case；
Fig. 4 is data target and index graphic element mapping relations schematic diagram in case；
Fig. 5 is a kind of module connection diagram of the visualization video generating system based on Form data of the present invention.
In figure, 1 it is data acquisition module, 2 is template extraction module, 3 is video generation module, 4 is template adjustment module.
Specific embodiment
The present invention will be described in further detail with reference to the following examples, following embodiment be explanation of the invention and
The invention is not limited to following embodiments.
Embodiment 1, a kind of visualization video generation method based on Form data, as shown in Figure 1, including following step
It is rapid:
S100, data to be displayed being obtained, the data to be displayed includes the corresponding data target of several groups and data group,
The data type of corresponding data target is judged according to data group；
S200, the video template to match is extracted from preset template library according to judging result；
S300, video is visualized according to data to be displayed and the synthesis of extracted video template and is exported.
To sum up, visualization video generation proposed by the present invention can automatically analyze data to be displayed, from preset template library
The video template that middle extraction matches with data to be displayed, so that data to be displayed and selected video template are synthesized,
Export corresponding visualization video, in whole process, user is without analyzing data to be displayed, without to visualization
Scheme is designed, and is skillfully grasped also without to video editing tool.
The step S100 obtains data to be displayed, the data to be displayed include the corresponding data target of several groups and
Data group, judging the data type of corresponding data target according to data group, specific step is as follows:
S110, data to be displayed is obtained:
In the present embodiment, the acquisition methods of data to be displayed are as follows: Form data are obtained from data source, by Form data
Regularization data are converted to, using gained regularization data as data to be displayed.
Note: the formatted datas such as data source excel, csv, tsv, or online table, api etc. may finally be converted to rule
Change the data source of list data.
Data to be displayed is made of m row data, n column data index, with corresponding with all data index in the present embodiment
M row data as data group, hollow data are denoted as null.
Since data to be displayed is obtained by Form data conversion, so there is no need to provide the format of Form data, for appointing
The Form data for type of anticipating are all applicable, and user switches in which can be convenient in a variety of visualization schemes, without paying height
High switching surfaces.
S120, the data to be displayed include the corresponding data target of several groups and data group, are judged according to data group
Specific step is as follows for the data type of corresponding data target:
Each data in ergodic data group, the i.e. corresponding m row data of traversal all data index, when each data
Number can be converted into or when null, then determine the data type of corresponding data target for numeric type, it is on the contrary then be classification
Type.
Note: can also extract data characteristics from data group according to actual needs, using data type, data characteristics as correspond to
The label data of data target.Data characteristics as numeric type data is arranged in the present embodiment includes maximum value and minimum value；
To sum up, visualization video production method proposed by the present invention is without being handled and being divided to artificial Form data
Analysis, the Form data that can be will acquire automatically generate corresponding visualization video.
The step S200 extracts the specific step of the video template to match according to judging result from preset template library
Suddenly are as follows:
S210, building video template, all video templates constitute template library；
The video template includes at least template elements and template configuration item, and the template configuration item includes at least and template
The corresponding graphic configuration data of element, the template elements include at least index graphic element, the index graphic element pair
The graphic configuration data answered includes at least specified type.
The above-mentioned design to index graphic element keeps video template and data to be displayed associated by data type, from
And convenient for the synthesis of the screening of subsequent video template and video.
The template elements further include graphic element, and the graphic element and index graphic element constitute main body chart, main
Body chart includes but is not limited to scatter plot, sector diagram, histogram, line chart, map etc., is wherein schemed based on index graphic element
The indispensable element of table, as shown in graphic element (required) in Fig. 2；Graphic element is chart non-essential element, such as pattern primitive in Fig. 2
Shown in plain (other)；The graphic configuration data of each template elements may also include the data such as color, shape, size, animation effect.
By taking scatter plot as an example, index graphic element is X-axis and Y-axis, and specified type is numeric type, and graphic element is scattered
Each point and X/Y axial coordinate on point diagram.
Template elements further include auxiliary element in the present embodiment, the auxiliary element include at least kit form title,
Legend, head, run-out and is dubbed in background music at annotation text, above-mentioned title and legend and data target phase mapping.
The title and data target phase mapping with the data target of title phase mapping are as time dimension in the present embodiment
The data target of degree.The annotation text is the component that user voluntarily adds according to actual needs, for assisting chart to be counted
It is shown according to analysis.
Note: graphic configuration data and each template elements correspond in template configuration item, thus to the face of each template elements
Color, shape, size are configured, and wherein must include specified type in the corresponding graphic configuration data of index graphic element, from
And match data to be displayed with the specified type of indicatrix shape element in each video template by data type.
Further, each legend includes legend daughter element and display daughter element, the legend daughter element and each data
Index maps correspondingly, and the display daughter element is corresponding with the data group of corresponding data index, that is, legend daughter element is used
In illustrating each data target in theme chart, display daughter element is used for the broadcasting with video, simultaneous display corresponding data index
Data.
The corresponding graphic configuration data of above-mentioned legend includes at least highlighted rule, and highlighted rule is, by the legend phase
The data of mapping and the data characteristics of corresponding data index match, and when successful match, the legend is highlighted；This implementation
Data characteristics is maximum value and/or minimum value in data group in example, therefore, during visualizing video playing, pass through legend
It is highlighted corresponding data index maximum value and/or minimum value, shows corresponding spy while showing dynamic chart to realize
Levy data.
Above-mentioned dub in background music can dub in background music with extraction in music storehouse with what video length configuration data matched from existing, can also basis
User dub in background music selection instruction extraction accordingly dub in background music, shear treatment matches to it with video length configuration data, this be existing skill
Art, and be also the prior art to the design of teaser or tail, therefore no longer describe in detail in the present embodiment.
To sum up, the present invention provides the auxiliary element of modularization abundant, can enrich video page effect, reinforces expressive force,
It is one-touch to generate lively visualization video.
S220, the step for extracting the video template to match from preset template library according to judging result obtained by step S120
It is rapid as follows:
All data targets are judged that the figure of indicatrix shape element in resulting data type and each video template configures
Data are matched, and as Mj≤Tj, determine corresponding video template as the video template to match, wherein Mj indicates video
Specified type is the index figure number of elements of jth class in template, and Tj indicates that data type is the number of jth class in data to be displayed
According to the quantity of index.
In the present embodiment, when the index graphic element of video template meets data type and each data class in data to be displayed
When the requirement of type quantity, it is determined as successful match, that is, as Mj≤Tj, be determined as successful match.
Mj indicates that specified type is the index figure number of elements of jth class in video template；
Tj indicates that data type is the quantity of the data target of jth class in data to be displayed.
1st class data type/specified type index value type (j=1) in the present embodiment, the 2nd class data type/specified type
Refer to classification type (j=2).
According to the figure of indicatrix shape element in the data type of all data targets and each video template in the present embodiment
Configuration data is matched, and is suitable for showing that the video template of former data in actual use can be according to user to filter out
Needs, after filtering out the video template to match, by the video template and data to be displayed synthesis visualization video or right
All video templates are screened in template library, are extracted all video templates to match and are selected for user, defeated according to user
Selected video template and data to be displayed synthesis are visualized video by the stencil-chosen instruction entered.
From the foregoing, it will be observed that the present embodiment screens suitable video template by data type, it is not necessarily to customer analysis number to be presented
It is voluntarily configured based on the analysis results after, improves video formation efficiency.
Step S300 is according to data to be displayed and extracted video template synthesis visualization video and the specific step of output
It is rapid as follows:
The template configuration item further includes visual coding rule and video length configuration data, will be to according to template configuration item
Display data synthesizes visualization video with extracted video template and exports.
Note: being existing according to the technology that data to be displayed is carried out Video Composition with selected video template by template configuration item
Technology, such as adoptable existing FFmpeg are synthesized, and export corresponding visualization video, so there is no need to the phases that describes in detail
The technical staff in pass field can also reproduce easily.
To sum up, method proposed by the invention shows originally static data in the form of dynamic chart, not only more straight
Sight, the rule for clearly showing data, moreover it is possible to show the situation that data change over time.Compared to existing static chart
Visual pattern shows the data of more various dimensions, has stronger expressive force.
Above-mentioned video length configuration data is that the video length of default data or user sets itself according to actual needs is matched
Set data；
The visual coding rule include the rule that is mapped of the matched index graphic element of data target (such as
Shown in Fig. 2) and the rule that is mapped of data target and video length configuration data.
The rule that the above-mentioned matched index graphic element of data target is mapped include each data target according to
Its data type and the one-to-one mapping relations of corresponding index graphic element.
According to the mapping relations of index graphic element and data target, each data of each data group are based on, are drawn corresponding
Chart picture is as video frame.
Since data to be displayed is m row data, the Form data that n column data index is constituted are drawn according to Form data
It makes corresponding chart and belongs to the prior art, therefore do not describe in detail here to it.
The rule that data target is mapped with video length configuration data includes that presentation of video frames rule and video frame are cut
Change rule:
The data target of selection and video length configuration data phase mapping, can select from each data target at random at random herein
Data target is selected, can also select corresponding data target for the index selection instruction inputted according to user.
Presentation of video frames sequence is determined according to presentation of video frames rule using selected data index as time dimension, is pressed simultaneously
Picture speed is determined according to video frame switching law.
Determine that the specific implementation steps are as follows for presentation of video frames sequence:
When data target is numeric type data, then presentation of video frames sequence is according to data each in data group according to preset
Queueing discipline is arranged, and e.g., is sorted from small to large according to the numerical value of data each in data group；
When data target is classification type data, then presentation of video frames sequence is according to data each in data group according to preset
Queueing discipline is ranked up, and e.g., is ranked up according to the sequence of data record each in data group；
Further, the rule that data target and video length configuration data are mapped further includes resolution rules, is used
The data corresponding to data target of the parsing as time dimension:
Example: data target is the date, and such as " 1993-03-11 ", parsing can be arranged in corresponding data according to actual needs at this time
Rule are as follows: " in month in time-- date, user can be ranked up according to the queueing discipline of setting later, such as according to the date from it is small to
It is ranked up greatly.
Determining picture speed, the specific implementation steps are as follows:
According to video length configuration data, divided by the quantity of video frame, (head, are drawn based on each data of data group run-out
Each video frame), available picture speed, wherein indicating that the length of the data target of time dimension is data in corresponding data group
Number.
Above-mentioned template elements and template configuration item can be configured in advance, so that constructing several passes through different visualizations
The video template (scatter plot, sector diagram, histogram, line chart, map etc.) of mode display data, by constructed video template
It is maintained in spare in template library.
To sum up, the present invention is based on each in each data group according to the mapping relations of data to be displayed and index graphic element
Data draw the picture of each video frame, while each data of the data group according to corresponding to the data target as time dimension determine
Presentation of video frames sequence and picture speed, that is, produce visualization video corresponding with data to be displayed, and the present invention passes through rule
Visual coding scheme then is constructed for user automatically, is quickly generated visualization animation effect, do not need cumbersome analysis and was realized
Journey.
Embodiment 2 increases effect method of adjustment on the basis of embodiment 1, specially in step S300 according to be presented
After data and extracted video template synthesis visualization video and output, effect adjustment is carried out, remaining is equal to embodiment 1；
Effect adjustment can be replaced and be adjusted template configuration item by video template and realize, wherein being replaced by video template real
Specific step is as follows for existing effect adjustment:
Replacement request is obtained, extracts and exports from preset template library according to request and all match with data to be displayed
Video template (specifically as described in step S220), so that all video templates to match are recommended user.
Obtain stencil-chosen instruction, video template extracted according to described instruction, according to step S300 by data to be displayed and
Extracted video template synthesis visualization video simultaneously exports.
Realizing effect adjustment by adjusting template configuration item, specific step is as follows:
Adjustment request is obtained, template configuration item is adjusted correspondingly according to adjustment request, generates self-defined template simultaneously
It saves；
According to data to be displayed and self-defined template synthesis visualization video and export.
Note: when being adjusted repeatedly based on same video template, it can be arranged according to actual needs and save what adjustment each time obtained
Self-defined template, or the self-defined template saved is updated.
Suitable content includes but is not limited to:
1., to color (being such as adjusted to the cylindricality color of bar chart), the shape of the graphic configuration datas of template elements
Shape (shape of such as corresponding broken line data point of doubling line diagram different data index is adjusted), size are (such as to theme chart
Size is adjusted in picture) etc. data be adjusted；
2., the mapping relations of index graphic element, title, legend and data target are adjusted (as each annual rainfall
Visualization video generated, title and time phase mapping are measured, mapping relations can be adjusted to title at this time and reflected with rainfall
It penetrates)；
It infuses, the quantity of the data target in data to be displayed exceeds the quantity of corresponding index graphic element, can be according to reality
It needs to adjust in the data target of index graphic element mapping, if data to be displayed is the per term year language, number, outer achievement of certain student
(3 numeric type indexs), when generating video using the corresponding video template of above-mentioned column diagram, Chinese Achievement Test and corresponding index figure
Element phase mapping (default index graphic element and first data target phase mapping), can according to actual needs close mapping at this time
System adjusts mathematics achievement and corresponding index graphic element phase mapping.
3., the data target as time dimension is adjusted (such as the visualization video generated for each annual rainfall,
It can be adjusted to using rainfall as time dimension using the time as time dimension)；
4., video length configuration data is adjusted and (extends or shorten video length according to the actual situation)；
5., ordering rule is adjusted and (sorts from small to large from data and be adjusted to sort from large to small)；
6., to head, run-out, dubbing in background music is adjusted.
To sum up, the present embodiment interactive modifies current video bandwagon effect, including replacement visual template, modifies template
Middle visual coding scheme, the components bandwagon effects such as optimization title, legend, head, run-out, and change are dubbed in background music, and will be last
Adjustment result be saved in template library, convenient for next time use；With it is existing remake new video compared with, the present invention is only needed to view
The method of frequency template adjustment can effectively improve video production efficiency.
Case generates visualization video according to the method for embodiment 2 using the every annual rainfall in city as data to be displayed:
As shown in figure 3, Form data are converted to regularization data, data to be displayed are obtained, wait open up by input data source
Registration is according to (sample data is imaginary) as shown in table 1:
Table 1
| Time | Rainfall |
| 2015 | 1116 |
| 2016 | 1113 |
| 2017 | 1134 |
As shown in Table 1, which contains 1 classification type index (time) and 1 numeric type index (precipitation),
The data characteristics (maximum value and minimum value) of rainfall product data index is extracted, and is mentioned from preset template library according to step S200
Take the video template to match；
The index graphic element as necessary to scatter plot is X-axis and Y-axis, and its specified type is numeric type, therefore
It fails to match for data to be displayed video template corresponding with scatter plot, and (the index graphic element of specified numeric type refers to beyond numeric type
Mark).
Index graphic element necessary to histogram template is all X-axis and Y-axis, and the finger of the corresponding index graphic element of X-axis
Determining type is classification type, and the specified type of the corresponding index graphic element of Y-axis is numeric type, therefore data to be displayed and histogram pair
The video template successful match answered is extracted the video template and is synthesized according to step S300.
Video template includes template elements (head run-out, are dubbed in background music, title, legend and theme chart) and template configuration
, data to be displayed and video template are inputted into existing Video Composition engine, such as FFmpeg, at this time Video Composition engine according to
Template configuration item synthesizes each template elements, data to be displayed and audio (dubbing in background music), exports corresponding visualization video.
As shown in figure 4, the X-axis phase mapping in time and main body chart (histogram), rainfall sets each other off with Y-axis in present case
It penetrates；
When selecting the time as time dimension, time data are parsed according to resolution rules, after parsing
Data are according to preset ordering rule, such as from small to large, draw picture of the histogram of time and rainfall as each video frame,
And animation transition is carried out by interpolating function between video frame adjacent video frames and (such as uses Visual Component Library D3.js's
Interpolating function), picture speed is calculated according to the quantity (in conjunction with head and run-out) of preset video length and video frame and is obtained.
Gained visualization video is when playing out, the entitled time, theme chart X-axis show time, Y-axis display drop
Rainfall, legend are rainfall.
With the broadcasting of video, the corresponding histogram of every annual rainfall is successively shown, while current draw is shown at legend
Rainfall corresponding data in face are highlighted when rainfall is maximum/minimum.
User interacts formula adjustment according to the video of output:
1., replacement template: user inputs replacement request, extracts from preset template library according to request at this time and exports institute
There is the video template to match with data to be displayed, such as by the corresponding video template of histogram and the corresponding video template of line chart
Recommend user；User's input template selection instruction, then according to described instruction extract corresponding video template according to step S300 into
Row synthesis.
2., adjustment template configuration item:
User inputs adjustment request, is adjusted correspondingly at this time according to adjustment request to template configuration item, and will adjustment
Video template afterwards is saved as self-defined template into template library；
Such as it is adjusted to using rainfall as time dimension, rainfall and video length configuration data phase mapping, base at this time
The histogram of time and rainfall is successively drawn as each according to preset ordering rule (as from small to large) in rainfall product data
The picture of video frame.
With the broadcasting of video, rainfall corresponding histogram from small to large is successively shown, while showing and working as at legend
The corresponding data of preceding picture rainfall, are highlighted when rainfall is maximum/minimum.
Embodiment 3, a kind of visualization video generating system based on Form data, as shown in Figure 5, comprising: data obtain
Modulus block 1, template extraction module 2, video generation module 3 and template adjustment module 4；
Data acquisition module 1, for obtaining data to be displayed, the data to be displayed includes the corresponding data of several groups
Index and data group are also used to judge according to data group the data type of corresponding data target；
Template extraction module 2, for extracting the video template to match from preset template library according to judging result；
Video generation module 3, for according to data to be displayed and extracted video template synthesis visualization video and defeated
Out.
Template adjustment module 4, for carrying out effect adjusting to the visualization video of output.
The video template includes at least template elements and template configuration item, and the template configuration item includes at least and template
The corresponding graphic configuration data of element, the template elements include at least index graphic element, the index graphic element pair
The graphic configuration data answered includes at least specified type.
Template extraction module 2 is configured as:
All data targets are judged that the figure of indicatrix shape element in resulting data type and each video template configures
Data are matched, and as Mj≤Tj, determine corresponding video template as the video template to match, wherein Mj indicates video
Specified type is the index figure number of elements of jth class in template, and Tj indicates that data type is the number of jth class in data to be displayed
According to the quantity of index.
Video generation module 3 is configured as:
The template configuration item further includes visual coding rule and video length configuration data, is incited somebody to action according to visual coding rule
Data to be displayed synthesizes visualization video with extracted video template and exports；
The visual coding rule includes the rule that the matched index graphic element of data target is mapped, with
And the rule that data target and video length configuration data are mapped.
The template adjustment module 4 is configured as:
Adjustment request is obtained, template configuration item is adjusted correspondingly according to adjustment request, generates self-defined template simultaneously
It saves；
According to data to be displayed and self-defined template synthesis visualization video and export.
For device embodiment, since it is basically similar to the method embodiment, related so being described relatively simple
Place illustrates referring to the part of embodiment of the method.
All the embodiments in this specification are described in a progressive manner, the highlights of each of the examples are with
The difference of other embodiments, the same or similar parts between the embodiments can be referred to each other.
It should be understood by those skilled in the art that, the embodiment of the present invention can provide as method, apparatus or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the present invention
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the present invention, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The present invention be referring to according to the method for the present invention, the flow chart of terminal device (system) and computer program product
And/or block diagram describes.It should be understood that each process in flowchart and/or the block diagram can be realized by computer program instructions
And/or the combination of the process and/or box in box and flowchart and/or the block diagram.It can provide these computer programs to refer to
Enable the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing terminal devices with
A machine is generated, so that generating by the instruction that computer or the processor of other programmable data processing terminal devices execute
For realizing the function of being specified in one or more flows of the flowchart and/or one or more blocks of the block diagram
Device.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing terminal devices
In computer-readable memory operate in a specific manner, so that instruction stored in the computer readable memory generates packet
The manufacture of command device is included, which realizes in one side of one or more flows of the flowchart and/or block diagram
The function of being specified in frame or multiple boxes.
These computer program instructions can also be loaded into computer or other programmable data processing terminal devices, so that
Series of operation steps are executed on computer or other programmable terminal equipments to generate computer implemented processing, thus
The instruction executed on computer or other programmable terminal equipments is provided for realizing in one or more flows of the flowchart
And/or in one or more blocks of the block diagram specify function the step of.
It should be understood that
" one embodiment " or " embodiment " mentioned in specification means the special characteristic described in conjunction with the embodiments, structure
Or characteristic is included at least one embodiment of the present invention.Therefore, the phrase " reality that specification various places throughout occurs
Apply example " or " embodiment " the same embodiment might not be referred both to.
Although preferred embodiments of the present invention have been described, it is created once a person skilled in the art knows basic
Property concept, then additional changes and modifications can be made to these embodiments.So it includes excellent that the following claims are intended to be interpreted as
It selects embodiment and falls into all change and modification of the scope of the invention.
In addition, it should be noted that, the specific embodiments described in this specification, the shape of parts and components are named
Title etc. can be different.The equivalent or simple change that all structure, feature and principles described according to the invention patent design are done, is wrapped
It includes in the scope of protection of the patent of the present invention.Those skilled in the art can be to described specific implementation
Example is done various modifications or additions or is substituted in a similar manner, and without departing from structure of the invention or surmounts this
Range as defined in the claims, is within the scope of protection of the invention.
Claims (10)
1. a kind of visualization video generation method based on Form data, which comprises the following steps:
Data to be displayed is obtained, the data to be displayed includes the corresponding data target of several groups and data group, according to data
Group judges the data type of corresponding data target；
The video template to match is extracted from preset template library according to judging result；
According to data to be displayed and extracted video template synthesis visualization video and export.
2. a kind of visualization video generation method based on Form data according to claim 1, it is characterised in that:
The video template includes at least template elements and template configuration item, and the template configuration item includes at least and template elements
Corresponding graphic configuration data, the template elements include at least index graphic element, and the index graphic element is corresponding
Graphic configuration data includes at least specified type.
3. a kind of visualization video generation method based on Form data according to claim 2, which is characterized in that root
It is judged that result extracts the specific steps of the video template to match from preset template library are as follows:
All data targets are judged to the graphic configuration data of indicatrix shape element in resulting data type and each video template
It is matched, as Mj≤Tj, determines corresponding video template as the video template to match, wherein Mj indicates video template
Middle specified type is the index figure number of elements of jth class, and Tj indicates that data type is that the data of jth class refer in data to be displayed
Target quantity.
4. a kind of visualization video generation method based on Form data according to claim 2, which is characterized in that root
Specific steps synthesis visualization video according to data to be displayed and extracted video template and exported are as follows:
The template configuration item further includes visual coding rule and video length configuration data, will be wait open up according to visual coding rule
Registration evidence synthesizes visualization video with extracted video template and exports；
The visual coding rule includes the rule that the matched index graphic element of data target is mapped, and number
The rule mapped according to index and video length configuration data.
5. a kind of visualization video generation method based on Form data according to claim 2, which is characterized in that root
It further include effect set-up procedure, specifically according to data to be displayed and extracted video template synthesis visualization video and after exporting
Step includes:
Adjustment request is obtained, template configuration item is adjusted correspondingly according to adjustment request, generate self-defined template and is saved；
According to data to be displayed and self-defined template synthesis visualization video and export.
6. according to a kind of any visualization video generation method based on Form data of claim 2~5, feature
It is:
The template elements also include at least auxiliary element, the auxiliary element include at least title, legend, head, run-out and
It dubs in background music；
The data type includes numeric type and classification type, when the data type is numeric type, each data in detection data group,
Generate corresponding data characteristics.
7. a kind of visualization video generating system based on Form data characterized by comprising
Data acquisition module, for obtaining data to be displayed, the data to be displayed includes the corresponding data target of several groups
And data group, it is also used to judge according to data group the data type of corresponding data target；
Template extraction module, for extracting the video template to match from preset template library according to judging result；
Video generation module, for visualizing video according to data to be displayed and the synthesis of extracted video template and exporting.
8. a kind of visualization video generating system based on Form data according to claim 7, it is characterised in that:
The video template includes at least template elements and template configuration item, and the template configuration item includes at least and template elements
Corresponding graphic configuration data, the template elements include at least index graphic element, and the index graphic element is corresponding
Graphic configuration data includes at least specified type.
9. a kind of visualization video generating system based on Form data according to claim 8, it is characterised in that:
Template extraction module is configured as:
All data targets are judged to the graphic configuration data of indicatrix shape element in resulting data type and each video template
It is matched, as Mj≤Tj, determines corresponding video template as the video template to match, wherein Mj indicates video template
Middle specified type is the index figure number of elements of jth class, and Tj indicates that data type is that the data of jth class refer in data to be displayed
Target quantity；
Video generation module is configured as:
The template configuration item further includes visual coding rule and video length configuration data, will be wait open up according to visual coding rule
Registration evidence synthesizes visualization video with extracted video template and exports；
The visual coding rule includes the rule that the matched index graphic element of data target is mapped, and number
The rule mapped according to index and video length configuration data.
10. a kind of visualization video generating system based on Form data according to claim 7, which is characterized in that
Further include template adjustment module, the template adjustment module is configured as:
Adjustment request is obtained, template configuration item is adjusted correspondingly according to adjustment request, generate self-defined template and is saved；
According to data to be displayed and self-defined template synthesis visualization video and export.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910795978.4A CN110532427B (en) | 2019-08-27 | 2019-08-27 | Visual video generation method and system based on tabular data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910795978.4A CN110532427B (en) | 2019-08-27 | 2019-08-27 | Visual video generation method and system based on tabular data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110532427A true CN110532427A (en) | 2019-12-03 |
| CN110532427B CN110532427B (en) | 2022-05-17 |
Family
ID=68664468
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910795978.4A Active CN110532427B (en) | 2019-08-27 | 2019-08-27 | Visual video generation method and system based on tabular data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110532427B (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111414368A (en) * | 2020-04-03 | 2020-07-14 | 中国建设银行股份有限公司 | Method and device for processing data |
| CN111787412A (en) * | 2020-07-22 | 2020-10-16 | 杭州当虹科技股份有限公司 | Method for supporting rapid production of multi-platform digital news short videos |
| CN111949723A (en) * | 2020-08-11 | 2020-11-17 | 深圳市前海手绘科技文化有限公司 | Data visualization hand-drawn video generation method |
| CN112529991A (en) * | 2020-12-09 | 2021-03-19 | 威创集团股份有限公司 | Data visualization display method, system and storage medium |
| CN112637520A (en) * | 2020-12-23 | 2021-04-09 | 新华智云科技有限公司 | Dynamic video editing method and system |
| CN113010548A (en) * | 2020-12-28 | 2021-06-22 | 魔元术(苏州)信息科技有限公司 | Automatic matching graph system for data billboard |
| CN113569114A (en) * | 2021-09-28 | 2021-10-29 | 广东电网有限责任公司 | Visual display method and device for system data |
| CN113836294A (en) * | 2021-09-27 | 2021-12-24 | 安徽省财政信息中心 | Data visualization display system and method thereof |
| CN115442655A (en) * | 2021-06-01 | 2022-12-06 | 铸视(上海)科技有限公司 | Data video generation method, medium and electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5852825A (en) * | 1994-12-05 | 1998-12-22 | Trimble Navigation Limited | Form data message formatting method, program and system |
| US20160299678A1 (en) * | 2015-04-13 | 2016-10-13 | Innoruptor LLC | System and method for information presentation and visualization |
| US20160350950A1 (en) * | 2015-05-25 | 2016-12-01 | Colin Frederick Ritchie | Methods and Systems for Dynamic Graph Generating |
| CN107679048A (en) * | 2016-08-02 | 2018-02-09 | 博元森禾信息科技（北京）有限公司 | A kind of general data visualization view generation method and device |
| CN108334543A (en) * | 2017-12-26 | 2018-07-27 | 北京国电通网络技术有限公司 | With electricity consumption data visualization methods of exhibiting and system |
-
2019
- 2019-08-27 CN CN201910795978.4A patent/CN110532427B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5852825A (en) * | 1994-12-05 | 1998-12-22 | Trimble Navigation Limited | Form data message formatting method, program and system |
| US20160299678A1 (en) * | 2015-04-13 | 2016-10-13 | Innoruptor LLC | System and method for information presentation and visualization |
| US20160350950A1 (en) * | 2015-05-25 | 2016-12-01 | Colin Frederick Ritchie | Methods and Systems for Dynamic Graph Generating |
| CN107679048A (en) * | 2016-08-02 | 2018-02-09 | 博元森禾信息科技（北京）有限公司 | A kind of general data visualization view generation method and device |
| CN108334543A (en) * | 2017-12-26 | 2018-07-27 | 北京国电通网络技术有限公司 | With electricity consumption data visualization methods of exhibiting and system |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111414368A (en) * | 2020-04-03 | 2020-07-14 | 中国建设银行股份有限公司 | Method and device for processing data |
| CN111787412A (en) * | 2020-07-22 | 2020-10-16 | 杭州当虹科技股份有限公司 | Method for supporting rapid production of multi-platform digital news short videos |
| CN111949723A (en) * | 2020-08-11 | 2020-11-17 | 深圳市前海手绘科技文化有限公司 | Data visualization hand-drawn video generation method |
| WO2022033148A1 (en) * | 2020-08-11 | 2022-02-17 | 深圳市前海手绘科技文化有限公司 | Method for generating data visualization hand-drawn video |
| CN112529991A (en) * | 2020-12-09 | 2021-03-19 | 威创集团股份有限公司 | Data visualization display method, system and storage medium |
| CN112529991B (en) * | 2020-12-09 | 2024-02-06 | 威创集团股份有限公司 | Data visual display method, system and storage medium |
| CN112637520A (en) * | 2020-12-23 | 2021-04-09 | 新华智云科技有限公司 | Dynamic video editing method and system |
| CN112637520B (en) * | 2020-12-23 | 2022-06-21 | 新华智云科技有限公司 | Dynamic video editing method and system |
| CN113010548A (en) * | 2020-12-28 | 2021-06-22 | 魔元术(苏州)信息科技有限公司 | Automatic matching graph system for data billboard |
| CN115442655A (en) * | 2021-06-01 | 2022-12-06 | 铸视(上海)科技有限公司 | Data video generation method, medium and electronic equipment |
| CN113836294A (en) * | 2021-09-27 | 2021-12-24 | 安徽省财政信息中心 | Data visualization display system and method thereof |
| CN113569114A (en) * | 2021-09-28 | 2021-10-29 | 广东电网有限责任公司 | Visual display method and device for system data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110532427B (en) | 2022-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110532427A (en) | A kind of visualization video generation method and system based on Form data | |
| US6072479A (en) | Multimedia scenario editor calculating estimated size and cost | |
| US6084169A (en) | Automatically composing background music for an image by extracting a feature thereof | |
| CN109299446A (en) | Report-generating method and device | |
| US20050066277A1 (en) | Methods, systems and computer program products for use of color saturation to highlight items in a tree map visualization | |
| CN110415319B (en) | Animation production method and device based on PPT, electronic equipment and storage medium | |
| JP2005339564A (en) | Colorized template preview | |
| CN104111769B (en) | The display methods and device of a kind of electronic file binder | |
| CN111752557A (en) | Display method and device | |
| CN104185088B (en) | A kind of method for processing video frequency and device | |
| CN113010711B (en) | Method and system for automatically generating movie poster based on deep learning | |
| CN106933887A (en) | A kind of data visualization method and device | |
| JP5005005B2 (en) | Visualization program, visualization method, and visualization apparatus for visualizing content reading order | |
| JPH06243023A (en) | Scenario editing device | |
| CN113468261B (en) | Method and system for constructing entity relationship of Internet of things based on graphic editing engine | |
| JP2001306579A (en) | Device and method for retrieving information and computer-readable recording medium recorded with program for computer to execute the same method | |
| CN110532483A (en) | Simulate the adding method of table, device, computer equipment and can storage medium | |
| CN110297958A (en) | Data visualization processing method and processing device | |
| CN102646034B (en) | For the system for the test pattern for generating text definition | |
| CN111782309B (en) | Method and device for displaying information and computer readable storage medium | |
| CN108279962A (en) | A kind of method and device creating visualization data display interface | |
| Escalona et al. | Two graphical models for the analysis and comparison of cartularies | |
| CN109005470B (en) | Method, system and device for synthesizing subtitles on line | |
| CN113626621A (en) | Course content generation system and editing device for online interactive teaching | |
| CN113411517A (en) | Video template generation method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |