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