Create new schema as alumni ANS:- 2) Import all .csv files into MySQL ANS:- 3) Run SQL command to see the structure of six tables ANS- DESC college_a_hs;DESC college_a_se;DESC college_a_sj;DESC college_b_hs;DESC college_b_se;DESC college_b_sj; 6) Perform data cleaning on table College_A_HS and store…
Sushant Ovhal
updated on 09 Sep 2022
Project Details
Leave a comment
Thanks for choosing to leave a comment. Please keep in mind that all the comments are moderated as per our comment policy, and your email will not be published for privacy reasons. Please leave a personal & meaningful conversation.
Other comments...
Read more Projects by Sushant Ovhal (22)
Project 1 - Analyzing the Education trends in Tamilnadu
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,…
14 Nov 2023 01:32 PM IST
Project 1 - English Dictionary App & Library Book Management System
Project 1) English dictionary app and Library Book Management system
06 Nov 2023 04:04 PM IST
Project 1 - Implement and deploy CNN model in real-time using python on Fashion MNIST dataset
Implement and deploy CNN model in real-time using python on Fashion MNIST dataset
20 Dec 2022 07:04 AM IST
Project 2
Project 2
30 Nov 2022 11:41 AM IST
Project 1
Project 1
30 Nov 2022 05:44 AM IST
Project 2 - Supply and Demand Gap Analysis
Aim The aim of this project is to collect and analyze the data in detail of the Pickup point of the Airport and City Request id in Uber Request Data. Introduction Uber provides the 2016 data. By using this data find out the demand and supply Analysis gap of the cab. The main objective of this project is to analyze…
28 Oct 2022 01:16 PM IST
Project 1 - COVID-19 Vaccinations Trend Analysis
Aim The aim of this project is to analyze the data in detail on vaccinated people and fully vaccinated people by country in 2021-2022 Introduction Since the start of the COVID-19 outbreak, WHO has worked with countries and areas in Different regions on public health measures to slow or stop the spread of the virus. Safe…
28 Oct 2022 05:10 AM IST
Project 2
import numpy as np import pandas as pd import matplotlib.pyplot as plt from sklearn.cluster import KMeans from sklearn.manifold import TSNE from sklearn.linear_model import LinearRegression cardata = pd.read_csv('Cars_mileage.csv') print(cardata) HP MPG VOL SP WT 0 49 53.700681 89 104.185353 28.762059 1 55 50.013401…
18 Oct 2022 12:45 PM IST
Project 1
import numpy as np import pandas as pd import matplotlib.pyplot as plt import seaborn as sns auto= pd.read_csv("auto_clean.csv") print(auto) symboling normalized-losses make aspiration num-of-doors \ 0 3 122 alfa-romero std two 1 3 122 alfa-romero std two 2 1 122 alfa-romero std two 3 2 164 audi std four 4 2 164…
17 Oct 2022 07:43 PM IST
Unsupervised Learning - Kmeans Week 11 Challenge
1) How does similarity is calculated if data is categorical in nature Categorical data (also known as nominal data) has been studied for a long time in various contexts. However, computing similarity between categorical data instances is not straightforward owing to the fact that there is no explicit notion of ordering…
17 Oct 2022 01:44 PM IST
Supervised Learning - Classification Week 9 Challenge
1) What is a Neural Network? Neural networks reflect the behavior of the human brain, allowing computer programs to recognize patterns and solve common problems in AI, machine learning, and deep learning. Neural networks, also known as artificial neural networks (ANNs) or simulated neural networks (SNNs), are a subset…
16 Oct 2022 04:24 PM IST
Supervised Learning - Classification Week 8 Challenge
1) Apply knn to the “Surface defects in stainless steel plates” and identify the difference KNN is a simple algorithm, based on the local minimum of the target function which is used to learn an unknown function of desired precision and accuracy. The algorithm also finds the neighborhood of an unknown input,…
16 Oct 2022 08:54 AM IST
Supervised Learning - Classification Week 7 Challenge
1) Pros and cons of SVM SVM 1) SVM stands for support vector machines.SVM is simple and provides good accuracy with less computational power, SVM is also used for regression but is widely applied for classification projects. There are several hyperplanes possible to classify the data points, but the…
12 Oct 2022 04:50 AM IST
Supervised Learning - Prediction Week 3 Challenge
1) Perform Gradient Descent in Python with any loss function Gradient Descent Gradient Descent is an optimization algorithm used for minimizing the cost function in various machine learning algorithms. Gradient descent is an optimization algorithm that is commonly used to train machine learning models and neural networks.…
09 Oct 2022 07:24 AM IST
Basics of Probability and Statistics Week 1 Challenge
1) Why there is a difference in the formula of variance for population and sample Ans:- The sample variance is an estimate of σ2 and is very useful in situations where calculating the population variance would be too cumbersome. The only difference in the way sample variance is calculated is that…
07 Oct 2022 03:52 PM IST
Project 2 - Gender Bias in Science and Technical field
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…
04 Oct 2022 12:43 PM IST
Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Project 2 Excel file due to large file size the file is not uploaded.because of that, I submit the screenshot of each question.please accept the screenshot of the answer.
19 Sep 2022 05:45 AM IST
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
13 Sep 2022 09:10 AM IST
Project 2
Create new schema as alumni ANS:- 2) Import all .csv files into MySQL ANS:- 3) Run SQL command to see the structure of six tables ANS- DESC college_a_hs;DESC college_a_se;DESC college_a_sj;DESC college_b_hs;DESC college_b_se;DESC college_b_sj; 6) Perform data cleaning on table College_A_HS and store…
09 Sep 2022 07:22 AM IST
Project 1
PROJECT 1 ECOMMERCE USE ecommerce; -- Question 3DESC users_data; -- Question 4SELECT * FROM users_data LIMIT 100; -- QUestion 5SELECT COUNT(DISTINCT country)Distinct_value_country,COUNT(DISTINCT language)DIstinct_value_language FROM users_data; -- Question 6SELECT gender, SUM(socialNbFollowers)max_users FROM users_data…
01 Sep 2022 08:49 AM IST
Project 2 - EDA on Vehicle Insurance Customer Data
1.Question¶ import pandas as pdimport numpy as np 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 Licence Present','Region Code','Previously Insured','Vehicle age','Vehicle Damage'] Customer_Policy.columns=['Customer_id','Annual…
20 Aug 2022 01:11 PM IST