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":…
I am trying to install pandas datareader, but I am hit with this error: Collecting pandas-datareader Using cached pandas_datareader-0.10.0-py3-none-any.whl (109 kB) Collecting lxml Using cached lxml-4.9.1.tar.gz (3.4 MB) Preparing metadata (setup.py) ... done Requirement already satisfied: pandas>=0.23 in c:usersmarcuappdatalocalprogramspythonpython311libsite-packages (from…
I'm trying to query a table using pandas.read_sql_query, where I want to match multiple columns to python lists passed in as param arguments. Running into various psycopg2 errors when trying to accomplish this. Ideally, I would provide a reproducible example,…
Hi there, I have installed Python 3.10.8 from Microsoft store and installed Pandas (via pip), but still got this message. Thanks
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 am trying to read several TXT files, I make some modifications to them and then I convert them into a DataFrame with Pandas and there I also run some modification processes, so far everything is fine, everything works perfect,…
I'm working with Shopify's Order API and I receive the following responses, which currently sit in a dataframe (very simplified). +----------+-----------+-----------------------------------------------------------------------------+ | order_id | name | item_order | +----------+-----------+-----------------------------------------------------------------------------+ | 123 | Jon Doe | [{'id':789,'price':40.0,'sku':'HAT'},{'id':790,'price':41.0,'sku':'SHIRT'}] | +----------+-----------+-----------------------------------------------------------------------------+ | 122…