As we know data can be really messy in real world. However, we can use some methods to merge data. This will be a quick lesson but efficient.Before we started to data analytics, we need to cleansing data for accurate results. Sometimes one data source is not enough for our objectives. At that time we need to merge data from another data sources. Simply there are two way to merge data ;


In the above you can see the join types. Dont worry it is really easy just you neeed to do practice. The more important think that i want to say is Join just combines the columns not rows. You can thing that such as right-left join.


This also an option for data merge. Remember what we say in the above. Join merge the columns and union merge the rows basis. So the two way simply same but its just different dirrection.