ETG-IMS-ASSIGNMENT

This repository contains multiple functions and JSON files for inventory management system AND Summer Olympic Data Analysis.

IDE USED IS VSCODE Jupyter Notebook
FOR IMS To download working code only download Final Function folder

Working of code is as follows:

1.RUN ALL THE CELLS OF THE CODE EXCEPT In[42] and In[43] if want to see precious transactions else new transactions will be available in the SalesRecord.json and PersonRecord.json

2.After In[48] cell is there a sample to show the working of the code after step 1 is followed.

3.filename(as parameter in function) are the names of the JSON files.

STEPS TO PERFORM A SINGLE TRANSACTION

1. Perform step 1 from earlier
   
2. check=readfile("records.json")
   
3. display(check)
   
4. purchase(check)
   
5. GenerateReceipt("PersonRecord.json")
   
6. GenerateSalesRecord("salesRecord.json") #This will show sales done till that time,max sold product till that time,total sale value till that time.
   
7. IF YOU WANT TO SEE HOW INDIVIDUAL FUNCTIONS ARE WORKING THEN THERE ARE NOTEBOOKS IN INDIVIDUAL FUNCTIONS(INDEPENDENT OF OTHER FUNCTIONS).
   

**To see working of each individual Function also download INDIVIDUAL FUNCTIONS folder**

#INDIVIDUAL FUNCTIONS

1. AddInAlreadyCreatedJSON.pynb: This is to add a new record in already existing record.json file.
   
2. CreateNewJSON.ipynb: This is to create a new record.json file from scratch and add all the records in the inventory from zero.
   
3. Display.ipynb: This is to display all the records of the records.json file.
   
4. GenerateReceiptIndividual: This is to generate the receipt for the products customer bought and also record it in personrecords.json file.
   
5. MaxSoldProduct.ipynb: This will return details of the max sold product.
   
6. RemoveFromInventory.ipynb: This is to remove record from inventory having values <=0.
   
7. SalesRecordIndividual: This will record all the purchases in salesrecord.json file.
   
8. purchase.ipynb: This is just earlier version of GenerateReceiptIndividual.
   
9. Person Records JSON File will have the records of Customer buying things from store.
   10.Records JSON file will have Records of the items available in the Inventory.
   11.Sales Record JSON will have all the records of the items sold in a day.
   

#Final Function
1.Person Records JSON File will have the records of Customer buying things from store.
2.Records JSON file will have Records of the items available in the Inventory.
3.Sales Record JSON will have all the records of the items sold in a day.
4.Having All In One notebook have all the functions to access and modify the JSON Files.

NOTE:RUN THE CELL SALESRECORDS={} AND PERRECEIPT={} ONLY ONCE AS IT WILL EMPTY THE RECORDS AND ALL THE PURCHASE RECORDS MIGHT BE LOST IF CREATEFILE() FUNCTION WASN'T CALLED TO STORE IT IN LOCAL FILE

Having all in one file is attached below:

HavingAllInOne.pdf

SUMMER OLYMPIC DATA ANALYSIS 1.CSV FILE Having data for analysis. 2.Notebook for the small analysis having questions and their answers(code lines) 3.Some plots to show the data visually.

TO SEE WORKING DOWNLOAD SUMMER OLYMPIC AND RUN THE IPYNB FILE

IF PANDAS LIBRARY IS NOT INSTALLED THEN IN VSCODE Enter ctrl + ~ command then pip3 install pandas or pip install pandas(whichever is their).