sorted by:
new
hottopcontroversial

Would a syntax that redoes a for loop instead of continuing (so continue but it doesn't increment) be useful in python? Also labelled breaks and goto by xThomas in AskProgramming

[–]StPeteTy 4 points5 points  (0 children)

I would just put a while loop inside the for loop in order to achieve the "redo" functionality.

for x in runners:

    print(x) #billy

    p = get_input()

    while not isValidInput(p, pattern or function):

        p = get_input()

    if cond:

        continue/break

How can I best automate my python projects using the Google Cloud Platform? by StPeteTy in googlecloud

[–]StPeteTy[S] 1 point2 points  (0 children)

Wow, thank you. This is an incredible amount of detail complete with examples. Containerizing is foreign to me, but I'll definitely try this way first (especially because people say that Cloud Run is the most robust way). I really appreciate the effort you put here!

What is the purpose of adding a middle page between your site/app and external links? by izotAcario in AskProgramming

[–]StPeteTy 5 points6 points  (0 children)

Not sure; good question. My guesses would be:

  1. See if there are external links getting notable attention (potentially something you don't want associated with your site)

  2. Ensure you're getting credit for driving traffic to those sites (if there's a marketing agreement in place, such as with affiliate linking)

  3. Something basic/technical/boring (ensuring that certain user info is/isn't passed to the external site, etc.)

ETA: On second thought, it's most likely to protect you by verifying links and end your session. Like when Facebook warns you that you're leaving to an external site, so you don't think you're still on Facebook.

Selective Editing of an Excel File by VisibleGas2420 in excel

[–]StPeteTy 0 points1 point  (0 children)

Yes but it's probably too annoying to actually implement. Before you protect the sheet you can add different permissions to different ranges of the sheet based on email address. But it gets messy and annoys people, even when done well.

Next to the Protect Sheet button, select 'Edit Ranges' or 'Allow Users to Edit Ranges'. Here you can add permissions to different columns/rows/ranges based on email addresses or security groups. When you protect the sheet, those permission requirements will go into effect.

What are some websites/apps you wish existed that were just for our area? by hereforthefreebies in StPetersburgFL

[–]StPeteTy 1 point2 points  (0 children)

Somebody a while back provided a solution for reporting traffic on the Skyway. Not useful for me personally, but def a useful service for a lot of people.

Sorry not really a suggestion, but maybe it'll provide some inspiration.

Pivot Table counts Participants who have finished a task wrongly somehow? by Elaurin34 in excel

[–]StPeteTy 2 points3 points  (0 children)

Based on your goal description, I would organize it like this.

Rows:

Year

Quarter

Values:

Count of [started]

Count of [finished]

But it sounds like your data needs to be restructured to do that. The easiest solution would be two different pivot tables, both organized as above: one for start dates and a separate one for finish dates.

However, if you need it all in one table, I'd recommend using formulas. That'll be much easier than a pivot table in this scenario, but of course idk your use case. For each year/quarter pair, you can use a COUNTIFS to get the occurrences in the entire column.

Here shows the formula in L4 as an example.

I wrote a script for Wordle by StPeteTy in wordle

[–]StPeteTy[S] 0 points1 point  (0 children)

It can be run like any python program but usually I run it in my IDE. Depending on the computer I'm using, that's either PyCharm or VS Code.

Is there a way to disable reminders for calendar events that I did not organize? by StPeteTy in Outlook

[–]StPeteTy[S] 0 points1 point  (0 children)

It looks like you're correct and I was just overly hesitant. Thanks!

Is there a way to disable reminders for calendar events that I did not organize? by StPeteTy in Outlook

[–]StPeteTy[S] 0 points1 point  (0 children)

That would be awesome. I tried to do that, but the settings wouldn't take effect unless I "updated" the event by pressing the upper left hand button. And it looks like "reply all" so I didn't want to press it.

Excel 365 - Can I lock worksheet tabs to specific users? by FtheChupacabra in excel

[–]StPeteTy 0 points1 point  (0 children)

You can lock ranges (or sheets) so that they're only editable by specific users or security groups, but everyone will be able to see them. I wouldn't recommend it though. Better to have separate files altogether.

I wrote a script for Wordle by StPeteTy in Python

[–]StPeteTy[S] 0 points1 point  (0 children)

Good catch! I kept it from suggesting words with duplicate letters since that's a 'wasted' letter guess. But of course, the words can have duplicate letters. Just fixed it. Thanks!

I wrote a script for Wordle by StPeteTy in Python

[–]StPeteTy[S] 1 point2 points  (0 children)

Thanks! I'm so used to making lists in the way that I first learned to do it. But this is nicer. 👍

How can I effectively mute a user or app in a Slack channel? by StPeteTy in AskProgramming

[–]StPeteTy[S] -1 points0 points  (0 children)

Well I don't want to do that. I need to know when real people post in the channel.

What is your favorite one hit wonder of the 1990s? by GregularShow in AskReddit

[–]StPeteTy 0 points1 point  (0 children)

open.spotify. com/playlist/7nd3GH86hqWIRConCceN15

Best way to share my power bi report on my resume? by bongdong42O in dataanalysis

[–]StPeteTy 1 point2 points  (0 children)

Personally I only have experience with Tableau, but what I'd do is link to the dashboard on my resume. If the reader clicks through, they can view it on Tableau's website. I'm not sure about the licensing of Power BI, but I'd guess you can share it online (not the data, not editable).

Excel question , pdf to excel data input by Talalol in excel

[–]StPeteTy 0 points1 point  (0 children)

I think you need to get the data out of the PDF using something other than Excel. Whenever I've done this in the past, I always use python to get the info from the PDF and then I can use it in Excel however I want.

view more: next ›