The present disclosure provides a method and system that is generic for automatic JSON data parsing. The system obtains the JSON data of various structures as input for parsing. During the parsing, if the JSON data is not valid or corrupt then the system filters out that JSON data and stores at a different location. Thereafter, the system parses the JSON data from top to bottom after analysing each key and stores the values of each key. During the parsing, a schema of the JSON data is created by the system. The system derives unique names of column after analysing the schema and stores the value corresponding to its column name. Upon deriving the column name and values, the system stores them in a data frame, or a file. The present disclosure prevents manually intervention and automatically parse the various JSON data.

Figure 1a

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.