Basically I have two models with one-to-one relationship. And I want retrieve information from one, when I call the other. My models: So I can just call an POST and create an Customer, that customer will have id, first_name and last_name. For now everything is working. But when I try to call my endpoint to cr…
Tag: json
Adding json value in yml in python changing the format to yml again
I have to fetch json data and paste it in one of the values in yml. But it is converting it to yml format. I want the output as below but with the above script it is showing all the data in dictionary format format. I would like to replace the sampleyaml with the added changes. Please help me. Answer
Python Google BigQuery, how to authenticate without JSON file?
I have a JSON file with BigQuery credentials. To connect with Python to BigQuery I need to give the file path in service_account. The JSON looks like a dictionary: I don’t want to use a file in the project. Is there a way instead of a path to file to use JSON string from the dictionary to connect to Big…
ValueError: All arrays must be of the same length
can someone help with the error with converting a json file to a data frame pls I’m trying to convert the JSON text file to a data frame but get the array same length error. I have tried double [[]] around the ‘data’ but still doesn’t work. The text file is at https://stackoverflowtez.…
extracting index[0] of Income Statement imported from Alphavantage API
I am currently trying to do some calculations with the income statement of GOOGL imported from AlphaVantage’s API. Here below is my code: After importing this income statement, I am able to print out the data which comes out as a list. I want to extract of this list(most recent annual report) although w…
How to group a json by a nested key using Python?
Lets say we have a json object in Python: What is the most efficient way to group this data by city, so that we end up with a json in which we group the data by city such that we end up with a json as: … in which the content of the people are included in “people” key. Thanks!
Transform list to dictionary with ID’s and content [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 7 months ago. Improve this question Given list is llist = [‘4|right’, ‘ 2|left’, ‘ 2|down’,…
Seach in JSON with variable depth and structure
I have some highly nested JSON files I need to work with. A short example: I would now like to read all names from the JSON file and write them into a list. This is not particularly difficult if the JSON file has a fixed structure. However, my JSON files have a variable structure and variable depth. Sometimes…
How to handle json query when list object is a timestamp?
i am making a Python script to check my power prices. and i cannot figure out how to handle this data, when the the list object is a timestamp… in example this query this is what i get from the api, and i would like to know how to handle it. i have been googling, an i cannot find my
How do i delete an element of a json object with python?
I’m trying to delete elements from _notes that have _type as 1, but i keep getting an error and I’m not sure what it means, nor do I know how to fix it.. can anyone help me? My trimmed JSON: My python script: Error: Traceback (most recent call last): File “C:programmingpythontrain_one_handru…