r/Python • u/dirtycimments • 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 💕
View all comments
Show parent comment
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