I haven’t found a similar question with a solution here, so I’ll ask your help. There are 2 lists, one of which is list of lists: As a final result I would like to split it by 2 separate lists of lists: I tried to create loops but I have nothing to share. Any ideas are appreciated. Answer You can
How to get data from matplotlib bar chart
How does one retrieve data programmatically from a matplotlib bar chart? I can do it for a matplotlib line chart as follows, so maybe I’m fairly close: for a bar chart, however, there are no lines, and I’m unclear what the equivalent object is: FWIW, here are a couple of related postings (that don…
Flask SQLAlchemy reflection ignoring most of tables on Redshift
I’m creating the engine and the Metadata as follows Yields AttributeError: packages, and dir(Base.classes) returns no attributes with that name, neither with the orders name. Taking the only=[‘orders’, ‘packages’] off makes it reflect only a few random tables. Now, when using the…
Is there a way to get directory package dependencies in python?
I am aware that pip freeze > requirements.txt exists, yet that that prints out my system packages, of which only a few my directory/ project needs. I am not using a virtualenv so I’m pretty sure I can’t print out local packages like that. I also know that pipdeptree exsists but I also don’…
Plot multiple graphs in matplotlib, setting labels and size of each graph
I want to plot multiple graphs in a matrix (4,2) and I want that the figures at the left side have their labels in their left side and the opposite for the right side. Additionally, when I plot them in Google Colab, the graphs are all squished together, so I would like to increase their size and the spacing b…
asyncpg.exceptions.DataError: invalid input for query argument $1: 217027642536 (value out of int32 range)
I’m working on a project that uses FastAPI alongside Pydantic and SQLAlchemy. I’m also using encode/databases to manage database connections. But for some weird reason, I get asyncpg.exceptions.DataError: invalid input for query argument $1: 217027642536 (value out of int32 range) anytime I try sa…
Python flask-sqlalchemy: Do I have to commit session after a query?
I am writing an app in python flask-sqlalchemy with MySQL DB (https://flask-sqlalchemy.palletsprojects.com/en/2.x/) and I am wondering if I have to make “db.session.commit() or db.session.rollback()” after GET call, which only query DB . For example: Answer orders = Order.query.all() is a SELECT q…
How to replace values in a np 2d array based on condition for every row
I have a numpy 2d array (named lda_fit) with probabilities, where I want to replace the probabilities with 0 or 1, based on the max value in each line. So after all the first line should look like [0,1,0,0], the second like [1,0,0,0] and so on. I have tried, and this works, but only for a given threshold (0.5…
How to use pandas to create a column that stores count of first occurrences on a group-by?
Q1. Given data frame 1, I am trying to get group-by unique new occurrences & another column that gives me existing ID count per month Expected output for unique newly added group-by ID values & for existing sum of ID values Note: Mar-2020 ID_Count is ZERO because ID 1, 2, and 3 were present in previou…
How do you identify which IDs have an increasing value over time in another column in a Python dataframe?
Lets say I have a data frame with 3 columns: ID column contains the ID of a particular person. Value column contains the value of their transaction. Date column contains the date of their transaction. Is there a way in Python to identify ID 1 as the ID with the increasing value of transactions over time? I…