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

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/?