Project 1

Summary of what i did: Loaded and pre-processed country-level data, separating out country names and standardizing the features. Applied PCA to reduce dimensionality and visualize explained variance and 2D projections. Performed K-Means clustering to group countries based on development indicators. Conducted Hierarchical…

Summary of the project: Loaded and explored clinical data related to heart disease from an Excel dataset. Preprocessed the data, including feature scaling and train-test splitting. Applied five machine learning models (Logistic Regression, KNN, SVM, Decision Tree, Random Forest). Evaluated model performance using accuracy,…

1. Display the data of white wine and red wine: Assuming the dataset in a pandas DataFrame (df), filter the white and red wines as follows: white_wine = df[df['type'] == 'white'] red_wine = df[df['type'] == 'red'] print(white_wine) print(red_wine) 2. Get the size of both white wine and red wine: get the size of each dataset…

1. Explain the data. Check if it is supervised or unsupervised. Demonstrate: Explanation: The data contains information about individuals, including: Age, Sex, BMI, Children, Smoker, and Region as independent variables (predictors). Expenses as the dependent variable (target), which represents the insurance charges. Supervised…

Please Check file Uploaded 

Please check the file attached

This project involved developing two distinct applications using Python with a GUI interface. The English Dictionary App allows users to search for word definitions, synonyms, and antonyms, providing an interactive, user-friendly experience. The Library Book Management System facilitates tracking and managing books, allowing librarians to add, update, issue, or return books with ease. Both applications were built using Python's Tkinter library for the graphical user interface.

 Create a macro for conditional formatting & freezing panes In My Excel without using specific functions like Unique, Filter and Sort. Here's a theoretical answer: Data Setup: Start by organizing data, with each row representing a client and columns containing information such as client name, gender,…

I have learnt to change the data formatting such as borders, font size, font color, alignment etc.

In this week, how to create KPI and create dashboard with better formatting In this project, the data shows that the literacy rate in tamil nadu in detail.

In this project, i have learnt to create a pie graph How to insights the data effectively  How to do formating in dashboards  In this project the data shows that, women are far less likely to graduate with stem degree or enter a career in stem compared to their male counterparts. Female students and employees…

In this project, i have learnt to do challenging queries connecting with python and MS Excel Learnt to perform data cleaning in MYSQL  Learnt to analyse the student data from two different college Learnt to create pivot chart in MS Excel for better understanding the data.

In this project, i used the concepts of week-1 to week-6  Created database of named 'ecommerce' which contains the data about e-commerce platforms Created model which helps growing fast with e-commerce platforms where sellers may be required to pay some amount and buyer can buy it without paying anything. E-Commerce…

In this challenge , i learnt to open csv file and create dataframe in jupyter notebook. Learnt to check the data quality by droping null values, checking for outliers, and replacing the null values and outliers with a suitable value. Learnt to fetch the required data by using different attributes  Also, known to check…