Skip to content

Tag: json

How to get parameter values out of json post

I am trying to use the bing maps api to get travel time and distance between 2 gps coordinates. I get a json answer, however, I am not able to get the values out of this dictionary ? gives the following result: now: how do I get the travelDistance out of this ? (14.511 in this case) or the travelDuration

modifiy data of json file

How can I modify the values of json file using python? so my json file is: so this is my json and I want to replace the values like: roll no= 211 and travel=”no” ,singing=”no” I have tried: I have tried this but the only change I’m able to doing is roll no,but I’m unable to change the hobbies values

How can we parse a JSON file for specific records of county borders and overlay that on a Folium HeatMap?

I found a JSON file that has borders of US counties, right here. How can I parse that file for specific records, like ‘Durham’ and ‘Raleigh’ and ‘Charlotte’ together, and plot these on a Folium map? When I run the code below, I have all counties plotted on the map, be because no specific counties are parsed out before

How to pick up data from json objects in python?

I am trying to pick Instances in the json objects data which looks like this [{‘Groups’: [], ‘Instances’: [{‘AmiLaunchIndex’: 0, ‘ImageId’: ‘ami-0ceecbb0f30a902a6’, ‘InstanceId’: ‘i-xxxxx’, ‘InstanceType’: ‘t2.micro’, ‘KeyName’: ‘xxxx’, ‘LaunchTime’: {‘$date’: ‘2022-12-17T13:07:54Z’}, ‘Monitoring’: {‘State’: ‘disabled’}, ‘Placement’: {‘AvailabilityZone’: ‘us-west-2b’, ‘GroupName’: ”, ‘Tenancy’: ‘default’}, ‘PrivateDnsName’: ‘’, ‘PrivateIpAddress’: ‘xxxxx’, ‘ProductCodes’: [], ‘PublicDnsName’: ‘’, ‘PublicIpAddress’: ‘xxxxxx’, ‘State’: {‘Code’: 16, ‘Name’: ‘running’}, ‘StateTransitionReason’: ”, ‘SubnetId’: ‘subnet-xxxxx’,

Python json to object from model

I know this looks like Frequency Ask Question mainly this question: How to convert JSON data into a Python object? I will mention most voted answer: Based on that answer, x is object. But it’s not object from model. I mean model that created with class. For example: I’m asking this is simply because my autocompletion doesn’t work in my

Python subprocess – git log wrong JSON Format

I tried to format git log to json but failed miserabely. I used this command for the formatting, and I don’t think this is where my problem lies, but hey you never know. These are my functions. As a result I get this file – in the wrong JSON Format. Why is this and what is wrong. output/test.json What do

Extract a value from a JSON string stored in a pandas data frame column

I have a pandas dataframe with a column named json2 which contains a json string coming from an API call: “{‘obj’: [{‘timestp’: ‘2022-12-03’, ‘followers’: 281475, ‘avg_likes_per_post’: 7557, ‘avg_comments_per_post’: 182, ‘avg_views_per_post’: 57148, ‘engagement_rate’: 2.6848}, {‘timestp’: ‘2022-12-02’, ‘followers’: 281475, ‘avg_likes_per_post’: 7557, ‘avg_comments_per_post’: 182, ‘avg_views_per_post’: 57148, ‘engagement_rate’: 2.6848}]}” I want to make a function that iterates over the column and extracts the number

Change dates to quarters in JSON file Python

I’m trying to convert the dates inside a JSON file to their respective quarter and year. My JSON file is formatted below: The current code I’m using is an attempt of using the pandas.Series.dt.quarter as seen below: The issue I face is that my code isn’t comprehending the object name “lastDate”. My ideal output should have the dates ultimately replaced