Project 2

You are working as Business Analyst in IJS Bank Limited. Currently your organization is working on Loan Applicant Clients for the current quarter. The Manager of the Branch asked you to analyze Loan Applicant’s data and to Present appropriate report on the shared data. The report should be demonstrated using Dashboard…

Company ABC Private Limited is manufacturing and selling below mentioned Products: Classic Cars Motorcycles Planes Ships Trains Trucks and Buses Vintage Cars As Business Analyst of the Company, you are required to perform following mentioned tasks on the provided dataset. a. Do proper formatting of the data with using…

This dashboard empowers mission driven organizations to harness the power of data visualization for social change. The data set talks about the literacy rates in Tamilnadu. It is distributed according to the cities and their ranks. It contains the population, as per the gender. This dashboard gives us the insight about…

This dashboard empowers mission driven organizations to harness the power of data visualization for social change. Women are tracked away from science and mathematics throughout their education, limiting their training and options to go into these fields as adults. The data set contains the data of women graduated by years,…

{ "cells": [ { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import matplotlib.pyplot as plt\n", "from sklearn.cluster import AgglomerativeClustering\n", "from sklearn.preprocessing import StandardScaler\n", "from scipy.cluster.hierarchy…

{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "from sklearn.model_selection import train_test_split\n", "from sklearn.preprocessing import StandardScaler\n", "from sklearn.linear_model import LogisticRegression\n", "from…

-- Q1. Create new schema as alumni-----CREATE SCHEMA alumni;USE alumni;SELECT * FROM college_a_sj;-- -------------------------------------------------------------------------------------------------------------------------------------------------------------------- Q3.Run SQL command to see the structure of six tables…

#1 created a new schema ecommerce #2 imported csv file use ecommerce;select * from users_data; #3describe users_data ; #4select * from users_data limit 100; #5select language, country from users_data ;select count(distinct country),count(distinct language) from users_data; #6select * from users_data;select gender,max(socialNbfollowers)from…

{ "cells": [ { "cell_type": "markdown", "id": "4b3c003f", "metadata": {}, "source": [ "# Project EDA on vechile insurance customer data" ] }, { "cell_type": "code", "execution_count": null, "id": "d1293be3", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1 2 3 4 5 6 7\n", "0 1.0…

{ "cells": [ { "cell_type": "markdown", "id": "5f8d9bbf", "metadata": {}, "source": [ "#1" ] }, { "cell_type": "code", "execution_count": 60, "id": "fa3b25f7", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Welcome to the Dictionary App\n", "Please select your choice\n", "1. Add a…