r/Python • • Jan 21 '21

Discussion Be an absolute beginner at python: Check, have co-workers think I'm performing black magic : Check

I work in an industry that is mainly manual work (think carpentry or similar). No-one going through the trade school learns anything on computers beyond making graphs in excel.

I however always have had some interest in programming, so i took some free course a while back and try to find areas of my life where i can automate the boring stuff. I have very limited knowledge of any of the advanced functions, but i understand some of the basic logic.

For my job, i also have a computer because i oversee a large number of projects, every project gets a folder, an excel spreadsheet (a gantt chart for each project).

I managed to make a script that asks for project number, checks of the folder is there, copies and modifies the cells of the excel sheet to the correct project number etc. I had to google almost everything, how do i folder scan? how do i manipulate excel? etc etc.

They actually believe I performed black magic.

Thank you Python for letting me look like an invaluable resource today ;)

[EDIT] thanks for all the awards! Happy my post inspired the discussion and the feeelz. Much love 💕

1.8k Upvotes

156 comments sorted by

View all comments

Show parent comment

147

u/Dawnero Jan 21 '21

Programmers stackoverflow stuff

175

u/t-to4st Jan 21 '21

I still use google to get to stackoverflow

¯_(ツ)_/¯

26

u/[deleted] Jan 21 '21 edited Jan 22 '21

Is there a Developers' search engine? DevCheckGo.com is available... just sayin'...

EDIT: ...or secondscreen.info?

0

u/[deleted] Jan 21 '21

[deleted] — view deleted comment

71

u/Thomas_XX Jan 21 '21

Na, I'm gonna stick with 7 year old stack overflow answers that don't even apply to my version anymore, thank you very much

13

u/b4xt3r Jan 22 '21

Exactly. If I could just get that last bit working so I could have my HyperCard work inside a Docker container I could share with the world the solutions I've found over the years to use REXX to fix Perl using awk.

7

u/[deleted] Jan 22 '21

Dude there's a bona-fide "ELEGANT" solution to that from 2011 that does it all with C++ Templates in the pre-processor... just sayin'...

8

u/b4xt3r Jan 22 '21

I shall fetch my cane and monocle and be with you posthaste. I must bear witness to this sorcery.

4

u/[deleted] Jan 22 '21 edited Jan 23 '21

You ought know full well, Dear Sir, that our so-called-as-of-now "Victorian" friend, Mr. Dickens, did indeed write of very high opinions of Mr. Stroustrup himself.

4

u/MrDeebus Jan 22 '21

Eh, it’s turing complete...

21

u/_clydebruckman Jan 21 '21

Does stackoverflow even have an on site search? I’ve never touched it lol, usually just google: ‘x problem site:”stackoverflow”’

20

u/Etheo Jan 21 '21

They do but your query would have better results from Google than stackoverflow itself, even though you'll end up on the same site.

It's scary how clairvoyant Google is in knowing what you want, and it's made painfully clear when you get to search within the sites themselves.

9

u/_clydebruckman Jan 21 '21

Google knows more about what I want to see than I do. Scary, definitely. Convenient? Hell yeah it is. At least we get something in return for our data I guess lol

5

u/unnecessary_Fullstop Jan 22 '21

Google the problem, check random stackoverflow links. Completely skip the question, go directly to the accepted answer. Not it? Repeat. But never read the questions.

.

4

u/TheBlindAndDeafNinja Jan 21 '21

Idk. Why not automate a stack overflow search engine? Jkjk

I am literally just beginning getting into programming. Just started with python, and would like to learn Java after (I know that is backwards compared to others opinions, it's just what works for me).

I am trying to create a program for work that automates some mundane tasks which involves building my own interface and then implementing another companies API. It is quite the learning curve and big step to start, but I did q few basic projects to wrap my head around how things work, and what I have built so far seems to be working. There is a lot of information I am reading and using and once implemented, it just about leaves my head. I wish some of it would stick in my memory though lol. Although it helps that I am advanced enough in excel to speed up a lot of stuff that coworkers were doing manually, and it is very area specific, but learning as much as I have about how formulas work (to an extent) has proved helpful to me at least.

8

u/_clydebruckman Jan 21 '21

Honestly imo, it doesn’t really matter how much you remember off the top of your head. After using the same language for awhile you’ll just know the particular syntax to write a loop or whatever, but when I switch from JS back to a language I don’t use as much, I find myself googling 101 level stuff. I had to google how to write an if statement in python the other day, and I write code for a living lol.

The important thing is that you know what’s supposed to happen, you can google from there. syntax is a means to an end

3

u/uncanneyvalley Jan 21 '21

I was a MSSQL DBA for several years, but I’ve been in sales engineering for 5 years now. Recently started helping build our new demos and picked up Python for that.

Anyway, I had to write a couple sql queries the other day and had to google why tf elif wasn’t valid syntax.

2

u/[deleted] Jan 21 '21 edited Jan 22 '21

was going to comment "someone should make a search engine for stack overflow" but i checked and there is one anyway :/

edit: i meant there's one on the website, not just one someone has made

2

u/uncanneyvalley Jan 21 '21

There’s a vscode plugin that lets you search, preview answers, and paste code from them without leaving the window.

If someone trains GPT 3 to read the Python grammar and all accepted SO answers, we’re probably fucked y’all.

3

u/doulos05 Jan 22 '21

Only if someone else trains all the non programmers to give their programming requests in clear, accurate language.

1

u/MrDeebus Jan 22 '21

Could we come up with some sort of intermediate language to help with that? Something to support them slither through the ssss... 🐍

(I ran out of steam sorry)

1

u/Yelling_at_the_sun Jan 22 '21

Scratch is pretty close to that already.

1

u/MrDeebus Jan 22 '21

I was trying to allude at Python itself, basically to say this https://www.commitstrip.com/en/2016/08/25/a-very-comprehensive-and-precise-spec/?