#Json compare in python full
#Json compare in python code

#Json compare in python code

I took your comment #parsed_json to mean that you had, but I think you were missing the json.loads method calls I included in my code example above. The function returns False as soon as a part of the JSON is not the same.ĮDIT: In response to your posted error code, I think you might not have parsed the json correctly.so requirement is to loop all columns and then compare and write to json. You might want to add a similar clause for lists. Input files: And these input files are dynamic, for example this below example file has only two keys, where are ohter files i have may dynamic number of keys. If not, then it compares them, if so, then it goed into the next one. The function checks if the type of the nested json object is now a dict (it has already been parsed).Additionally I would have replaced it with keys.append(key) in your example. There is no need to get a list of the keys first, you can just iterate over example_json.keys().I have made several changes to your code.

#Json compare in python full

In the first function we parse the full JSON object (including the recursive parts).

If x not in target_json or not compareParsedJson(example_json, target_json): If not x in target_json or not example_json = target_json: Return compareParsedJson(example_json, target_json)ĭef compareParsedJson(example_json, target_json): I think the following code should do the trick: def compareJson(example_json_s, target_json_s):Įxample_json = json.loads(example_json_s) TypeError: string indices must be integers, not str Print '''#inhabits 'results ' going one layer deeper'''ĬompareJson(example_json, target_json)Īnd the Error code here: Traceback (most recent call last):įile '/home/philip/Desktop/empfang_test.py', line 199, in Įmpfange() #Programm wartet in einer Endlosschleife auf eingehende Nachrichten.įile '/home/philip/Desktop/empfang_test.py', line 193, in empfangeĬheckvalue=compareJson(json.loads(config),parsed_json_dummy)įile '/home/philip/Desktop/empfang_test.py', line 183, in compareJsonĬompareJson(example_json,target_json) If not x in target_json or x not in example_json.keys() and not example_json = target_json: If you have a JSON string, you can parse it by using the json.loads() method. def compareJson(example_json_s, target_json_s): Parse JSON - Convert from JSON to Python. But the idea would be to convert JSON to CSV and compare using Panda or other such libraries. it sais 'string indices must be integers, not unicode' in the script when trying to call the function in the function. Answer (1 of 4): Without actual content of both files, can not suggest any easy way. My Problem is that i can't call the recursive function. (in this funtion now i detect the deeper layer with the key 'results' but i futur it will be changed to a variable key. to go into a deeper layer i call the function giving it the element that contains the deeper layer. Sorted_json_data_file2 = json.I am comparing if all elements of a json object are inside another json.įor that i grab all keys in one layer of the small one and check if they are in the big one and if they are the same.

Sorted_json_data_file1 = json.dumps(json_data_file1, sort_keys=True) The code returns True if the data in both of the files are same regardless of the data order else it returns False.įor example, will return True.įirst, we will read JSON data of two JSON files, sort the data in ascending order by keys and finally use the equal = operator to compare the sorted JSON data of the two files. The following Python code reads JSON data from two JSON files and checks if the data in these two different files are same or not. Compare if Two JSON files have same Data Regardless of Order in Python