I’ve been working with Tkinter and I’m trying to get different columns from different tables in my Treeview, I’m using SQLite as database, in my first table called registers i got different columns idcard, name, surname, cellphone, address, email, etc in my second table named attendance I us…
Python Pandas find rows that match a pattern using column first characters and a set of values to match
I have a sorted DataFrame by company_name: I would like to select the rows which have the first 3 letters in common and have the following rows ending with “u” or “w”. Ideally I would like the result to look like this (including the “main” name as an extra column). Assume t…
Google Earth Engine multiple filters on date
Using Google Earth engine API, I can filter the start and end date of a satellite data. In this code for example, I can retrieve ASTER information between January 1st 2018 to July 15th 2018. What I need to do, is to retrieve data between 2010 to 2020 but in summers only. Definitely, when I apply multiple ee.F…
get only information of a specific guild
Hey so this code works completely fine but my problem is that it gets info of all the servers that the bot is in. This code is for logs so I want it to have different logs for each server. For example, I don’t want to show a server that I’m not in if I changed avatar or anything. Any
how to import data from a excel list into a loop for a api python
I am connecting an API and everything is going fine, now I have one problem, I have a data excel list like this: Name Secondname Age alex test 2020-02-03 pieter guy 2020-04-04 in my script i have a variable called: name. Now i want to make a script that takes everyloop 1 line of data. so loop 1: ALEX TEST
Self-referencing many-to-many relationship with an association object in SQLAlchemy
I’ve found examples for a self-referencing many-to-many relationship with an association table. How can I achieve the same using an association object? The code below is based on: How can I achieve a self-referencing many-to-many relationship on the SQLAlchemy ORM back referencing to the same attribute?…
How do I make a crawler extracting information from relative paths?
I am trying to make a simple crawler that extracts links from the “See About” section from this link https://en.wikipedia.org/wiki/Web_scraping. That is 19 links in total, which I have managed to extract using Beautiful Soup. However I get them as relative links in a list, which I also need to fix…
Get all possible combinations between two lists, including multiple connections
With I get the 16 possible individual combinations of the lists l1 and l2, [(1,1), (1,2), … ] etc. Is there a way to also get combinations that ‘connect’ the lists in multiple ways? For example, I could have the following combinations [(1,1), (2,3)], [(1,3), (2,4), (3,2)], and [(1,2), (2,4),…
Is it possible to share a numpy array that’s not empty between processes?
I thought that SharedMemory would keep values of target arrays, but when I actually tried it, it seems it doesn’t. In the code above, the 2 processes can share one array(a) and access to it. But the value that was given before sharing(a[‘value’] = 100) is missing. Is it just natural or is th…
how do you set alpha vantage date as a column?
I am trying to plot data from Alpha Vantage. when I do I get: as you can see, ‘date’ is not on there. this is causing me problems when I start using mplfinance and matplotlib. Can anyone help? ps: my excel sheet looks like this date 1. open … 2021-02-03 243 2021-02-02 245 Answer Glancing at …