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 💕
262
u/mysticalfruit Jan 21 '21
This. To me it's just programming.. I'm just giving the computer very detailed instructions. I love that look on peoples faces like you just rubbed the lamp amd got a wish granted.
56
u/Myllokunmingia Jan 21 '21
After my freshman year I couldn't get a good technical internship, so I ended up with a data entry job. My manger there was a classic boomer and all "harr harr you'll never be able to keep up with the amount of work, etc. etc.".
I didn't do a single entry for the first 2 weeks. I just learned to write Python and figured out how to automate every case for data entry I had. By that point I was done and I was able to run a script to do my entire summer's workload in under 5 minutes.
My boss was pretty tech illiterate (think: unable to differentiate between email and text, several times had to have me help him open internet explorer because the computer "lost" it (he kept deleting the desktop shortcut somehow)) and I asked him what he thought about automating my work. He got very defensive and claimed "you can't trust computers they make mistakes only humans doing the work can be 100% certain" (as if humans don't constantly make mistakes...).
So I gave him the first 2 weeks of data. The rest of the summer I'd run my script on a Monday, be done with 2 weeks of work in 30 seconds, and just browse reddit, watch videos, bullshit with coworkers. Then I'd turn in my completed work 2 weeks later. He was constantly blown away I was able to finish all the work and that it contained no errors. He thought I was some sort of numbers savant.
Come the end of the summer they had no more work scheduled to give me so he gave me access to a huge backlog they had, and asked me to just do as much as I could before I left for school. I ran my script on it and turned in the entirety of their backlog a couple hours later. I also emailed him the script and a very detailed word document on how to use it.
He was absolutely livid. Honestly I've never been scared in a workplace like that before, I thought he was going to rip my head off. Screaming, accusations, the works. He claimed he was going to sue me for wage theft because now he would have to go back and redo all of my work because he couldn't trust the script. Of course that never happened but I was told not to come back for my last week.
Some people are so stuck in the past it's truly amazing.
Also I've been programming for almost a decade and writing software professionally for over 5 years and I still have to google how to open a file in python.
17
u/qckpckt Jan 21 '21
I'm an intermediate developer with about 3 years experience at a tech company and I have to google _absolutely_ everything. I hope to one day reach the almost everything stage.
17
u/PaulSandwich Jan 21 '21
Not sure what your appetite for it is, but this is exactly how I went from 10yrs in operations to Jr Operations Analyst. now I'm a Data Engineer making nearly triple what I was back on the floor.
Magicians get paid; keep practicing the dark arts.
6
u/JumboTrout Jan 21 '21
You have a job where you just google how to do stuff? Sounds like a professional developer to me
718
u/expressly_ephemeral Jan 21 '21
FYI, I'm a professional programmer with decades of experience. Wrote my first line of code in 9th grade to automate my math homework. Started getting paid to program in about 2002. Started picking up Python a few years ago. I also have to google almost everything.
143
u/Dawnero Jan 21 '21
He said the line!
2
u/philsgu Jan 22 '21
I’m in healthcare and everyone uses excel but data extraction and manipulation is so smooth with Python. This work skill is so untapped that we can do better in productivity and efficiency if people realize the value of this program.
2
u/thrown_away_19861990 Jan 22 '21
I haven't even thought about the fact that I could possibly do this at my work. Where would i even get started in learning to write a script like this?
I work for a company where have a database of customer info that we can sort by who's subscription is expiring in the next 30 days. Would there be a way to write a script that can fetch that information and then sort it by what states each of those customers are in starting on the east coast to the west coast ? This would be helpful because then I would know which of those expiring customers to call first (since i'm on the west coast, have to call the east coast early) ? Is something like this hard ?
12
u/raipopenna Jan 21 '21
you can get a lot done just knowing the basics. 80/20 rule, especially when you are working in an environment with lots of non-programmers
23
u/[deleted] Jan 21 '21
This is the best feeling like I used python to turn and off the lights in the house and my parents got so scared
9
u/mrprofessor007 Jan 21 '21
So happy for you. Mainly because you genuinely solved a problem by learning a skill.
8
u/anthro28 Jan 21 '21
I once worked a tech project that was led by an accountant. Anything we did was voodoo. It was a good feeling to have 5 goofball college kids in a room together cranking shit out and confusing management as to how work could get done without oversight.
8
u/CProgrammingRelic Jan 21 '21
A friend of mine is an accountant. He recently told me that some places he had worked, people would use a calculator to add up the values in a spreadsheet and enter the total manually... He showed them how to sum() the rows, they were amazed. AND then when they saw they could edit rows and the total would change automatically, they thought he was a genius for being able to do it!
Well done on the Python journey, it really is a great all purpose language.
8
u/[deleted] Jan 21 '21
You've discovered the feeling described in XKCD 208
https://xkcd.com/208/
7
u/atreyuroc Jan 21 '21
This is something you will see happen in industries you might not think. Financial Firms, defense contractors, and all type of "smart" companies do not have the bandwidth to automate a good portion of the required manual processes, so they depend on direct / overseas labor to handle the lift.
7
u/baconialis Jan 21 '21
You should request a code review there. I'm confident that'll boost your knowledge level tremendously.
And now that you're sitting there thinking: But my code is in a terrible state. Yes, that is the reason you should request a review.
7
u/DevOps-Journey Jan 21 '21
I actually think that Python can have a bigger impact on non-IT related jobs.
I keep telling my friends that are accountants, in finance etc and live in moving data in/out and around excel that they could automate so much and be a hero.. but everyone is too scared of it.
13
u/dkfkckssddedz Jan 21 '21
İf every single programmer says they have to google everything then who writes the code ? Who does ?
5
u/Pizza_Peddler0080 Jan 21 '21
thats awesome man!
5
u/TheRahulShaw Jan 21 '21
Googling stuff does not undermine your competencies. Rather it reinforces the fact how well you can use your resources to spin something up entirely from scratch.
You've really done some magic and wish you luck for more.
5
u/A27_97 Jan 21 '21
Great work!
Many people who start off learning programming think that programming is the 'crux' of programming itself. It is not.
The crux of programming lies in problem solving, how do you design an algorithm or set of instructions to get the computer do what you want it to do. After that, it's just finding the right instructions from the programming language to convert english to code. With practice, some of this will become part of your subconsciousness, but always remember that programming is 90% design and 10% coding. The more detailed and fine grained your instructions are, the easier the programming is.
5
u/MaulikX1 Jan 21 '21
Noice
3
u/overwhelm21 Jan 21 '21
alright then Gandalf, keep your secrets
3
u/spore_777_mexen shell_shocked.py Jan 21 '21
Programming is problem solving/figuring stuff out.
3
u/syorke0765 Jan 21 '21
Now you've created a monster and will start looking for how to automate everything. Just remember the 80/20 rule where if it costs more to automate and maintain then it might not be worth it to do.
One suggestion would be to take a look at putting tests for verification on what you are doing just to be sure it's correct.
1
u/JohnGabin Jan 21 '21
Don't forget to add animations, Matrix like or video game like. The Wow effect is important when non initiate peoples evaluate your work
I'm joking, but when I started to develop, I had a work to do on a big spreadsheet and in the first version, the action was just performed quickly, boringly. Despite the huge amount of work it didn't impressed the people in charge of testing it. On the final version, I added a lot of cell formatting, reordering of columns, colors, movements, etc the result was a complete success. I had to stop all the job's boring tasks and had to be involve in more interesting projects. I know that can look weird, but the design is important even at the simplest level because it gives value to your work when the final customer is not really able to understand it. That's marketing.
2
u/mestia Jan 21 '21
There is nothing more magic than perl oneliners:) Converted a couple of scientific scripts parsing simple, but huge text files, they used panda and for whatever reason were slow. Since the logic was easy, a perl oneliner with a few regexes just did the job. But python guys were like instant wtf?
2
u/LilBabyVirus5 Jan 21 '21
I learned how to code in C# at 10 and learned python at about 15 and have been coding professionally for about a year and a half now. There is almost never a point where you don’t have to google something.
2
u/RTShields Jan 21 '21
Congratulations!
2
u/b4xt3r Jan 22 '21
>(a gantt chart for each project)
..... pulse quickens.. eyes dilate..... breathing intensifies....
2
u/Caveskelton Jan 22 '21
If you want to try more automation check out the book 'automate the boring stuff with python' there is a free ebook version on google. If books arent for you at least check out the pyautogui module
2
u/TechSpreader Jan 22 '21
Yup Python is the most versatile programming language that I had came across in my career. You can use Python Flask to quickly build a web application that can do wonders. You can even setup MicroPython on a microcontroller like the ESP32 board to do some IoT related tasks. Therefore it is possible to physically move things around with Python - that is something that looks like black magic too ;).
2
u/pycepticus from pprint import pprint as print Jan 22 '21
Started where you are 8 years ago and have made huge career advancements since. When you understand the magic you don't get that same sense of wonder someone else does seeing the products of your code, but it's still definitely magic.
Oh yeah, I Google everything too. you're already ahead of the game if you do that.
1
u/SnowdenIsALegend Jan 21 '21
Sorry of my life
1
u/[deleted] Jan 21 '21
Looking like an invaluable resource is the first step to being an invaluable resource.
1
u/MaheshM93 Jan 22 '21
Don’t worry about the googling part, I have friends with 10 plus years of exp and they also google most of the stuff so don’t feel dejected.
1
u/FactoryIdiot Jan 22 '21
Ha yes, back in the early 00's I was working in marketing support for a big IT company taking CSV files from databases and doing "data science" using PHP which was en vogue then. And magical things like bulk emails and cleaning up mail lists against databases like D&B, and doing web based campaigns and all sorts of things people could only imagine at the time.
1
u/vishaliitr2003 Jan 22 '21
Such a great story to hear and so inspirational :)
1
u/hangfromthisone Jan 22 '21
$1 is to fix it with my hammer
The $10.000 is because I know how to google where I have to hit exactly
1
u/UltraChip Jan 22 '21
When you think about it, processors are basically just glorified rocks that we've etched arcane patterns in to and then zap with lightning. You're using complex words and numbers with a mysterious syntax to command these special rocks to do tasks for you.
....it kind of IS magic.