r/learnpython • • Feb 15 '20

Learning Python? Keep at it! It could change your life

Hi Guys,

Just a quick motivational speech as this week it has really paid off for me.

I've been learning python for around 6 months now and have found myself in the perpetual tutorial loop as I think most newbies find themselves.

But now I started a new job which allows the use of python and in the first week I took on a new task from my new boss.

Long story short, I took a task they allowed 3 weeks for the creation of (excel surveys to be used by internal team leads) and had it done in two days; around 15 spreadsheets are populated with 5 to 10 changing questions, and will require analysis thereafter.

They fully expected me to spend weeks putting together said spreadsheets and all their permutations, and email them out.

Instead I created a csv of all the data required and took the data and used python to generate the surveys, updating when changes happen in the back end.

The survey files are then formatted by openpyxl and spat out with a filename title as each team lead.

Any changes to the structure of the surveys mean just changing one or two lines of code, not going into every single file to make all the changes.

The script takes 0.75 seconds to run.

They allocated 3 weeks.

Needless to say, worth it, and everyone is happy!

So if you're stuck in tutorial hell, my advice is to find a work task to accomplish because I reckon I learnt as much in the past 2 days with this task as I have learnt in the past month.

Edit: meant to say, I was only able to get this reasonably high paying job because I told them I started learning python 6 months ago and will be using it to automate tasks.

Without that, I wouldn't have got it (about a 75 to 100% pay increase on my last job)

Good luck!

1.3k Upvotes

215 comments sorted by

View all comments

-4

u/pAul2437 Feb 15 '20

Yeah you gotta be extremely Lucky that your bosses are terrible with tech and the person whose job you are taking also was.

2

u/pw0803 Feb 16 '20

You've been downvoted for this but it isn't totally fair because indeed I am in a field where nobody knows programming, so yes, I stand out.

In a developer field I wouldn't register against those with decades of experience.

Pick your pond..

2

u/pAul2437 Feb 16 '20

I think you understand. Just have to make sure they know the value of your skills.

1

u/pw0803 Feb 16 '20

They do. I hit the jackpot..

1

u/pAul2437 Feb 16 '20

Care to disclose your position and salary?

2

u/pw0803 Feb 16 '20

Generic senior non leadership business title, should gross around 70k gbp including bonus.

I have other skills that got me this job though, that can't be seen as a reliable python only income.

2

u/subject_K81 Feb 15 '20

You can be good with tech and not know how to code anything. Also, bosses are there to delegate, not get their hands dirty. How many bosses at an oil company has turned a wrench, created a spreadsheet, looked at a ground survey, etc etc...

2

u/tashibum Feb 15 '20

Ha. I work in the oilfield currently. It is a fucking nightmare when the company men are engineers and know waaay more than you do. It's much harder to hide stuff!

1

u/pAul2437 Feb 15 '20

Sure you can. In this case they were neither.

1

u/Bendertheoffender69 Feb 15 '20

Dude most bosses are because they don't want to deal with it. There's very few that are tech savvy.

1

u/pAul2437 Feb 15 '20

True. But they also don’t recognize how much time/technical skills these things take.