There are good reasons though why you might want to work in python instead of R. Especially if you want to visualize what the data looks like. Personally, I think dealing with pseudo JSON in R is easier than trying to deal with it in python. Since I think both these stack overflow questions have answers that provide a lot of detail about what you can do (more than what I can provide), I’m not going to put an example here on how to convert pseudo JSON (pulled using JIRA API) into a csv. There is a promising answer under the first link though, that describes how to create a function that will flatten JSON objects. Most of these methods require a bit of hard coding on which fields you want, which means your code won’t be very flexible if you try to use it for other applications. If you are looking for inspiration, I recommend the following references: If you have a situation like this, I recommend taking the time to understand how the fields are nested within each other because that will inform how you want to pull the information out and store it in a csv (and maybe you don’t even want all the fields). Unfortunately this is not one of those cases. If you don’t have nested objects, you might be able to convert this pretty easily to a csv ( ). Name,Location_City,Location_State,Hobbies_0,Hobbies_1,Year,TeamId,PlayerId,Salary.Keep in mind, this isn’t a real JSON file, this is simply in a JSON like structure. What I would like to obtain is 1 line per ticket in the csv, with headings:
With open(args.json_file.replace(".json", ".csv"), "w") as outputFile: # open csv fileįinal_data.to_csv(outputFile, encoding='utf8', index=False) Json_data = json.loads(inputFile.read()) # load json content With open(args.json_file, "r") as inputFile: # open json file "-j", "-json", dest="json_file", help="PATH/TO/json file to convert", metavar="FILE", required=True) Parser = argparse.ArgumentParser(description='Converting json files into csv for Tableau processing') My code, so far, looks like this: import jsonįrom pandas.io.json import json_normalize
I have been basically adapting it to my problem, but it is still not working for me. I've found very helpful "flattening" json info in this blog post. I am trying to convert a nested json into a csv file, but I am struggling with the logic needed for the structure of my file: it's a json with 2 objects and I would like to convert into csv only one of them, which is a list with nesting.
0 kommentar(er)
