I would like to create a filter to replace values in a dataframe column based on a condition and also the values around it. For exemple I would like to filter values and replace then with NaN if they are superior to 45 but also the value before and after it even if they are… Read More Dataframe : replace value and values around based on condition

I have a form that has a hidden field with a value of "{UTMCode}". I want to find this value and replace it with data that I have stored in a variable. The IDs and classes on the fields are dynamic, so I can’t target by ID or class, but a default value can be… Read More How to Search and Replace with jQuery?

So, I have some text that looks like: <div class="content__main"> <p>This is some text<br> This is another line<br> Third line goes here<br> How about one more</p> </div> What I’d like to do is use JavaScript or jQuery to find the <br> tags and replace them with </p><p> tags. The content is auto-generated, so I can’t… Read More JS replace current tag with a new tag

In PowerShell, I’m looking to convert a SharePoint Location string (john_smith_domain_com) to the proper addressing of john.Smith@domain.com. I’m not sure which is the best way to go about doing this. I know $var.Replace("_",".") would work to replace all the "_"s with "."s, but that doesn’t help the "@" going between the name and the domain.… Read More PowerShell: Replace underscores with either a period or @ sign

I need to change the value of two random variables out of four to ‘—’. How do I do it with maximum effectiveness and readability? Code below is crap just for reference. from random import choice a = 10 b = 18 c = 15 d = 92 choice(a, b, c, d) = ‘—’ choice(a,… Read More How do I change 2 random variables out of 4?

I have Pandas DataFrame like below: df = pd.DataFrame() df["COL1"] = [111,222,333] df["COL2"] = ["CV_COUNT_ABC_XM_BF, CV_COUNT_DEF_XM_BF", "CV_COUNT_DEF_XM_ BF", "LACK"] df["COL3"] = ["LACK", "CV_COUNT_ABC_XM_BF, CV_COUNT_DEF_XM_BF", "CV_COUNT_DEF_XM_ BF xx"] df: COL1 | COL2 | COL3 ——-|——————————————|——— 111 | CV_COUNT_ABC_XM_BF, CV_COUNT_DEF_XM_BF | LACK 222 | CV_COUNT_DEF_XM_ BF | CV_COUNT_ABC_XM_BF, CV_COUNT_DEF_XM_BF 333 | LACK | CV_COUNT_DEF_XM_ BF xx …… Read More How to replace values in columns in DataFrame with staing coma if exists in Python Pandas?

I know that how do I remove a single word. But I can’t remove multiple words. Can you help me? This is my string and I want to remove "Color:", "Ring size:" and "Personalization:". string = "Color:Silver,Ring size:6 3/4 US,Personalization:J" I know that how do I remove a single word. But I can’t remove multiple… Read More How do I remove multiple words from a strting in python

I’m trying to inject some code into a file by using replace. The problem is if the target code contains any of the replace() function’s special character sequences, namely $$, it will do something different than what I expect, which is to just copy the characters exactly as they are. ‘replaceme’.replace(‘replaceme’, ‘$$’); you would think… Read More How to use javascript replace without triggering the special replacement patterns?

I have a dataframe with some NaN values like the one below and I would like to fill in the nan values in a column with random picks from the same column. e.g. randomly pick values from Col1 to fill in the NaN-values in Col1 Col1 Col2 Col3 Col4 Col5 0 -0.671603 -0.792415 0.783922 NaN… Read More Python: fill NaN in dataframe with random values picked from the same column

I have the following column of a multiple index tuple in this form: df_incumbent_Q.columns Which looks like this: MultiIndex([(‘Cust Linehaul’, ‘2022Q2’), (‘Cust Linehaul’, ‘2022Q3’), (‘Cust Linehaul’, ‘2022Q4’), ( ‘Load Number’, ‘2022Q2’), ( ‘Load Number’, ‘2022Q3’), ( ‘Load Number’, ‘2022Q4’)], names=[None, ‘Quarter’]) I am trying to combine the columns name so that I have something like… Read More Multi-index tuple join