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

Aim: The objective is to identify and analyze the problems in Supply-Demand of Uber trips from City to Airport and vice-versa across various hours of the day and find out possible solutions to address the problem. Problem Statement: Uber is an app-based transportation network and taxi company. In its Airport rides in a…

Project 1 COVID-19 Vaccinations Trend Analysis Power Bi Saurabh Srivastava  The Detailed Documentation of the Project should contain. Aim: - This project aims to analyse data in detail on vaccinated people and fully vaccinated by year and country. Introduction: - The main objective of this project is to…

Project Link - https://public.tableau.com/views/LITERACYRATEINTAMILNADU/Lite_racyrateDashboard?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link

Project link - https://public.tableau.com/views/WomeninSTEM_16732034625170/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link

 PROJECT LINK - https://drive.google.com/drive/folders/1513SMxBj0xNSejCMWm0REczjwQkju7gR?usp=share_link

a. Do proper formatting of the data with using borders, font size and appropriate alignment of the content. b. Make summary of Products Sales by providing Make worksheet from the given Data for categorical representation of table based on fields Status, ProductLine and Sales using Pivot Table.  Make Customized Ribbon…

#Question1 CREATE DATABASE alumni ;USE alumni ; #Question3DESC college_a_hs;DESC college_a_se;DESC college_a_sj;DESC college_b_hs;DESC college_b_se;DESC college_b_sj; #Question4 --Respective Python File is attached import mysql.connector testdb=mysql.connector.connect(host="localhost",user='root',password='Saurabh@123',database='alumni')testcursor=testdb.cursor()testcursor.execute("SELECT…

#Project 1#Create new schema as ecommerceCREATE DATABASE ecommerce ; #Run SQL command to see the structure of tableUSE ecommerce;DESC users_data; #Run SQL command to select first 100 rows of the databaseSELECT * FROM users_data LIMIT 100; #How many distinct values exist in table for field country and languageSELECT COUNT(DISTINCT…

import pandas as pd customer_detail=pd.read_csv("customer_details.csv")customer_policy=pd.read_csv("customer_policy_details.csv")customer_detail.columns=["customer_id","Gender","Age","Driving License Present","Region Code","Previously Insured","Vehicle Age", "Vehicle Damage"]customer_policy.columns=["customer_id","Annual…

#ENGLISH DICTIONARY APP import json print("Welcome to the Dictionary App")print("1) Add a Word")print('2) Find a Meaning')print("3) Update the Word")print("4) Exit") f=open("words.txt","w")d={}json.dump(d,f)f.close()while True: choice=int(input("Enter Your Choice")) if choice==1: f=open("words.txt","w") word=input("Enter…