In project 1 A: Define main menu function to get choice from user., such as Add a word, find meaning of word, update a meaning of word and exit. I have define various function to perform operation according to entered choice. I have used concept of file handlig, serialization(json), dictonary method, string method etc..…

During this project I have used following techniques for EDA on vehiccle insurance data. 1. Load csv file into python, different method for edit data frame. 2. Handling a missing values in proper way. ex- For numerical data missing value is replces with mean and For Categorical data missinng value is replced with mode.…

In this project following aspects i have used 1. Import CSV file into MySQL  2. Where clause, Group By, Order By, Aggregrate function, Joins etc...

By completion of Project 2. I have used almost all concept which are taught in class. Like 1. Work with Data base (Create,Insert,Update,Delete etc..) 2. Import CSV file into MYSQL. 3. Create View and Stored Procedure. 4. Mysql For Excel 5. work with Data base of Mysql with Python Jupyter Notebook

Tableau Public access link: https://public.tableau.com/app/profile/dax.patel/viz/Project1_WomeninSTEMFields_/Dashboard1?publish=yes  

Dashboard access link: https://public.tableau.com/app/profile/dax.patel/viz/LiteracyrateinTamilnadu/LiteracyRateinTamilnadu?publish=yes  

I have attached Excel workbook for the Project-1 Solutions In which For Q-A,B,F,G,H,I,J Performed in Master Data Table only and  For Q-C,D,E I have made seperate sheet.

https://drive.google.com/drive/folders/1_7aIkEYE6RwKaZuCUvfMVGZ9_EBKADbw?usp=sharing Please go through this Google drive link where I have Uploaded Project 2 of Excel. 

For this project submission I have attached Power BI file, Word file, PDF file.

I have attached Word, PDf and Power BI file for this project submission