Advertisement
Guest User

Untitled

a guest
Oct 17th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. if __name__ == '__main__':
  2. parser = argparse.ArgumentParser(description='Converting json files into csv for Tableau processing')
  3. parser.add_argument(
  4. "-j", "--json", dest="json", help="/Users/viktorija/PycharmProjects/json_conv_csv/", metavar="FILE", required=True)
  5.  
  6. args = parser.parse_args()
  7.  
  8. with open(args.json, "r") as inputFile: # open json file
  9. json_data = json.loads(inputFile.read()) # load json content
  10.  
  11. final_data = json_normalize(flat_json, 'food')
  12. with open(args.json.replace(".json", ".csv"), "w") as outputFile: # open csv file
  13. # saving DataFrame to csv
  14. final_data.to_csv(outputFile, encoding='utf8', index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement