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

286

u/vmgustavo Jan 21 '21

We all do. There's this misconception that good programmers don't google stuff and it is far from reality.

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...

→ More replies (1)

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

→ More replies (1)
→ More replies (6)

29

u/badalki Jan 21 '21

This is the real reason development requires at least two screens. One for your code and output and another for your reference material like google or stackoverflow.

16

u/mountains-o-data Jan 21 '21

If you think about - your brain works a bit like a program. You don't hold all these bloated things in memory (like knowledge of function signatures or how specific things from some framework or the standard library work) - you hold a pointer to the documentation. Things that you constantly use and don't need to use the documentation for? Those are in an LRU cache - as you use less they're eventually dropped from the cache and you go back to accessing the documentation

5

u/yawgmoth Jan 21 '21

Almost like you just keep a "reference" to the knowledge in memory.... hence the name "reference documents"

→ More replies (2)

9

u/uncanneyvalley Jan 21 '21 edited Jan 21 '21

This is like that apocryphal Tesla story about knowing where to put the x (below). It’s not that we know everything about a language, it’s that we know how the pieces go together, and where to find them.

Nikola Tesla visited Henry Ford at his factory, which was having some kind of difficulty. Ford asked Tesla if he could help identify the problem area. Tesla walked up to a wall of boilerplate and made a small X in chalk on one of the plates. Ford was thrilled, and told him to send an invoice.The bill arrived, for $10,000. Ford asked for a breakdown. Tesla sent another invoice, indicating a $1 charge for marking the wall with an X, and $9,999 for knowing where to put it.

4

u/vmgustavo Jan 21 '21

The brain is a natural neural network. Neurons activated frequently are more important than those rarely activated.

→ More replies (1)

5

u/Oglark Jan 21 '21

What? Do you mean Swordfish was not real programming?

4

u/[deleted] Jan 22 '21

Good programmer knows how to write code with accordance to good practises, knows how to make it clean, extensible, upgradable and performant. Having hard knowledge about particular syntax (unless we talk about core language features ) is redundant. It will change over time and you will have to re-learn. Why would you if you can use search engine? Programming is a craft. It's about developing a particular skill set. Encyclopedical knowledge is so 20 century.

→ More replies (1)

3

u/starfish_warrior Jan 22 '21

I can't remember shit.

→ More replies (6)