Unordered row and column transposition method and device, computer equipment and storage medium

Abstract

The embodiment of the invention discloses a disordered row and column transposition method and device, computer equipment and a storage medium. The method comprises: determining the number of initialdata included in each cell of a to-be-transposed table; calling a preset splitting function to split each cell in the to-be-transposed table into a plurality of sub-cells arranged in sequence to obtain a first intermediate table; according to the determined number, obtaining a corresponding number of sequence mark bits in sequence from a preset sequence mark bit array; respectively inserting different sequence mark bits acquired for each row into sub-cells obtained by splitting each cell in each row; and calling a preset Lateral function to sequentially convert all the sub-cells obtained by splitting the same cell in each row of the first intermediate table into a column where the cell is located, so as to obtain a target table. According to the method, efficient management of the table data can be realized, and the user experience is improved.

Description

technical field [0001] The present invention relates to the field of data processing, in particular to a method, device, computer equipment and storage medium for transposing disordered rows and columns. Background technique [0002] A database refers to a collection of data that is stored together in a certain way, can be shared by multiple users, has as little redundancy as possible, and is independent of the application. The database takes tables as entities, and its essence is a file system that stores data in corresponding tables in a specific format. Users can add, modify, delete and query the data in the tables in the database. At present, people will generate a large amount of data in production and life. In order to read and manage data better, a large amount of data is usually stored in the table of the database, and the data in the table of the database may also be converted into rows and columns accordingly. However, the operation of row-to-column conversion is ...

AI Technical Summary

Problems solved by technology

At present, people will generate a large amount of data in production and life. In order to read and manage data better, a large amount of data is usually stored in the table of the database, and the data in the table of the database may also be converted into rows and columns accordingly. However, there are some irreversible situations in the current row-to-column operation, that is, the row-to-column operation cannot be restored to the original state before the transposition, which is not convenient for data management

Images