r/learnpython • u/adamantium4084 • 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.
23
14
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
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
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
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
5
u/WhatDaHellBobbyKaty Mar 07 '22
Don't tell a soul at work and let them marvel at your productivity.
2
1
u/TrailingCircles Mar 07 '22
Good job! Getting any program that successfully does what it needs to do is a good accomplishment.
1
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
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.