This Project is the quick overview of converting the horizontal database into vertical database and making the readability of the data to simple and engaging way. In the way of transforming data, the database is cleaned according to the needs while maintaing the data integrity.
- melt() function is opposite of pivot function, which is one of the best function and saves a lot of time.
- merge() function is which is similar to sets, is one of the important function for joing the data as per our requirements.
![Data_Cleaning_Challange](https://private-user-images.githubusercontent.com/115963773/247163307-54050421-42f9-4f4c-a02d-aa3d3b2564b4.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQxMjU1MTgsIm5iZiI6MTcyNDEyNTIxOCwicGF0aCI6Ii8xMTU5NjM3NzMvMjQ3MTYzMzA3LTU0MDUwNDIxLTQyZjktNGY0Yy1hMDJkLWFhM2QzYjI1NjRiNC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIwJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyMFQwMzQwMThaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02N2NjYWM0ODM0MWFkMDA3MWQ1NzY1YzcxNjZlZjdkM2E3MjhjYjZkZGFjM2Y0NjA4MWVhYjc5NjcxOWVlZDY3JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.ri6RWELSyyF45N_6RotahELy2TMKdd7LOXzvIXbdrbo)