# I'm facing an issue when trying to execute the following code snippet using psycopg2 in place of create_engine. # Code snippet using create_engine (works fine): from sqlalchemy import create_engine import pandas as pd db_url = "your_database_url_here" engine = create_engine(db_url)…
I am trying to run a .ipynb file using pypy with vscode however when I try to run one of the cell, I have an error saying I need to install the ipykernel package but when I do install the…
I am unsing json.dump to generate multiple JSON files. The JSON is like this: [ {"any": 2023}, { "dia": 24, "mes": 1, "any": 2023, "mes_referencia": 12, "any_referencia": 2022, "calendari_nom": "CTH" }] But what I need is that the first part,…
How to convert a pyspark data frame like below to a json array structure OrderID field fieldValue itemSeqNo 123 Date 01-01-23 1 123 Amount 10.00 1 123 description Pencil 1 123 Date 01-02-23 2 123 Amount 11.00 2 123 description…
I am using python to convert the text input file to json. My Code: import json import re filename = "text.txt" text = {} pattern = re.compile(r's*([^=t]+)s*=s*(.*)') with open(filename, encoding='utf8') as file: for line in file: match = pattern.match(line.strip()) if…
I am trying to make code, which comunicates with API. It updates users roblox group rank. Firstly, I wrote the code in Python. It had no problem. But then I tried to "translate" it to PHP and for some reason…
NEW EDIT: Got the function on the same domain so preflight check is passed. Now I funnily enough encounter auth issues. request is not authenticated ... My new request code on front-end: key= "myworkingkey" const response = await axios.post( '/functionName',…
I've been trying to figure out how to include the two templates in my base html and I found no success. I'm not certainly familiar with {% include %} and {% extends %} function and I believe I am not…
I programmed a classic Snake using pygame. i want to save the top 5 scores and when someone beats one of those scores the game overrides the current top records. what would the topfive dictionary look like and how can…
I am using the following bit of code to read the iris dataset from an s3 bucket. import pandas as pd import s3fs s3_path = 's3://h2o-public-test-data/smalldata/iris/iris.csv' s3 = s3fs.S3FileSystem(anon=True) with s3.open(s3_path, 'rb') as f: df = pd.read_csv(f, header = True)…