I have a json that is three levels deep. I want to flatten it into a dataframe that has five columns. id name code level parent_id So: The part I struggle with is that I can extract each nested item,…
I'm in ubuntu 20.04, been trying to install a more recent version of numpy after realising I had 1.24.4 but whenever I try to update it with pip3 install --upgrade numpy It keeps giving me this message Requirement already satisfied:…
I need to process multiple messages in JSON format. Each message has its own nested structure. I would like to create a Python SDK to process these messages. My idea is to map each JSON structure into a set of…
I am trying to connect to a MySQL database hosted on my website's domain using Python, but I keep encountering the following error: mysql.connector.errors.DatabaseError: 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) my code: import mysql.connector try: db…
I am using SQLAlchemy and PostgreSQL, and I am trying to create a case-insensitive unique constraint that works like this UniqueConstraint( 'country', 'organisation_id', func.lower(func.trim('name')), name='uq_country_orgid_lower_trim_name' ) Ensuring a unique combination of name, country and organisation id, regardless of case and…
I have a very simple pipeline that fetches the AQI data and stores them in a csv file. Here is the script: import requests import time from datetime import datetime, timedelta import csv import sys from tqdm import tqdm from…
What is the difference between celery -A tasks worker -l info --concurrency=4 And celery -A tasks worker -l info -n worker1@%h celery -A tasks worker -l info -n worker2@%h celery -A tasks worker -l info -n worker3@%h celery -A tasks…
I’m looking for a way to programmatically log in to Azure without needing to install the Azure CLI. Currently, I use the following commands: az login --service-principal -u <user_credentials> -p <password> --tenant <tenant_id> az account set -s <subscription_id> However, these…
The issue is as follows. I usually work with Python to develop my apps. yesterday I wanted to try UV framework, and I found it very nice. However, I soon found out that the .venv folder created is not showing…
I have a python project in Ubuntu 24.04.1 LTS and I have a DevContainer in VSC with Debian GNU/Linux 11, the problem is that Pylance is flagging import streamlit as st with Import "streamlit" could not be resolved. If I…