I have an excel file with a structure as the following: Title List Title_1 ['str_1', 'str_2'] Title_2 ['str_3', 'str_4'] and I want to get the data in a json structure as: {"0":{"Title": "Title_1", "List": ['str_1', 'str_2']}, "1":{"Title": "Title_2", "List": ['str_3',…
MacBook Air M2 Visual Studio Code Python 3.12.3 I installed pandas using pip3 install pandas and I wite code import pandas as pd If i run this code there is an error ModuleNotFoundError: No module named 'pandas' There is no…
I have automated identification system (AIS) data as nested dictionaries in a pandas dataframe. Here is an example: dfAIS Out[18]: Message ... MetaData 0 {'ShipStaticData': {'AisVersion': 1, 'CallSign... ... {'MMSI': 255814000, 'MMSI_String': 255814000, ... 1 {'MultiSlotBinaryMessage': {'ApplicationID': {... ... {'MMSI':…
I have a problem. I have a nested JSON file: json_data = ''' { "appVersion": "", "device": { "model": "" }, "bef": { "catalog": "" }, "data": [ { "timestamp": "", "label": "", "category": "" } ] } I would…
I am trying to read a csv file into a dataframe to transform that into nested jsons. The deliminter in the csv file is ';'. After loading the data into a dataframe, following is what I get: name frequency frequency_start_date…
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 have json data which compiled by attributes(column) and its elements(data) for each. [ { "attribute_id": "a1", "attribute_name": "Profailkir Idkir", "elements":[ { "formValues": [ "0000a634940" ], "id": "0000a634940" }, { "formValues": [ "0000c84724" ], "id": "0000c84724" }] }, { "attribute_id":…
I am unfamiliar with how to convert Json objects to Dataframe. I am hoping to get some ideas of more efficient ways to convert Json object to data frame. As I loop through 2 rows of my input_df, I will…
I have a ligh Python app which should perform a very simple task, but keeps crashing due to OOM. What app should do Loads data from .parquet in to dataframe Calculate indicator using stockstats package Merge freshly calculated data into…
For some reason this clutch.co scraper is working propperly if i run it on one site a. https://clutch.co/us/web-developers - the us-category: it works awesome b. https://clutch.co/il/web-developers - the israel-category: it does not work So when I run this code it'll…