dilemma | TTY selection prompt for Go programs | Command Line Interface library

I installed the python-kasa library to control TPLink smart home devices from my local server. while issuing commands from the command line is simple, I'm trying to execute them in Bash based on result of the query. My dilemma is purely my coding ability and I'm looking for a push in the right direction. what I would like to do is along the lines of the following syntactically incorrect mess:

Given following source code which need to be maintained within a class library project:

Context:
My data analysis involves manipulating ~100 different trials separately, and each trial has >1000 rows. Eventually, one step requires me to combine each trial with a column value from a different dataset. I plan to combine this dataset with each trial within an array using left_join() and "ID" as the key.

I want to mutate() the trial name into a new column labeled "ID". I feel like this should be a simple task, but I'm still a novice when working with lists and arrays.

I don't know how to share .csv files, but you can save the example datasets as .csv files within a practice folder named "data".

Out of sheer curiosity I would like to know how this quoting dilemma can be fixed. I already solved the issue by circumnavigating it (I added [vcodec!*=av01] to the -f argument and simply removed the --exec part entirely). Otherwise it only worked, when there were no spaces or minus signs in the --exec argument. The culprit line is the last and the issue is at the end with the --exec argument. You can ignore the rest.

Thanks for your help on the road to enlightenment! ;-)

I have a use case in which I need to create an AWS Glue Crawler to crawl some data stored in S3, start the crawler, then delete the crawler after it has finished crawling the data.

The dilemma I've ran into is that the crawler can take a significant amount of time to complete, sometimes taking 20-30 minutes to finish crawling the actual data before it can be deleted.

Initially I had intended to solve this with the AWSGlueAsyncClient, so that rather than blocking the calling thread for 20-30 mins, I could just write a callback so that when the crawler finished, it would immediately be deleted.

The issue with this is that if the server was to go down or be interrupted during this 20-30 minute window the crawler takes to complete, it would no longer get deleted.

What would be a good means to persist the crawler deletion step so that even if the server were to go down, it would still attempt to delete the crawler after it started back up again? A database seems like overkill.

I am currently stucked and confused with Flutter.

I have a FutureBuilder as below:

I am new to pandas and I am trying to carry out some EDA on my twitter dataset. Dataset column

Link to Dataset : https://www.kaggle.com/kaushiksuresh147/the-social-dilemma-tweets

Dataframe Sample : Sample dataframe

I want to filter new users created (from the user_created column) between "2020-09-08 and 2020-09-22" and then group the results with the sentiment column. I also want to count the total number of tweets created from this new users within that period and compare it with the overall number of tweets from other users which are not in the selected range(2020-09-08 and 2020-09-22).

I have tried an approach and my code keeps giving me the error message : KeyError: 'user_created'code snippet

I also tried this code which also gives me error message:KeyError: 'user_created'2nd code

I have created a simple program to collect some data from the internet by downloading a zip file and accessing its contents using Python.

The program downloads the zip file and extracts it using ZipFile.extractall(). Then I use Python open() method to read the extracted files.

I need the data to be collected daily, so I have pasted a shortcut of the original program in the startup directory, so that everytime I start my laptop, the program starts the execution.

On running the program using python IDLE, the program runs perfectly, without errors, as shown:

But when the program is being executed automatically on startup, the program is run as an .exe file, and gives me the permission denied error:

Using print() statements I have cornered the code which is producing the error:

I've been practicing with Oracle SQL Developer for some time using school assignments and encountered some kind of dilemma while doing the Entity Relationship Diagram for one of those, here's my issue:

On the assignment they mention that there's a CLIENT entity with certain attributes, and if this CLIENT is married, they'll ask for the partners_name, if not married, they'll ask for this person's date_of_birth. How would you approach this situation? Because I've been told that "there's no right answer", but I imagine that there must be a standard, or more popular way of solving these type of situations, and I imagined two options, which I'll show of course.

OPTION 1: So, I thought that maybe I can add both attributes to the CLIENT entity, and make them optional and having something like this:

My personal issue with this is that I'd be creating a situation in which both can be null, when they tell me explicitly that if CLIENT is married then assign partners_name, if not date_of_birth, it sounds mandatory for one or the other. I mention this option despite of what I just said, because I don't know if they actually do it anyways out there.

OPTION 2: Creating subtypes, one for a CLIENT that is single and another one for those who are not.

This does address the previous issue with date_of_birth and partners_name now being mandatory, but by doing this I'd be creating two more tables? (I haven't explored subtypes outside of Data Modeler, so I'm not sure of how this will translate into SQL Developer).

When I did this assignment I went with Option 1, but to this day I keep wondering if Option 2 would've been better, I do think that, but my concern is... Is it worth for this case to have two extra entities such as MARRIED and SINGLE? Which could mean two extra tables, considering that they only have one attribute. Is there another option that I don't see or know about? Maybe, I'd really like to hear opinions from people that know more about this and have seen way more cases than me.

NOTE: I did a bit of research as well, like trying to find PROS for the second option, this is what Oracle has to say about supertypes and subtypes at least. Also found this one, it's a bit similar I think, but not exactly, so I'd rather make my own question.

Thank you for your time everyone.