Python Forum

Full Version: simplify my excel work on python
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi guys,

I am currently working at a freight forwarding agency and my work requires a lot of calculations that I usually do on excel or manually. What I would like to know is if there is anyway to be able to create a python program that would facilitate my excel work. what I need is a program in which I can input a lot of data, get the result on different calculations and then save the file.
Example: Product name A B C D E F G H J
Amount in USD 10 20 30 40 50 60 70 80 90
Quantity 19 18 17 16 15 14 13 12 11
Numbers of colis 2 6 5 4 9 78 2 6 43 10
Calculations(output): Fret = sum Amount / Quantity
Cost per product = 10 / 19(product A) 20/18(product B) and so on until J
These are just examples of what kind of results I would like the python program to output.


Hope anyone would be able to refer me to any concept that might help. Thanks in advance. Cheers Big Grin
The answer is of course yes.
You might want to take a look at the types of packages (code libraries) that are available
for python here: https://pypi.python.org/pypi

You would be particularly interested in this package: https://pypi.python.org/pypi/freight-forwarder
and others here: https://pypi.python.org/pypi?%3Aaction=s...mit=search

And you can find complete applications (as well as more packages) here: https://github.com/explore
Are you willing to put in the time required to learn python?
It's fun to learn, and doesn't take a lifetime to learn.