I have DataFrame like below: data type: COL1 - float COL2 - int COL3 - int COL4 - float COL5 - float COL6 - object COL7 - object Source code: a = pd.DataFrame() a["COL1"] = [0.0, 800.0] a["COL2"] = [2,…
I have a json output which looks like this. {'pagination': {'limit': 100, 'offset': 0, 'count': 38, 'total': 38}, 'data': [{'name': 'Ceco Environmental Corp', 'symbol': 'CECE', 'has_intraday': False, 'has_eod': True, 'country': None, 'stock_exchange': {'name': 'NASDAQ Stock Exchange', 'acronym': 'NASDAQ', 'mic': 'XNAS',…
I have a JSON file in the below format and I want to convert it into a pandas dataframe using a function. The fuction should return the dataframe and the sensorID. sensor_data_df, sensorID = ImporterFunction( json_str ) • Input 1:…
Trying to extract the username from the author column of the dataframe for each row, the author column is series & the individual values inside author is a dictionary. Converting the author column directly to df & & changing the…
i was trying to import a csv file(named as bostondatasets1.csv) in pandas using vscode .i checked & modified the syntax multiple times but the terminal is still showing error. it's showing that "No such file or directory"... can someone tell…
I have json files in this generic format: {"attribute1": "test1", "attribute2": "test2", "data": { "0": {"metadata": { "timestamp": "2022-08-14"}, "detections": { "0": {"dim1": 40, "dim2": 30}, "1": {"dim1": 50, "dim2": 20}}}, "1": {"metadata": { "timestamp": "2022-08-15"}, "detections": { "0": {"dim1":…
I'm working with a dataframe: day account_id balance 2022-11-01 ncw8y7 1.000000 2022-11-02 ncw8y7 1.000424 Which I would like to transform into nested dictionary in which the 1st level is the account_id, 2nd level is category name "balances", 3rd level is…
I'm trying to convert the dates inside a JSON file to their respective quarter and year. My JSON file is formatted below: { "lastDate": { "0": "11/22/2022", "1": "10/28/2022", "2": "10/17/2022", "7": "07/03/2022", "8": "07/03/2022", "9": "06/03/2022", "18": "05/17/2022", "19":…
When I'm using ticker = "MSFT" stock = yf.Ticker('MSFT').history('5y') stock I get a dataframe in response When I use ticker = "MSFT" stock_info = yf.Ticker(ticker).info stock_info I'm receiving a list from Yahoo finance API. How can I transform this list…
I have a python code that is presenting a different behavior when I run it on Windows and when I run it on CentOS. Below is the partial code that is of interest for this issue with comments to explain…