I know it is a fundamental question, but I couldn’t solve it. Any help will be appreciated My list1 has around 1059 values, list2 has around 7 values. I want to check values in list1 against values in list2, if matches append ‘x’ to list variable, if not matches append ‘y’ to sam…
Tag: python
psycopg update with unnest for a bytea column
I’m trying to update a lot of row in my database using unnest(). Here’s my db: Then I update the table with: But I got the following error: However, it’s working if I do a classic update. Any idea ? Answer Since your data is a 2×100 matrix, is better to partition it in vectors (1d array…
Find and replace no updating values
I’m writing a script that combine csv into one and then do a find an replace for specific formatting and ask the user to correct the ones that not match. The output is not on the right csv format It should be Answer This problems has a number of different parts, and you’ve made a good attempt :) I…
Error when retrieving nested list values in python
I have this as my code right now main.py: It returns the first list, but not the second one. Traceback: How do I fix this? Answer Found a fix: If the count is a multiple of 2, it is skipped (to prevent printing twice). If the count is equal to the amount of commands, the iteration is stopped.
gcp dlp python / how to reduce likelyhood when a column does not contain a string
I have a numeric client id to find. I created a custom info types : As expected, a lot of findings came out from the job and all with a very_likely likelyhood. To reduce the findings, I’d like to use hotwords in “reverse” mode : if there’s not the string “cli” in the column…
SQLAlchemy / mysql – How to insert data without calculated (computed) columns
I have a calculated (computed) column in a table and would like to insert rows with the calculated column not specified with SQLAlchemy. However, the SQL query for insert generated by SQLAlchemy includes the calculated column. Is there a way not to specify a column in this case? Please refer to the following.…
how to have re.sub work for multiple pattern replace on list of list?
I have a list of list input- old_list: my desired output – new_list: and I have tried 1. and replace(new_list, old, new) for … but none of them works, the output is the same as the original old_list. Any suggestions? Thanks! Answer You need to use output of each iteration as input for a next itera…
TypeError: argument of type ‘float’ is not iterable. Trying to find rows which doesn’t contain specific words in pandas dataframe
My dataframe looks like this(not exactly, but here is the sample): and I’m trying to find rows only have ‘word’ but without ‘not’ here is my code: and I’m getting this error: I don’t understand why I’m getting this error cause df3[‘WARNSIGN_DTL’] col…
Output sum rounded to the nearest even number using Python
I wish to take the sum of each row and round this value to the closest even number. Data Desired Doing I realize I have to incorporate i+i.mod(2) into this script, however I am not sure how to incorporate. Any suggestion is helpful. Answer here is one way to do it
ValueError: There is no such driver by url (chromedriver_mac64_m1.zip)
I’m running a script with Selenium but just a couple days ago I started to receive the error below: I’ve tried to do some research on GitHub back can’t figure out the error https://github.com/SergeyPirogov/webdriver_manager/issues/443 Answer Because google has changed the link to chromedrive…