Advertisements Some columns in my dataframe consist of dictionaries themselves, like this dataframe: df = pd.DataFrame({‘Name’: [‘Alice’, ‘Bob’, ‘Aritra’], ‘Age’: [25, 30, 35], ‘Location’: [ {‘City’: ‘Seattle’, ‘State’: ‘WA’}, {‘City’: ‘New York’, ‘State’: ‘NY’}, {‘City’: ‘Albany’, ‘State’: ‘NY’} ] }) df Name Age Location 0 Alice 25 {‘City’: ‘Seattle’, ‘State’: ‘WA’} 1 Bob 30 {‘City’:… Read More Pandas: Filter rows on value in dictionaries in Series

Advertisements I’m still really new to Python. Like, I’m only on Chapter 4 level of new (with very little prior experience). I have no doubt that I’m jumping the gun in asking this, but I’m not confident in my abilities in programming, and this is just a curiosity. I want to know how to put… Read More How do you nest a while loop inside of an if statement? (Python)

Advertisements Is it possible to parse through this list and create a new nested object for every sensor after "RECORD". { "TIMESTAMP": "2022-10-21 13:55:00", "RECORD": "0", "Sensor1": "1.654", "Sensor2": "1.176", "Sensor3": "0.706" } Result: { "Sensor1": { "TIMESTAMP": "2022-08-21 13:55:00", "Value": "1.654" }, "Sensor2": { "TIMESTAMP": "2022-08-21 13:55:00", "Value": "1.176" }, "Sensor3": { "TIMESTAMP": "2022-08-21… Read More Create nested object from list of objects

Advertisements I want to sort the teams in this dict based on the points and I already followed the advise in this post and the sorted code I wrote doesn’t work as I want to. Here is my dictionary: { ‘Spain’: { ‘wins’: 3, ‘loses’: 0, ‘draws’: 0, ‘goal difference’: 4, ‘points’: 9 }, ‘Iran’:… Read More Sorting a nested dictionary

Advertisements I have been working with a data structure for days and days, and am finally getting the data I want from it using a nested forEach loop. Trouble is, I’m getting a string for each loop, so in my console. I see a long list of individual strings for each item. I need to… Read More How to Return an Array from a Nested ForEach Method?

Advertisements I am trying to update an element in an arbitrarily embedded list of lists. For example, a potential embedded list looks like: lst = [‘a’, [‘b’, [‘c’, ‘d’]]] And I want to update ‘b’ to the string "NEWVALUE". We can assume every element is unique, and, if it helps, every list is of length… Read More How to update an element of an (arbitrarily) embedded list?

Advertisements I have a table with 1 normal mode column id and a struct(record, repeated) column details. The details column has country and name column nested inside that. I have five records inside the details column. country name UK sarah IND carter Itay marie France john peru christy I am using the below query to… Read More Updating a struct column in bigquery

Advertisements I am trying to create a program wherein the program will generate a random number between 0 and 100, and depending on the range, will assign the equivalent Letter Grade to it. I have my If and Else if statements already laid out, but I am getting the following errors on the "else if"… Read More Error: Else without If, and ";" Expected in Nested If Statement

Advertisements I’m sorry for the crazy title. I’m new to programming and have no idea what I’m doing. I’m making a weight tracker that saves data to a JSON. The data is a nested dictionary that supposed to look like: { "Dates": { "11/11/11": { "Morning": 500, "Night": 502 } } } I’ve been trying… Read More How to change the values of user-inputted strings that act as keys in a nested dictionary pulled from a JSON