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…
I have the following code: listofmodels = [resultmodeldistancearlylife,resultmodeldurationearlylife,resultmodeldistancenavigate,resultmodeldurationnavigate,resultmodeldistancetravel,resultmodeldurationtravel,resultmodeldistancevideo,resultmodeldurationvideo,resultmodeldistancelifestyle,resultmodeldurationlifestyle,resultmodeldistancegrow,resultmodeldurationgrow,resultmodeldistancesleep,resultmodeldurationsleep,resultmodeldistancedemographics,resultmodeldurationdemographics] names = ['resultmodeldistancearlylife','resultmodeldurationearlylife','resultmodeldistancenavigate','resultmodeldurationnavigate','resultmodeldistancetravel','resultmodeldurationtravel','resultmodeldistancevideo','resultmodeldurationvideo','resultmodeldistancelifestyle','resultmodeldurationlifestyle','resultmodeldistancegrow','resultmodeldurationgrow','resultmodeldistancesleep','resultmodeldurationsleep','resultmodeldistancedemographics','resultmodeldurationdemographics'] for i in range(len(listofmodels)): fig, axes = plt.subplots(nrows=2, ncols=2) plt.tight_layout() plt.title(names[i],loc='left') sns.residplot(listofmodels[i].predict(), y, lowess=True, scatter_kws={'alpha': 0.5}, line_kws={'color':'red'}, ax=axes[0,0]) axes[0,0].title.set_text('Residuals vs Fitted Linearity Plot') axes[0,0].set(xlabel='Fitted', ylabel='Residuals') sm.ProbPlot(listofmodels[i].resid).qqplot(line='s', color='#1f77b4', ax=axes[1,0]) axes[1,0].title.set_text('QQ…