This is a project I did as a fresher,where I explored the covid dataset.
- Data was taken from ourworldindata
- splited the data in Excel,used the basic concept in SQL.
- Exploring the data using the skills like Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types.
- Detected the spread of covid 19 which leds to 70% of population infected around whole world.
- Collected datasets about Movies with Budget,Gross and other details.Used thae basic of pandas for exploring,cleaning ,malipulating the data and numpy for working with arrays.
- Cleaned the data using python(jupyter) and used Correlation matrix for numerical features.
- For Data visualization used matplotlib,seaborn.
Created own dataset for food app solved some basic queries using the skills like joins,rank() over partition,basic Aggregate Functions
- collected IMDB movie rating data from a common website
- created a excel file to store the collected data