I'm trying to read a file with multiple columns. One such column is named 'answer', containing values that pretty much are Python dictionaries. Values include: {'number': '2', 'date': {'day': '', 'month': '', 'year': ''}, 'spans': []} and {'number': '', 'date':…
I am working on an API and i'm trying to create a Flask route to fetch my data but there is a problem. When converting my dataframe into a json. The date column 'Mon, 15 Apr 2024 11:20:20 GMT' becomes…
Given the interface and the class below public interface IFoo { string Name { get; set; } } public class Foo : IFoo { public string Name { get; set; } = "name"; public string Value { get; set; }…
I have this multidimensional object from an API: let curr = { "base_currency_code": "EUR", "base_currency_name": "Euro", "amount": "10.0000", "updated_date": "2024-04-14", "rates": { "USD": { "currency_name": "United States dollar", "rate": "1.0649", "rate_for_amount": "10.6489" }, "AUD": { "currency_name": "Australian dollar", "rate": "1.6444",…
In my MongoDB collection I have a documents that follow a parent-child structure. Each parent doc typically has 4 fields, with the children having 3 (no group field). parent: { _id: doc_123 parent_id: 123 active: true group: A } children…
I'm using VSCode for a Node.js project, and I have set up my editor to automatically sort JSON files on save, using the following setting in my settings.json: "editor.codeActionsOnSave": { "source.sort.json": "always" } I want to exclude package.json from being…
I have one json file which has some duplicates based on a column called userid, and want to remove those duplicates using append() function so that it can output a new file with the same format as the original one.…
I have run the following Python script to remove duplcates between two json files based on userid: import json with open("target_user.json", "r", encoding='utf-8') as f1: target = json.load(f1) with open("source_user.json", "r", encoding='utf-8') as f2: source = json.load(f2) target2 = []…
This file splits the text variable from book, chapter, and verses. It should ideally look like this: [ { "book": "PLACEHOLDER", "chapters": [ { "chapter": 1, "verses": [ { "verse": 1, "text": "this is book 1, chapter 1, verse 1"…
I am trying to scrape information about orbits for asteroids in R. I have tried rvest and selectorgadget, however the website is dynamic. The website is: https://ssd.jpl.nasa.gov/tools/sbdb_lookup.html#/?sstr=2006%20WP1 I am wanting to get the data for the Osculating Orbital Elements under…