Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if __name__ == '__main__':
- parser = argparse.ArgumentParser(description='Converting json files into csv for Tableau processing')
- parser.add_argument(
- "-j", "--json", dest="json", help="/Users/viktorija/PycharmProjects/json_conv_csv/", metavar="FILE", required=True)
- args = parser.parse_args()
- with open(args.json, "r") as inputFile: # open json file
- json_data = json.loads(inputFile.read()) # load json content
- final_data = json_normalize(flat_json, 'food')
- with open(args.json.replace(".json", ".csv"), "w") as outputFile: # open csv file
- # saving DataFrame to csv
- final_data.to_csv(outputFile, encoding='utf8', index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement