CN111178022A - Two-dimensional chart data standardized format definition and implementation method - Google Patents

Two-dimensional chart data standardized format definition and implementation method Download PDF

Info

Publication number
CN111178022A
CN111178022A CN201911335304.2A CN201911335304A CN111178022A CN 111178022 A CN111178022 A CN 111178022A CN 201911335304 A CN201911335304 A CN 201911335304A CN 111178022 A CN111178022 A CN 111178022A
Authority
CN
China
Prior art keywords
data
format
standard
chart
steps
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201911335304.2A
Other languages
Chinese (zh)
Inventor
徐汕
谢水庚
刘强
罗洪涛
吴墨奇
高淑敏
黄非
杨谱
姜桥
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Casicloud Co ltd
Original Assignee
Beijing Casicloud Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Casicloud Co ltd filed Critical Beijing Casicloud Co ltd
Priority to CN201911335304.2A priority Critical patent/CN111178022A/en
Publication of CN111178022A publication Critical patent/CN111178022A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Transfer Between Computers (AREA)

Abstract

The invention discloses a two-dimensional chart data standardized format defining and realizing method, which comprises the following steps: preparing data; acquiring a standard data format model, and downloading or copying a standard data format through a front-end page; processing data, synthesizing the data stored in the local hard disk into data in a standard format according to the data format downloaded by the front-end page; checking data, checking data in a standard format, and synthesizing standardized chart data; and displaying data, selecting a chart style to be displayed according to requirements, and presenting data information required by a user. Through standardization of data formats and data standard formulation, on one hand, the method realizes automatic identification of user uploading data, and can convert the data into a form which can be displayed by a chart, on the other hand, determines the format of interface returning data, greatly reduces the cost of development at two ends, and shortens the development time.

Description

Two-dimensional chart data standardized format definition and implementation method
Technical Field
The invention relates to the technical field of software engineering, in particular to a two-dimensional chart data standardized format definition and implementation method.
Background
The big data exists in the fields of physics, biology, environmental ecology and the like and the industries of military, finance, communication and the like for a long time, and people pay attention to the development of the internet and information industry in recent years.
With the rapid development and popularization of computers and information technologies, the scale of industrial application systems is rapidly expanded, and data generated by industrial application is explosively increased.
People will increasingly be aware of the importance of data to businesses. The big data era provides new challenges for the data handling capability of human beings and also provides unprecedented space and potential for people to obtain more profound and comprehensive insights.
However, different data formats often result in more complicated data processing and other processes, which leads to a more complicated development process and seriously affects the development progress.
Disclosure of Invention
In view of the above technical problems in the related art, the present invention provides a method for defining and implementing a standardized format of two-dimensional chart data, which can overcome the above disadvantages in the prior art.
In order to achieve the technical purpose, the technical scheme of the invention is realized as follows:
a two-dimensional chart data standardized format definition and implementation method comprises the following steps:
s1: preparing data;
s2: acquiring a standard data format model, and downloading or copying a standard data format through a front-end page;
s3: processing data, synthesizing the data stored in the local hard disk into data in a standard format according to the data format downloaded by the front-end page;
s4: checking data, checking data in a standard format, and synthesizing standardized chart data;
s5: and displaying data, selecting a chart style to be displayed according to requirements, and presenting data information required by a user.
Further, the step S1 includes the following steps:
s11: collecting data needing standardization;
s12: and storing the data to the local hard disk in a corresponding document form.
Further, the step S2 includes the following steps:
s21: accessing a front-end page;
s22: selecting and clicking a data uploading button, and jumping to a page for uploading data;
s23: select and click on the data format to be downloaded.
Further, the step S3 includes the following steps:
s31: deleting the data in the downloaded standard data format;
s32: copying and pasting the data in the local hard disk to the document in the standard data format.
Further, the step S4 includes the following steps:
s41: accessing a front-end page, and selecting and clicking a data uploading button;
s42: transmitting data having a standard format to the system;
s43: and displaying a verification success page.
Further, the step S5 includes the following steps:
s51: selecting and clicking a data visualization button, and jumping to a data visualization front-end page;
s52: selecting and clicking a suitable chart;
s53: and updating and presenting the chart data information.
Further, in the step S2, the method adoptsCSVDocument orJSONThe file encapsulates the data.
The invention has the beneficial effects that: through standardization of data formats and data standard formulation, on one hand, the method realizes automatic identification of user uploading data, and can convert the data into a form which can be displayed by a chart, on the other hand, determines the format of interface returning data, greatly reduces the cost of development at two ends, and shortens the development time.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
FIG. 1 is a flow chart diagram of a two-dimensional chart data standardized format definition and implementation method according to an embodiment of the invention;
FIG. 2 is a block diagram of a flow chart of data transmission of a standardized format definition and implementation method for two-dimensional chart data according to an embodiment of the invention;
FIG. 3 is a block flow diagram of a composite visual chart of a standardized format definition and implementation method for two-dimensional chart data according to an embodiment of the invention;
FIG. 4 is a data format diagram of JSON encapsulation of a standardized format definition and implementation method of two-dimensional chart data according to an embodiment of the present invention;
FIG. 5 is a diagram of a standardized chart data table of a standardized format definition and implementation method of two-dimensional chart data according to an embodiment of the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments that can be derived by one of ordinary skill in the art from the embodiments given herein are intended to be within the scope of the present invention.
As shown in fig. 1, the method for defining and implementing a standardized format of two-dimensional chart data according to an embodiment of the present invention includes the following steps:
s1: preparing data;
s2: acquiring a standard data format model, and downloading or copying a standard data format through a front-end page;
s3: processing data, synthesizing the data stored in the local hard disk into data in a standard format according to the data format downloaded by the front-end page;
s4: checking data, checking data in a standard format, and synthesizing standardized chart data;
s5: and displaying data, selecting a chart style to be displayed according to requirements, and presenting data information required by a user.
Step S1 includes the following steps:
s11: collecting data needing standardization;
s12: and storing the data to the local hard disk in a corresponding document form.
Step S2 includes the following steps:
s21: accessing a front-end page;
s22: selecting and clicking a data uploading button, and jumping to a page for uploading data;
s23: select and click on the data format to be downloaded.
Step S3 includes the following steps:
s31: deleting the data in the downloaded standard data format;
s32: copying and pasting the data in the local hard disk to the document in the standard data format.
Step S4 includes the following steps:
s41: accessing a front-end page, and selecting and clicking a data uploading button;
s42: transmitting data having a standard format to the system;
s43: and displaying a verification success page.
Step S5 includes the following steps:
s51: selecting and clicking a data visualization button, and jumping to a data visualization front-end page;
s52: selecting and clicking a suitable chart;
s53: and updating and presenting the chart data information.
In an embodiment of the present invention, in the step S2, the method usesCSVDocument orJSONThe file encapsulates the data.
In order to facilitate understanding of the above-described technical aspects of the present invention, the above-described technical aspects of the present invention will be described in detail below in terms of specific usage.
Preparing data: the user first prepares the data to be standardized for storage locally for later use. Can be stored locally asTXTOrEXCELEtc. in the form of a document.
Acquiring a standard data format model: the user downloads or copies the standard data format through the front-end page. The method comprises the following specific steps: the user first accesses the page, clicks the data upload button, and clicks the data format to be downloaded on the page where the data is uploaded, such asCSVDocument orJSONDocument data, as shown in fig. 4.
Data processing: and the user generates a standard data format by using the data format acquired from the front-end page. The method comprises the following specific steps: and deleting the downloaded data by the user, and pasting the data into a document or an excel form according to the rule.
Data verification: and the user submits the standard data format to the system, and the system checks. If the verification is successful, normalized chart data will be generated in the page. The method comprises the following specific steps: after the user accesses the page, the user clicks a data uploading button and uploads the data generated after the user modifies the data to the system. If the verification is successful, a data chart will be displayed on the page, as shown in FIG. 5.
And (3) data display: the user selects the required data display style according to the requirement, and can select a pie chart, a bar chart, a histogram and the like. The method comprises the following specific steps: after the page data is generated, a user clicks a data visualization button, selects and clicks a proper chart in a popped page, and finally the chart is displayed in the page.
The system frame mainly comprises three parts: data acquisition, data processing, and data presentation, as shown in fig. 1.
Two standard datamation templates which can provide uploading data for users are defined, and CSV file data uploading is supportedJSONAnd (4) file data.
In uploadingCSVWhen the file is used, the data does not cross the row and does not have empty row by row unit, and the half-angle comma is used as a separator.
In uploadingJSONWhen a file is written, four data formats are provided:
[{"source":"Agricultural","target":"Liquid","value":23}]
[{"name":"Agricultural","value":23,"children":[{"name":"Jackson","value":3,"childern":[]}]}]
[{"name":"Agricultural","value":23}][{"route":{"source":{"name":"London","longitude":-0.461389,"latitude":51.4775},"target":{"name":"Chicago","longitude":-87.904842,"latitude":41.978603}}}]
these formats are applicable to the morse base map, the tree map, the word cloud map, the path map, etc., respectively.
When uploading data, the user may obtain the predetermined format according to the predetermined format or through a downloaded template. In uploadingCSVWhen the file is used, the data does not cross the row and does not empty the row in a row unit; is divided by half angle commaAnd (5) separating characters.
For example:
the name of the person to be named,PV,UV,xxx,xxxx
zhang three, 43,32,9,45
Zhang three, 43,32,9,45
The flow of transmitting data is shown in fig. 2.
When using the data visualization system, a user needs to modify own data according to a provided standard format or modify own data again by using an online provided template. And then submitting the modified standard data into the system through an uploading function of the visualization system. After the system acquires the data, the system performs online analysis and judgment to check whether the acquired data is standard. If the data is provided according to the criteria provided by the system, a corresponding chart is generated, as shown in FIG. 3.
In summary, according to the technical scheme of the invention, through standardizing the data format and establishing the data standard, on one hand, the data uploaded by the user can be automatically identified and converted into a form which can be shown by a chart, and on the other hand, the format of the interface returned data is determined, so that the development cost at both ends is greatly reduced, and the development time is shortened.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.

