Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

a. Worksheet - sales_data b. Worksheet - SALES SUMMARY c. Worksheet - Status summary d. Workbook  e. Worksheet - Quarterly Summary f. Worksheet - sales_data g. Worksheet - sales_data  h. Attached with Excel worksheet (Sales Data) Column AD i. Worksheet - sales_data j. Worksheet - sales_data

Project 2 - EDA on Vehicle Insurance Customer Data   Q 1 Add the column names to both datasets In [1]:     import pandas as pd import numpy as np import seaborn as sns import matplotlib.pyplot as plt   In [2]:   df1= pd.read_csv('customer_details.csv') df1   Out[2]:   0 1 2…

1A   1B   from tkinter import *import tkinter as tkimport sqlite3import tkinter.ttk as ttkimport tkinter.messagebox as tkMessageBox def database(): global con,cursor con = sqlite3.connect('books.db') cursor = con.cursor() cursor.execute("CREATE TABLE IF NOT EXISTS librarytable (bookname TEXT, author TEXT, yearofpublication…

2. 3.  16    

1.  2.  3. DESC users_data;SELECT count(*) from users_data;   4. SELECT * from users_data LIMIT 100;   5. SELECT COUNT(distinct country) as country,COUNT(distinct language) as language from users_data; 6. SELECT sum(socialNbFollowers), gender from users_data GROUP BY gender; We can see that the number of followers for…

UBER SUPPLY-DEMAND GAP EDA   Aim To identify the root cause(s) of the problem of cancellation of requests for taxis at Airport and City trips, and to recommend ways to improve the situation in order to improve the availability and reliability of the client's car services. This will involve analyzing the data and presenting…

COVID-19 Vaccinations Trend Analysis AIM The goal of this project is to research and analyze the global vaccination efforts for COVID-19, including trends and progress made towards preventing the spread of the disease. This includes examining the distribution and administration of vaccines, as well as any challenges or…

  File Attached   Please find link below:   https://drive.google.com/file/d/1RKaO9hNNRKqqT1ZA-7UQQX47CnQ8qEmS/view?usp=share_link