Reading JSON File using Python
This experiment is to demonstration how to read json file in Azure ML using python script module.
Hi Everyone,
I was tasked to read json file in AzureML using python script and couldn't find help, so thought that this experiment can help someone who would like to achieve same thing.
I have also used helped from following blog to create my experiment.
https://www.sqlshack.com/how-to-use-json-data-in-azure-machine-learning/
Steps which I followed:
1. Downloaded posts.json file from above blog.
2. Create posts.zip file using downloaded file in step 1.
3. Upload post.zip file as dataset on AzureML
4. Use this experiment to consume your file.
Following is the only code part which you will have to add in your code.
df = pd.read_json('.\Script Bundle\posts.json')
return df,
Enjoy...
CRP