I am using boto3 to work with redshift tables. I am running into limitations though regarding the boto3 ExecuteStatement operation. AWS seems to have some api limitations, I can't seem to create large updates. I get the following exception: Failed…
I wanted to loop over a section in my JSON File and render the geometry based on their names in the File. main.py import json data = json.load(open('src/test.json')) for geo in data["geometry"]: if geo == "rect: Geometry.rectangle(draw=pen, x=geo["x"], y=geo["y"], width=geo["width"],…
Create an ai virtual environment: pyton3.11 -m venv ai Install module in virtual environment: cd ai python3.11 -m pip install Pillow python3.11 Python 3.11.0rc2 (main, Jul 21 2023, 09:39:42) [GCC 10.2.1 20210110] on linux Type "help", "copyright", "credits" or "license"…
Existing Code import json filename = 'thunar-volman/debian/control' dict1 = {} with open(filename) as fh: for line in fh: print(line) command, description = line.strip().split(': ') print(command) print(description) dict1[command.strip()] = description.strip() with open("test.json", "w") as out_file: json.dump(dict1, out_file, indent=4, sort_keys = False)…
I am trying to run the following code snipet (based on this code here): import boto3, os from dotenv import load_dotenv load_dotenv() AWS_ACCESS_KEY=os.getenv('AWS_ACCESS_KEY') AWS_SECRET_KEY=os.getenv('AWS_SECRET_KEY') translate = boto3.client( service_name='translate', region_name='us-east-1', aws_access_key_id=AWS_ACCESS_KEY, aws_secret_access_key=AWS_SECRET_KEY, ) result = translate.translate_text(Text="Hello, World", SourceLanguageCode="en", TargetLanguageCode="de") print('TranslatedText: '…
This week, I started working with MongoDB and Flask, so I found a helpful article on how to use them together by using PyDantic library to define MongoDB's models. However, the article is somewhat outdated, mostly could be updated to…
I am trying to set up python on my mac (as a first time user). The problem i encounter is that my interpreter is Python 3.11.4. But in my terminal the python version is only Python 3.9.13. How can i…
I am using extras.execute_values() method in psycopg2 and things don't go throw as I expected: countyid_landid_tuple_list = [(1,1),(1,2),(2,3)] sql = "update agri_land set county_id = %s" extras.execute_values(cur, sql, countyid_landid_tuple_list ,"%s where id = %s") The error message is as follows:…
I have been working through a LangChain tutorial and have hit this problem when trying to import langchain into python in vscode on macos 13.4.1. `from dotenv import load_dotenv import os import streamlit as st from PyPDF2 import PdfReader from…
So I have a situation where I need to convert an Excel sheet into an array of Json objects using Python3. The Excel sheet looks like the following: CARTS ITEMS Cart A Lemons Apples Strawberries Cart B Chocolate Cake Biscuits…