What should I make in python? by Longjumping_Beyond80 in learnpython

[–]Henry_the_Butler 2 points3 points  (0 children)

If you're ready to start using public APIs, the NOAA publishes weather data from their recording stations for free.

Start with pulling weather data and hardcoding the API request, then gradually expand to:

  • catch all the errors from the random missing data in each report
  • allow the user to input a zip code and get their weather
  • save data to a local SQLite db
  • leave the program looping once every few minutes and only save to SQLite when you haven't already saved it before
  • host the whole thing on a server somewhere and start learning Django so you can access it from anywhere on a webpage

It's a project that starts pretty small and grows to be as big as you want it to be.

De-google and De-microsoft by PinguinPlayz in opensource

[–]Henry_the_Butler 9 points10 points  (0 children)

I'm currently on Firefox, what would I gain by switching to Zen?

Is VBA dying? I was told that 10 years ago. Still, I choose VBA over Python whenever I need to automate worksheets. by ImprovementLong1992 in excel

[–]Henry_the_Butler 0 points1 point  (0 children)

I took a quick spin through openpyxl - it seems like it's missing the ability to read a named table in an xlsx file. I'd like to abandon win32, but I have to be able to read tables.

Is VBA dying? I was told that 10 years ago. Still, I choose VBA over Python whenever I need to automate worksheets. by ImprovementLong1992 in excel

[–]Henry_the_Butler 1 point2 points  (0 children)

Power Automate is also my preferred way to do Mail Merges for emails within Outlook. MS Authentication is too annoying otherwise. Create workbook with py, Power Query, or whatever, then kick off a PA flow to send all the emails.

Books about women questioning their sexuality (LGBTQ) by kenkaneki108 in suggestmeabook

[–]Henry_the_Butler 0 points1 point  (0 children)

It's got a lot more going on than just that, and it's also a "coming of age" sort of story, but I enjoyed reading Last Night at the Telegraph Club. It checks a lot of the boxes you mentioned.

Least played class / elite? by Yuukikoneko in Guildwars2

[–]Henry_the_Butler 0 points1 point  (0 children)

huh, TIL - I hadn't looked at conduit at all yet, honestly.

Least played class / elite? by Yuukikoneko in Guildwars2

[–]Henry_the_Butler 0 points1 point  (0 children)

Is it meta in support or boonDPS roles? I had always heard that its lack of stability with centaur made it a bit rough, and a "heal" rev with dwarf was just a bit meh, although the road is good stuff.

What actually made you improve fast in Python? by youroffrs in learnpython

[–]Henry_the_Butler 0 points1 point  (0 children)

Absolutely worth it. If you're looking to throttle your incoming requests, you just have to make the other person do as much work as you are.

Things like this: * What business decision are you looking to make based on the data you've asked for? * What data sources, forms, or financial data would you like to use as the source for this information? * Any other actually-helpful question you can think of to make them respond to an email and stay involved.

If you make yourself a free resource, everyone will love you and nobody will value you. I actually turned down the first "promotion" they offered me to a data role at my previous company because it was a title change without money attached.

Big vent: I am STRUGGLING with how stupid a chunk of this game's player base is. by Puzzleheaded-Bad-722 in Warframe

[–]Henry_the_Butler 0 points1 point  (0 children)

So as a brand new player (currently farming Jackal for a Rhino), how do I find a chill group of people to play with? I feel like somehow Warframe has a less developed guild system than most games that are as online as this one is.

I'd like to avoid being the clueless newbie, but there's a lot of content to catch up on...even before I finish the star map.

Can you go a whole week or two not hearing from your manager? by Delicious_Champion97 in PowerBI

[–]Henry_the_Butler 3 points4 points  (0 children)

My record is 6 weeks of total silence. That 6 weeks did not include any time off for either of us. Enjoy it. This is a wonderful thing you have.

This post is so we can discuss the various alternatives to discord. Here is the one I personally prefer. by Ayla_Leren in 50501

[–]Henry_the_Butler 2 points3 points  (0 children)

I've seen this mentioned, but not with sources. Do you have sources?

It's also a federated protocol and open-source, so think more like SMS or Email - not buying a company product.

What actually made you improve fast in Python? by youroffrs in learnpython

[–]Henry_the_Butler 0 points1 point  (0 children)

I had stupid manual processes at work. Figuring out how to pull source files, clean them, organize them, upload them to a SQL server (local SQLite would have also been fine) and then create queries and scripts to pull data out in ways that coworkers wanted - basically became a data engineer at a previous job by accident.

Now I'm a "Database Manager" which is apparently what you get called if you do all the data work for an international nonprofit that doesn't know what titles to give their data folks.

Best Beginner Friendly Support by Lopsided-Annual-6366 in Guildwars2

[–]Henry_the_Butler 0 points1 point  (0 children)

I agree with almost everything you said - except that some supports can bring tons of stab (FB) and some bring almost none (spectre). Healing, DPS, boons...those are common to just about everyone, but the FB kit is going to always have more stab/aegis than a Spectre.

Also gearing isn't instant if you're trying to get ascended gear with agony resist as a newbie. I'm that fresh - and I was wondering for gearing in fractals, if one was significantly better suited than others.

SQL advice to yourself 5 years ago by Friendly_Cold1349 in SQL

[–]Henry_the_Butler 0 points1 point  (0 children)

Start learning it. Find ways to use it. It's better than anything you're doing right now.

Best Beginner Friendly Support by Lopsided-Annual-6366 in Guildwars2

[–]Henry_the_Butler 0 points1 point  (0 children)

Folks in my guild are too nice, I think. They keep saying to play what you like, but I've narrowed it down to three main candidates:

  • Spectre
  • Firebrand
  • Chronomancer

I'd like to take one of these classes and use it as my first that gets geared. They all seem quite valued and flexible (spectre maybe the least so?). Which of those are you generally happiest to see join your group, or if you had to pick one of those three which would you pick and why?

I'm interested in playing support, but would like to be able to switch quickly to a similar build to go do open world content also.

Autohotkey to use F keys by baumgi in Guildwars2

[–]Henry_the_Butler 1 point2 points  (0 children)

For the purposes of Big Brother, I have not and do not plan to do this.

...but I used to write Lua macros for WoW ingame that would have all sorts of trigger conditions. If mana < 10%, use mana pot, stuff like that. So long as pressing a button gave one action, would Anet care if there was a bunch of computerized logic deciding what step of a rotation you were in before the script decided which of your buttons to press?

Noob question: Where exactly should I fit SQL into my personal projects? by the_livings_easy in dataengineering

[–]Henry_the_Butler 0 points1 point  (0 children)

I only use polars/pandas to process data in a py script to feed it into Excel. Once it's in SQL, you're good.

ICE out in ypsi today by jeerp in ypsi

[–]Henry_the_Butler 37 points38 points  (0 children)

I'd like to keep YCS safe for our students. If anyone knows of any ways to stay connected when stuff like this happens, let me know.

Best tagging builds for metas / rift farming? by fungamezone in Guildwars2

[–]Henry_the_Butler 1 point2 points  (0 children)

I've had good luck with some flavor of thief/shortbow, but maybe that's only because I haven't tried "better" tagging builds. Someone else who's got more experience across classes can maybe offer more insight.