Category "python"

How to make python read multiple sheets on an excel file one by one

Stackoverflow Hi python noob here. I been learning python for couple of weeks so I don’t know if this is possible or even super easy. I have an excel file

Imperatively map both entity and value object inside that entity to one table

Let's say I have an entity which is mapped to a postgresql table in sqlalchemy. @dataclass class User: id: int email: str password: str country:

Is there a pythonic way to specifc which mouse pointer performs which action when using multiple pointers?

I'm trying to run a script on my PC that uses my mouse while I also use the PC for other tasks. The script performs regular GUI interactions on one specific mon

sys.exit() triggers TypeError: object of type 'NoneType' has no len() error

I can not make my script stop. I've tried sys.exit () as well as os._exit() I have a bit of the code: try: report = func_timeout(config.timeout_time,

Why does mypy not consider a class as iterable if it has __len__ and __getitem__ but no __iter__

I was playing around with mypy and some basic iteration in Python and wrote the below code base: from typing import Iterator from datetime import date, timedel

Move a shape inside a list of lists

I have the following list of lists representing a matrix: space = [ [0, 1, 1, 0], [0, 1, 0, 0], [0, 1, 0, 0], [0, 0, 0, 0], ] The number 1s represent an upsid

Tkinter scrollbar for frame

My objective is to add a vertical scroll bar to a frame which has several labels in it. The scroll bar should automatically enabled as soon as the labels inside

Why does the y-axis have to be flipped for a cwt analysis in Python to compare to the Matlab cwt function

For the audio file found here, I am using the ssqueezepy library in Python to generate the cwt of the signal. Here is my Python code: import librosa import lib

How to align text inside a cell in pandas

If I have a cell containing 2 characters and sometimes 3. I need to format the cell-like: <2spaces>XX<2spaces> and if contains 3 characters: <2s

Random access in a 7z file

I have a 100 GB text file in a 7z archive. I can find a pattern 'hello' in it by reading it by 1 MB block (7z outputs the data to stdout): Popen("7z e -so archi

Alexa: How to assign a slot response to a variable. (Python)

I'm not sure how to assign a slot to a variable in an Alexa skill. I've found several tutorials, but most of them are in JS (I wrote this code in Python) or out

Write to multiple worksheets

I need to write to multiple sheets with sheets name stored in a list. Below is my code for row_num, obj in enumerate(list,1): sheet = workbook.add_worksheet

How can I fix Intellisense issues with Python's openCV on vsCode

I am somewhat new to Python and I am starting to explore openCV and numpy for object detection. It's all going well and I understand it well, however I am using

Why does Tkinter image not show up if created in a function?

This code works: import tkinter root = tkinter.Tk() canvas = tkinter.Canvas(root) canvas.grid(row = 0, column = 0) photo = tkinter.PhotoImage(file = './test.g

N-dimensional array indexing with numpy

I have imported a cube in Python and I would like to index the cube but in 'k' axis (N and M are two integer numbers), and then cross it by a plane (b) in the

Tkinter button background color is not working in mac os

I am trying to change the bg color of a tkinter button on my mac (catalina) but instead of getting a colored background, it is showing a blank space in the layo

Strange result when removing item from a list while iterating over it [duplicate]

I've got this piece of code: numbers = range(1, 50) for i in numbers: if i < 20: numbers.remove(i) print(numbers) but the re

Just Typing "python --version" Causes Python to Crash

In the past, I have used python3 with no issues. However, after updating to the latest version of Mac Os, I am having issues. When I type "which python3" I get

Filtering out a foreignkey model out of a foreignkey model

Tryna filter all productimg objects of MainProduct but getting ValueError Cannot use QuerySet for "MainProduct": Use a QuerySet for "Product". but can't use slu

How to send data from a Python file to a GitHub pages html file to display

I want to start a project where you will input something in Python and it will appear on a GitHub pages html file. How would I do this? Would we be able to do t