r/learnpython • • Mar 07 '22

I finished my first python project. It feels amazing!

I work as an inventory analyst and I'm sure most of you in similar fields have experienced messy/ hard to use data. I consider myself pretty proficient at excel, but I've come to realize its limitations in the past four months (drive starting in analytics). There are a few reports that I needed to combine/perform some calculations on. I tried in excel, but it kept freezing. Over about 60,000 lines a simple A2/7 caused an unrecoverable freeze.

I said, "fluff it!". I then spent all day today working on this report.

I am now finished.

It feels really good to say that.

Thank you all for being so helpful to this community.

322 Upvotes

44 comments sorted by

78

u/cenosillicaphobiac Mar 07 '22

So now you face the classic dilemma, "do I show the bosses so that they think I'm awesome or do I STFU so they still expect it to take as long and spend that time on Reddit? "

I've gone both directions, depending on the situation.

44

u/adamantium4084 Mar 07 '22

Yea, I'm on the fence. The struggle is how bad do I want to feel appreciated?

On the flip side, the more I care about that, the more disappointed I'll be..

I definitely don't need more work. I may just shut up about this.

I'm pushing towards javascript anyways, so this is a transition job that got me out of a warehouse. Next job could be more than a year out though. So I'm not trying to make anyone in particular happy long term

33

u/mwpfinance Mar 07 '22

I'd stay mum about it for a while and reap the benefits of being productive. Then if you need another boost you could show off the automation later.

14

u/[deleted] Mar 07 '22

this is the way, make them think you got more productive, so they'll appreciate you, then after a while show them you made a tool so they appreciate you more, because to them it's like two separate "tasks"

1

u/kindaa_sortaa Mar 07 '22

Asking for a raise will let OP know how he should feel.

6

u/mrrippington Mar 07 '22

congrats on solving a real life problem. if I were you... I'd wait a while to and fully understand the quirks of your creation and make notes about how much this app/script could bring to the wider business.

then, ask your boss if they'd be interested in you developing something that automates the process. this will also show you basically what his reaction would be now if you go ahead and discuss with him.

2

u/edyshor Mar 08 '22

How would you go about finding out how much value the program/script adds to the wider business?

I've struggled with this for a long time, not understanding the value of my creation, I know it's about the metrics, but on how to collect and interpret them, I'm stumped.

1

u/mrrippington Mar 09 '22

+Well you just might have already be at a further point of understanding than myself regarding this, but I'll still share my general way of thinking.

Unlike people, business to me are made of money, everything that concerns a business' operation will ask for money in the hopes of returning some revenue(cups, employees, cupboards, hr, some training).

so look for ways how you can break down all components of a process (i.e. rate of skilled labour, time a task takes, impact of using such a resource at a this task (but not another task)). It goes without saying OP by automation have positively impacted their business in these areas.

Once you are satisfied about these components you can research/ estimate some avg values against those - but this I think is slippery slope as how can one accurately know exact missed opportunity of something? So apply grain of salt.

so I guess in summary (impact = time * rate of labour) could be a starting point to understand this.

Additionally note

  • this new application can have broader impact across other departments.

  • also once you develop an app which replaces manual labour, you introduce 'an asset' to the business IP.

p.s. sorry for the word salad, let me know if anything doesn't make sense and hope this helps.

5

u/Celestial_Blu3 Mar 07 '22

Sounds like you've just given yourself a bunch of free time at work to utilise to strengthen those programming skills. I'd stay quiet about it and use a few hours a day to do some programming

3

u/[deleted] Mar 07 '22

Don't tell. You owe what you say, you own what you keep.

I would not move to javascript unless absolutely necessary. I worked with Java for abut 15 years, javascript for about 3 and Python for about 4. Python is much better to work with data, and much nicer as a language. Also, Python is multithreaded, while JS is not.

2

u/Hateitwhenbdbdsj Mar 07 '22

Yeah like the other commentators I’d suggest not saying anything and using your extra free time to improve your skills or work on a side project. You can work the same hours but on your career growth and still get paid for it while having your own time after work

1

u/synthphreak Mar 07 '22

If said appreciation will not translate into greater pay or an increase in status, I'd go the STFU route.

14

u/OneMajor Mar 07 '22

Great. Hope you were able to learn from this project.

6

u/adamantium4084 Mar 07 '22

Absolutely did. Researching solutions has gotten way easier.

20

u/WhipsAndMarkovChains Data Scientist Mar 07 '22

Hopefully you haven't told your coworkers about this...

6

u/adamantium4084 Mar 07 '22

Should I not?? I have not though. Honestly though, my role is different than the other analysts. Most of them wouldn't benefit to be honest

9

