Skip to content

Ignore UserWarning from openpyxl using pandas

I have tons of .xlsm files that I have to load. Each Excel file has 6 sheets. Because of that, I’m opening each Excel file like this, using pandas: After each iteration I am passing the df to other function and do some stuff with it. I am using pd.ExcelFile to load the file into memory just once and the…

uwsgi can’t be installed

I’m stuck trying to install uWSGI to deploy my Django application using pip install uwsgi, but encounter this error: I’ve found several answers that unfortunately didn’t work for me, like update dev tool ,install cywin or modify uwsgiconfig.py (which doesn’t exist since it’s not …

Merging csv files in order of date created Python Pandas

I am merging 3700 csv files with a total of 10 million rows. The files do not have a sequential naming but the date in which they were created(Descending) is sequential. I use the following code to merge them but do not know how to add pick them in that sequence. The following are names of files arranged in d…

keep x rows and delete all from csv file

I want to be able to specify how many rows I want to keep and delete the rest, also preserving the header. I found some code which let’s you delete the first 5 rows but how can I make it do what I want? For example if I have this CSV I just want to specify a number to my

How to change list elements positions in a for loop in Python

I’m fairly new to programming and I’m really stuck in a problem. Say I have the following list: The list might contain more elements. What I need to do is change positions between “**” and “@”, so I would have I’ve been trying to do it with a for loop, using element i…

Draw contours around images of the same color with openCV python

I have this image with 3 channels RGB (a result of a VARI Index computation) and I would like to draw bounding boxes (rectangles) around the plants, represented in green here. What is the best and easiest way to do it with OpenCV / python? I guess it’s an easy problem for OpenCV experts, but I could not…