FacePALM | distributed Tweet clustering analysis on a cloud

Okay, so this is a question after the fact, and I just want to know what I should've done so I can avoid this problem in the future. Yes, I realize force pushing is a dangerous command. Yes, I realize git reset HEAD --hard can be a dangerous command too. Please help me avoid this problem that cost me ~4 hours of work today.

So here's what happened:

I had edited about 6 files on my current working branch. 3 of those files I wasn't ready to commit yet, so I staged and wrapped 3 of the files into a commit and pushed them to my remote. This left me with 3 unstaged files on my local that contained the bulk of my work.

Soon after pushing, I realized I made a minor typo in one of the files I had just pushed. So instead of adding another commit for the typo, I tried to amend my last commit and force pushed. I then received this error:

I have been struggling to get a Do/While loop using Range.Find and Range.FindNext methods to break out of an infinite loop. I have researched all of this and found the tons of duplicate questions asking generically "how do I stop the infinite loop?" but these do not answer the specific condition I am looking for since I do not want to simply stop the Do loop when the .find function finds the last iteration and returns to the first iteration found of the matching text (i.e. using Loop While Not testFind is Nothing And nxtAddr <> firstAddr type construct).

let's look at some data examples. I have roughly 8000+++ rows of data on any given file I'm working on. In the file, I'm searching for dates/times, specifying a date and specific hour (for example - "20210715 12" as my query):

...

I have these two endpoints (it's simplified but the idea/problem remains the same) ...

/api/v1/update

I installed Imagick through apt-get install. However the version it installed was old (6.9.7) and does not have all the delegates I need built in.

So I thought I uninstalled it using apt-get remove --purge imagemagick and reinstalled it from source.

Currently identify -version gives me the correct version I just installed (6.9.12) however php -r "print_r(Imagick::getVersion());" still shows v 6.9.7.

I wanted to know how to ban members on discord server using following command $ban and then name of the user I want to ban {member.name} and then the reason why he got banned. Also send the personal bot-message to banned user with the reason why he got banned (the reason I typed in console after {member.name}). And I was thinking about making this command in on_message because I write a lot of my commands there. I tried using this (not in on_message):

I am trying to send utf-8 symbols via serial device to browser and display them. I have found out when I print facepalm emoji 🤦‍♀️ (on windows 10 Win+.) it has U+200D and ♀ characters behind. Others emojis don't have that. I was using View non-printable unicode characters tool. Also I found, if you print it in notepad it will show you ♀, when you print it in browser address bar ♀ is invisible but if you press backspace you delete it. And finally, if you print it in some html text input, you can delete whole emoji with single backspace. Why is that?

i'm missing something simple here trying to add a new key/value pair and then add to the value of that pair as this loop goes on. this throws an undefined index error:

I have a help menu and some commands in it. There are some NSFW commands too and I want these commands to not show if the channel isn't marked as NSFW.

Here is my current code:

I got a dataset where yes / no variables all have been entered as free text (facepalm).

At first I tried to apply the fct_collapse function to every individual column in the dataframe, but this takes a lot of coding considering there are 50+ columns with yes and no.