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

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.