Project 2 - Supply and Demand Gap Analysis

1. Add the column names to both datasets: i. Column Name for customer details table: cd = (cd.rename(columns = {'0' : 'customer_id', '1' : 'Gender', '2' : 'age', '3' : 'driving license present', '4' : 'region code', '5' : 'previously insured', '6' : 'vehicle age', '7' : 'vehicle damae in '} ))   ii. Column Name for…

1A: English Dictionary App : def display(): print('''Main Menu \n 1. Add a word \n 2. Find the Meaning \n 3. Update a word \n 4. Exit \n ''') import json d = {} display() while True: choice = int(input("Select from Main Menu (1,2,3,4) : ")) if choice == 1: word = input("Enter a word : ") meaning = input("Enter the meaning…

  Title: Literacy Rate in Tamilnadu  

1. A pie graph of women in Biological Scientists, Chemists & Materials Scientists, Computer & Mathematical Occupations, Engineers & Architects   2. The trend of percent women graduating in Computer science and Engineering from 2000-2015   3. A bar graph of what percent of women are in stem jobs by…

1. create database alumni;   2. show tables;   3.   desc college_a_hs;  Field Type Null Key Default Extra RollNo text YES       LastUpdate text YES       Name text YES       FatherName text YES       MotherName text YES      …

1. Create new schema as ecommerce  create database ecommerce;       2. Import .csv file users_data into MySQL(right click on ecommerce schema -> Table Data import Wizard -> Give path of the file -> Next -> choose options : Create a new table , select delete if exist -> next -> next)…

Aim: - The aim of this project is to analyse the customers based on the products they brought To improve the sales of the super market Analyse the branch improvements   Introduction: - A supermarket is a self-service shop offering a wide variety of food, beverages and household products , organized into sections.…

The Detailed Documentation of the Project should contain: Aim    The aim of this project is to analysis the vaccinated and non-vaccinated peoples in entire world.   Introduction The covid -19 is a virus it has spread to entire world. To overcome the threaten of this virus, World Health Organization…

Google Drive link for the attachment https://docs.google.com/spreadsheets/d/1dhzqr592VFYPxflhAuPIIu6Prh6XZSmH/edit?usp=sharing&ouid=117357878417282517095&rtpof=true&sd=true     Gender Ratio of Applicants       Car Owner/ Non-Owner Ratio          …

A.   B. Row Labels Sum of SALES Average of SALES StdDev of SALES Var of SALES Max of SALES Min of SALES Classic Cars 3919615.66 4053.377104 2050.694132 4205346.422 12001 640.05 Motorcycles 1166388.34 3523.831843 1837.292757 3375644.674 11886.6 651.8 Planes 975003.57 3186.286176 1519.539168 2308999.282 10066.6 875.91 Ships…