So I have this nested json and I'm struggling with the conversion into a tabular form because of how it's shaped, it could become a .xslx or .csv. I tried doing it like this but I didn't work. # Load…
I have a dataframe that is coming from an api, the string version looks like this: 0 2023-04-17 4.82 2023-04-18 4.82 2023-04-19 4.82 2023-04-20 4.82 2023-04-21 4.81 when I call df.to_json(orient = 'records') it looks like this (no good at…
I need an SQL query for the next question. For example I have a table: | id | element | dt | | -------- | -------- | -------- | | 1 | a | 22/04/22 | | 2 | a…
I am writing a function that returns a Pandas DataFrame object. I would like to have some kind of a type hinting what columns this DataFrame contains, outside mere specification in the documentation, as I feel this will make it…
I have two data frames. DF1 isActive,trackedSearchId True,53436615 True,53434228 True,53434229 DF2 trackedSearchIds,Primary Keyword Group(s) "[53436613, 53436615, 53437436, 53436506]",SEO - Directory-Deployment "[53435887, 53437509, 53437441, 53436615, 53438685, 53437636]",SEO - Other-Glossary "[53437504, 53435090, 53435887, 53434228]",SEO - Other "[53437504, 53435090, 53434229]",SEO - Glossary I…
I have a pandas dataframe where 2 columns are nested column having decimal value: df.tail(1).to_dict('list') gives this kind of data {'nested_col1': [array([{'key1': 'CO', 'key2': Decimal('8.940000000')}], dtype=object)], 'nested_col2': [array([{'key3': 'CO', 'key4': 'P14', 'key5': Decimal('8.940000000'), 'key6': None}], dtype=object)]} I am trying to…
I am trying to run a python code which uses pandas library. I am getting an error saying that bz2 can not be found. I do not have root access and can not install anything. Is there a way to…
I want to calculate the distance between two neighboring data point. The following is my code: from haversine import haversine import pandas as pd # Convert deviceTime column to datetime format df['deviceTime'] = pd.to_datetime(df['deviceTime']) # Calculate the Haversine distance between…
I'm very new to Python and currently undertaking a personal project using downloaded JSON files from Facebook, all from one chat on messenger. I keep getting an error saying df is not defined, despite me defining df. I have multiple…
I'm trying to run the following code in VS Code: import pandas as pd df = pd.read_csv('data.csv') But it shows the problem: This didn't happen before. The other solutions I saw didn't seem to work. This same problem happens with…