u/[deleted] Mar 07 '22

Nah, you'd better not telling this to anyone. Just enjoy your freetime.. 😂

1

u/ontheroadtonull Mar 07 '22

I can only imagine that your reward for being more efficient will be more work without recognition of any kind.

8

u/AbuSydney Mar 07 '22

Congrats! But “fluff it” is a very weird expression. ;-)

10

u/adamantium4084 Mar 07 '22

My wife says I say the f-word more than anyone she's ever met..

1

u/Jaxper Mar 07 '22

Tell her to hang out with some nurses and she'll change her mind. My wife and her peers have no filter!

1

u/ianepperson Mar 07 '22

Are there many fluffy things in your life?

7

u/cienfuegos__ Mar 07 '22

Very cool! How did your solution look?

9

u/adamantium4084 Mar 07 '22

The end result allows me to see inventory decrementation over the product lead time. I'm dealing with lots of garbage inventory (clothing sizes that don't sell well) mixed with good inventory if the same style. This notebook shows me where inventory levels of SKUs will be at lead time landing. I filtered out lines that have excess inventory so that they don't skew the data. Some styles will look like they have a 52 week supply, but the core sizes are short and needed ordering.

I recently took over ordering for this vendor post lots of mistakes being made by previous analysts.

It's by no means fancy, but it gives me the right answer

1

u/cienfuegos__ Mar 07 '22

Fantastic :) Great job!

5

u/pythonTuxedo Mar 07 '22

Nice! This is similar to where I got my start on actual coding (vba).

3

u/adamantium4084 Mar 07 '22

It's not a bad place to start. Excel is a great way to learn a matrix model in a visually simple way.

2

u/esotericmegillah Mar 07 '22

Congrats! I love reading posts about automation. Python is such a powerful tool, I can’t wait to become proficient in the language.

Edit: not sure why I said automation, but I’m assuming it is somewhat automated…?

2

u/adamantium4084 Mar 07 '22

It keeps me from loading a massive (read slow) excel report and manually looking through figures that don't mean anything to me or tell me any real helpful info.

Definitely some automation involved.

4

u/PanTheRiceMan Mar 07 '22

When I started learning Python I had a Excel list sheet with roughly 1 million entries. That thing was genome data, so rather small for such data.

They actually tried working with excel. Which just caused a freeze on my computer. I wrote a script, automating the manual work. Which only needed a couple seconds.

Kind of crazy what people do just not to learn programming.

1

u/MustBeHuman Mar 07 '22

Hi I am an Supply Chain Analyst too, just starting out. Can you share the Notebook ? or a walk through maybe?

1

u/adamantium4084 Mar 07 '22

The notebook itself probably wouldn't be helpful. There's lots of contextual things specific to the company I work for.

The basics: Pandas data frames Pandas read excel Pandas merge on similar keys

I had to invert some data from a column to row values with a pivot table

Using conditionals to trim down the data.

1

u/Sad_Lengthiness_3802 Mar 07 '22

Congratulations I wish I could figure out where to begin on my so called project

1

u/adamantium4084 Mar 07 '22

That's the hard part. What to do that is actually useful to me and isn't a text based rpg or number guessing game. It took four months at this job to actually need it to accomplish a task

1

u/WhackAMoleE Mar 07 '22

I said, "fluff it!".

That word has a specific meaning. Better look it up. Not suitable for me to describe it on a family subreddit. Ok fuck it, a fluffer is an employee on the set of a porn shoot whose job is to get the male actors ... ahem ... ready to perform.

There was a thread on this subject just yesterday on TIFU.

https://www.reddit.com/r/tifu/comments/t7hhwa/tifu_by_not_knowing_what_a_fluffer_was/

1

u/adamantium4084 Mar 07 '22

Who says I didn't intend that? Contextually odd, I know.

5

u/WhatDaHellBobbyKaty Mar 07 '22

Don't tell a soul at work and let them marvel at your productivity.

2

u/Immigrated2TakeUrJob Mar 07 '22

I'm in data analytics and used VBA + python as well. Congrats.

1

u/TrailingCircles Mar 07 '22

Good job! Getting any program that successfully does what it needs to do is a good accomplishment.

1

u/rishavmehra Mar 07 '22

Great 👍

1

u/mm11wils Mar 07 '22

You should definitely tell your manager about it.

If they have no idea what you’re doing you should leave, you’re not going to learn or be challenged. Otherwise if they understand what you’re doing you should be continuously asking for feedback.

I was a pricing analysts that automated my reports to get 5 a week when the snr analyst was doing 1 every fortnight. I turned to my manager to show I’d done a binary search to improve performance, and they shrugged saying I have no idea what you’re doing