Back ArrowExplore all kits

Product Inventory Project using Pandas

share link

by Abdul Rawoof A R dot icon Updated: Feb 21, 2023

technology logo
technology logo

Solution Kit Solution Kit  

We're trying to make a simple python program where we must Create an application that manages an inventory of products. To create a product class with a price, id, and quantity on hand and then create an inventory class that keeps track of different products and can sum up the value of an inventory. 


We are using the Pandas library to create a product inventory. This library provides fast, flexible, and expressive data structures, making working with relational or labeled data easy and intuitive. It aims to be the fundamental high-performance building block for real-world data analysis in Python. It allows us to store and manipulate tabular data in rows of observations and columns of variables and extract valuable information from the given data set. It offers various data structures and operations for working with time series and numerical data. This library is developed on top of the NumPy library, which supports multi-dimensional arrays. It is quick and offers users high -performance and productivity. 


Advantages of Pandas: 

  • Data representation. 
  • Handles large data efficiently. 
  • It makes data flexible and customizable.  
  • Lesse is writing more work. 


Here is an example of how to create product inventory using Pandas: 

Fig : Preview of the output that you will get on running this code from your IDE.

Code

In this solution we're using Pandas library.

Product Inventory project using pandas

PythondotLines of Code : 59dotLicense : Strong Copyleft (CC BY-SA 4.0)

Dependent Libraries : 
import pandas as pd

class Product(object):
    def __init__(self):
        self.price = None
        self.id = None
        self.qty = None
        self.data = pd.DataFrame(([]),columns=['ID','Cost','Quantity'])

class inventory(Product):
    # create a prod_detail function
    def prod_detail(self):
        print("Please give your product details,")
        self.cost = float(input("Cost of the product : "))
        self.id = int(input("ID of the product : "))
        self.qty = int(input("Quantity of the product : "))
        print("="*30)
        self.data = self.data.append({'ID':self.id,'Cost':self.cost,'Quantity':self.qty},ignore_index=True)
        print(self.data)
        print("="*30)
        self.option()
    # create an options function
    def option(self):
        print("1)Would u like to add even more products?\n2)Get the inventory value\n3)Exit")
        option = int(input())
        if(option == 1):
            self.prod_detail()
        elif(option==2):
            print("The total value of inventory is : ",((self.data['Cost'])*(self.data['Quantity'])).sum())
            self.option()
        else:
            print("Exiting....")
            exit()

    def value(self):
        # remove the while true loop and just run the prod_detail function
        self.prod_detail()


inv = inventory()
inv.value()

Please give your product details,
Cost of the product :  1
ID of the product :  2
Quantity of the product :  3
==============================
    ID  Cost  Quantity
0  2.0   1.0       3.0
==============================
1)Would u like to add even more products?
2)Get the inventory value
3)Exit
 2 <--------
The total value of inventory is :  3.0
1)Would u like to add even more products?
2)Get the inventory value
3)Exit

Instructions

Follow the steps carefully to get the output easily.

  1. Install pandas on your IDE(Any of your favorite IDE).
  2. Copy the snippet using the 'copy' and paste it in your IDE.
  3. Add required dependencies and import them in Python file.
  4. Run the file to generate the output.


I hope you found this useful. I have added the link to dependent libraries, version information in the following sections.


I found this code snippet by searching for' how to create product inventory project using pandas' in kandi. You can try any such use case!

Environment Tested

I tested this solution in the following versions. Be mindful of changes when working with other versions.

  1. The solution is created in PyCharm 2021.3.
  2. The solution is tested on Python 3.9.7.
  3. Pandas version-v1.5.2.


Using this solution, we are able to create an product inventory project using pandas with simple steps. This process also facilities an easy way to use, hassle-free method to create a hands-on working version of code which would help us to create an product inventory project using pandas.

Dependent Library

pandasby pandas-dev

Python doticonstar image 38689 doticonVersion:v2.0.2doticon
License: Permissive (BSD-3-Clause)

Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more

Support
    Quality
      Security
        License
          Reuse

            pandasby pandas-dev

            Python doticon star image 38689 doticonVersion:v2.0.2doticon License: Permissive (BSD-3-Clause)

            Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more
            Support
              Quality
                Security
                  License
                    Reuse

                      You can also search for any dependent libraries on kandi like 'pandas'.

                      Support

                      1. For any support on kandi solution kits, please use the chat
                      2. For further learning resources, visit the Open Weaver Community learning page.


                      See similar Kits and Libraries

                      Open Weaver – Develop Applications Faster with Open Source

                      kandi

                      Community and Support

                      Company

                      Follow

                      • © 2023 Open Weaver Inc.