Claims (7)

1. A two-dimensional chart data standardized format definition and implementation method is characterized by comprising the following steps:
s1: preparing data;
s2: acquiring a standard data format model, and downloading or copying a standard data format through a front-end page;
s3: processing data, synthesizing the data stored in the local hard disk into data in a standard format according to the data format downloaded by the front-end page;
s4: checking data, checking data in a standard format, and synthesizing standardized chart data;
s5: and displaying data, selecting a chart style to be displayed according to requirements, and presenting data information required by a user.
2. The method as claimed in claim 1, wherein the step S1 includes the following steps:
s11: collecting data needing standardization;
s12: and storing the data to the local hard disk in a corresponding document form.
3. The method as claimed in claim 1, wherein the step S2 includes the following steps:
s21: accessing a front-end page;
s22: selecting and clicking a data uploading button, and jumping to a page for uploading data;
s23: select and click on the data format to be downloaded.
4. The method as claimed in claim 1, wherein the step S3 includes the following steps:
s31: deleting the data in the downloaded standard data format;
s32: copying and pasting the data in the local hard disk to the document in the standard data format.
5. The method as claimed in claim 1, wherein the step S4 includes the following steps:
s41: accessing a front-end page, and selecting and clicking a data uploading button;
s42: transmitting data having a standard format to the system;
s43: and displaying a verification success page.
6. The method as claimed in claim 1, wherein the step S5 includes the following steps:
s51: selecting and clicking a data visualization button, and jumping to a data visualization front-end page;
s52: selecting and clicking a suitable chart;
s53: and updating and presenting the chart data information.
7. The method as claimed in claim 3, wherein in step S2, the standardized format of two-dimensional chart data is defined and implementedCSVDocument orJSONThe file encapsulates the data.
CN201911335304.2A 2019-12-23 2019-12-23 Two-dimensional chart data standardized format definition and implementation method Pending CN111178022A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911335304.2A CN111178022A (en) 2019-12-23 2019-12-23 Two-dimensional chart data standardized format definition and implementation method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911335304.2A CN111178022A (en) 2019-12-23 2019-12-23 Two-dimensional chart data standardized format definition and implementation method

Publications (1)

Publication Number Publication Date
CN111178022A true CN111178022A (en) 2020-05-19

Family

ID=70646261

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911335304.2A Pending CN111178022A (en) 2019-12-23 2019-12-23 Two-dimensional chart data standardized format definition and implementation method

Country Status (1)

Country Link
CN (1) CN111178022A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107124448A (en) * 2017-04-10 2017-09-01 上海斐讯数据通信技术有限公司 A kind of router OUI storehouses update realization method and system
US20180157467A1 (en) * 2016-12-03 2018-06-07 Thomas STACHURA Spreadsheet-Based Software Application Development
CN109032586A (en) * 2018-07-09 2018-12-18 中国银行股份有限公司 A kind of data visualization method and device
CN109977088A (en) * 2019-03-30 2019-07-05 湖北畅云时讯软件技术有限公司 A kind of method that preset format file is converted to OFD format

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20180157467A1 (en) * 2016-12-03 2018-06-07 Thomas STACHURA Spreadsheet-Based Software Application Development
CN107124448A (en) * 2017-04-10 2017-09-01 上海斐讯数据通信技术有限公司 A kind of router OUI storehouses update realization method and system
CN109032586A (en) * 2018-07-09 2018-12-18 中国银行股份有限公司 A kind of data visualization method and device
CN109977088A (en) * 2019-03-30 2019-07-05 湖北畅云时讯软件技术有限公司 A kind of method that preset format file is converted to OFD format

Similar Documents

Publication Publication Date Title
CN111095215B (en) Inter-application delivery format specific data objects
US9299041B2 (en) Obtaining data from unstructured data for a structured data collection
CN108536459B (en) Updating method, device, equipment and computer storage medium of financial product
CN111381909B (en) Page display method and device, terminal equipment and storage medium
US9218568B2 (en) Disambiguating data using contextual and historical information
CN110119294A (en) The generation method of menu page, apparatus and system
CN116127020A (en) Method for training generated large language model and searching method based on model
US9262550B2 (en) Processing semi-structured data
JP7237905B2 (en) Method, apparatus and system for data mapping
CN111813910A (en) Method, system, terminal device and computer storage medium for updating customer service problem
CN114035793A (en) Page generation method, page generation device, equipment and storage medium
CN113900650A (en) Data processing method and device, electronic equipment and readable storage medium
EP3869398A2 (en) Method and apparatus for processing image, device and storage medium
CN111913922A (en) Binary structured log generation method, device, equipment and storage medium
CN109558186A (en) A kind of page display method and device
CN111178022A (en) Two-dimensional chart data standardized format definition and implementation method
CN102663063B (en) System and method for showing general information of multiple user platforms based on XSLT (extensible stylesheet language transformation)
CN109584012B (en) Method and device for generating item push information
CN110633476B (en) Method and device for acquiring knowledge annotation information
US20110302484A1 (en) Electronic Forms Completion Method
CN112328871A (en) Reply generation method, device, equipment and storage medium based on RPA module
CN110990528A (en) Question answering method and device and electronic equipment
CN109726322A (en) Method and apparatus for pushed information
CN112270350B (en) Method, apparatus, device and storage medium for portraying organization
US11983554B2 (en) Automating semantically-related computing tasks across contexts

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